Exam PL-300 topic 2 question 79 discussion

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.

Suggested Answer: