W1 Lesson 2b Get Data in PowerBI

What is the primary purpose of Power Query in Power BI?

• Building dashboards

• Publishing reports

• Cleaning and transforming data

• Editing visuals

Which storage mode ensures you're always viewing the most recent version of the data?

• Import

• DirectQuery

• Dual

• Live Import

True or False: You can import data from SharePoint into Power BI using the Get Data feature.

• True

• False

Which tool helps analyze performance issues in Power BI transformations?

• Query Viewer

• Data Refresher

• Query Diagnostics

• SQL Editor

What is a key benefit of using query folding?

• Increased visuals

• Faster report loading by processing transformations at source

• Better visuals

• Bigger datasets

True or False: Power BI only supports structured relational data sources.

• True

• False

What language is typically used to write queries for SQL Server when retrieving specific columns?

• DAX

• M

• SQL

• Python

Which of the following is NOT a recommended performance optimization in Power BI?

• Process data at the source

• Use native SQL queries

• Always import all columns

• Avoid merging different sources

Multi-Select: Which are valid Power BI storage modes?

• Import

• DirectQuery

• Live Import

• Dual

Multi-Select: What are common sources Power BI can retrieve data from?

• Microsoft Excel

• SQL Server

• Photoshop

• Azure Analysis Services