Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are developing a Power BI Desktop report that contains a query named Staging_Product. The query is used only as an intermediate step for a merge operation and its data is not needed in the final data model that will be published. You need to minimize both the size of the model and the overall refresh duration while preserving the transformations performed by Staging_Product. What should you do in Power Query Editor?

  • Set the storage mode of Staging_Product to Dual so it is loaded only on demand.

  • Change Staging_Product to use DirectQuery storage mode.

  • Clear the Enable load option for Staging_Product so the query becomes connection-only.

  • Clear the Include in report refresh option for Staging_Product.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot