Question 369 of 388
Single answerHotspot QuestionYou 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.
✓ASee source PDF for answer choices.
BAdditional option
✓
Correct Answer: A
See source PDF for answer choices.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.