Check your knowledge

1.

When connecting to a SQL Server database to get data, what language should you use to extract data?

DAX

T-SQL

MDX

2.

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

Import

T-SQL

Live connection

3.

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

Remove unnecessary columns and rows

Export database files to CSV to load

Combine date and time columns into a single column

Knowledge Check

משוב