HOTSPOT You have a query named All Sales that imports sales data into a Power BI model. You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
• Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.
• Minimize maintenance effort. What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Available Steps (2)
Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.
Minimize maintenance effort. What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Your Ordered Steps (0 of 2)
No steps added yet. Click "Add to Sequence" from the available steps above.
Explanation
Hotspot Solution:
Recommended Community Solution:
Answer: To create Sales Fact: Reference the All Sales query. - Using Reference instead of Duplicate ensures that any changes to the source query (All Sales) automatically flow through to the dependent queries (Sales Fact, Product Dimension, Customer Dimension). This minimizes maintenance effort because you only maintain transformations in one place. Clear Enable data load for: All Sales - The All Sales query is just a staging query (an intermediate step). It feeds the fact and dimension queries but doesn’t need to be loaded into the model itself. Disabling load prevents redundant data from being stored in the model, improving performance and keeping the schema clean.
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
1
* Answer: To create Sales Fact: Reference the All Sales query. - Using Reference instead of Duplicate ensures that any changes to the source query (All Sales) automatically flow through to the dependent queries (Sales Fact, Product Dimension, Customer Dimension). This minimizes maintenance effort because you only maintain transformations in one place. Clear Enable data load for: All Sales - The All Sales query is just a staging query (an intermediate step). It feeds the fact and dimension queries but doesn’t need to be loaded into the model itself. Disabling load prevents redundant data from being stored in the model, improving performance and keeping the schema clean.
