MDFT Academy Quizzes

Select all correct statements about DirectQuery

You have loaded a CSV data file with financial transactions into an Azure SQL Database. You want to show the data in a Power BI report and decide to import the data into a Power BI semantic dataset using the DirectQuery mode.

Please select all correct statements about DirectQuery in Power BI.

Choose all correct answers from the options below.

I'm sorry, your answers are not correct.

Power BI makes a copy of the data and stores it in the semantic dataset is incorrect. In DirectQuery mode, Power BI always queries the live data when generating reports.
DirectQuery can be used to generate reports for very large datasets is correct
In DirectQuery mode, the report always shows live data is correct
In DirectQuery mode, the data size is limited to 1 GB is incorrect. The 1 GB limit only applies to data loaded using Import mode.

YEPP Kick-Off

Select all correct statements about DirectQuery