M02: Preparación de datos en Power BI

Which query language do you use to extract data from Microsoft SQL Server?

• DAX

• T-SQL

• MDX

Answer explanation

Should include a statement that if you don't need an entire table, you can query the data directly using T-SQL.)

You’re creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?

• Connect Live

• Import

• Direct Query

Answer explanation

Should include a statement that references that when the data refreshes in the cube, you would like to see it immediately in the Power BI report.)

Which storage mode leaves the data at the data source?

• Import

• Direct Query

• Dual

Answer explanation

Should include a statement that includes that the Import mode allows you to create a local Power BI copy of your datasets from your data source. DirectQuery creates a direct connection to the data source, ensuring your data is not cached and you are always viewing the most up-to-date data. Dual, identifies some data to be directly imported and other data that must be queried.

Which technology improves performance by generating a single query statement to retrieve and transform source data?

• Query folding

• Adding index columns

• Adding custom columns with complex logic

Answer explanation

Should include a statement that includes that query folding is the process that lets Power Query generate a single query statement to retrieve and transform source data. The benefits include more efficiency in data refreshes and incremental refreshes and automatic compatibility with DirectQuery and Dual storage modes

What can you do to improve performance when you are getting data in Power BI?

• What can you do to improve performance when you are getting data in Power BI?

• Use the Select SQL statement in your SQL queries when you are pulling data from a relational database

• Combine date and time columns into a single column

• Do some calculations in the original data source

Answer explanation

Should include a statement that references hardware resources are being constrained by concurrent users using the same data.