Free Microsoft Power BI PL-300 Actual Exam Questions - Question 6 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. 
I’d create Sales Fact by referencing All Sales to keep everything linked and updated. Then, clear Enable Load on All Sales to avoid loading the raw data twice—less clutter and simpler upkeep.
Creating the Sales Fact query by referencing All Sales makes sure any updates in the source get reflected automatically without extra steps. Disabling Enable Load on the original All Sales query prevents it from loading twice, which keeps the dataset clean and reduces maintenance work. So, reference All Sales for the fact table and turn off loading on the All Sales query itself. That’s the simplest way to meet the requirements here.
Making Sales Fact by referencing All Sales keeps it synced automatically. Clearing Enable Load on All Sales avoids loading redundant data, so that’s the smart move for minimizing hassle.
Reference All Sales for Sales Fact, disable load on All Sales query.
Using reference for Sales Fact keeps it linked without extra copies. Clearing Enable Load on All Sales query makes sense to avoid loading that intermediate query twice and keeps maintenance easier.
I think the best way is to create the Sales Fact query by referencing All Sales, so it stays connected to the source without duplicating data. Then, you should clear Enable Load on the All Sales query itself because it acts like a staging query and you don’t want to load it into the model twice. The dimensions should keep load enabled since they’re used in the star schema. This setup minimizes maintenance since changes in All Sales flow through automatically without unnecessary duplicates.
Use reference for Sales Fact and disable load on All Sales query.