Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: A. Reference the Sales Data query to create the new queries. E. Disable the load for the Sales Data query. * Explanation: A. - Referencing means both new queries inherit transformations from the base query. If the source changes, you only update once. This is leaner than duplicating, which creates independent copies. E. - The base query is just a staging query. You don’t need it in the model, only its references (Product Dimension and Sales Fact). Disabling load keeps the model lean. * Why not the others: B. - You need the Sales Fact table in the model, so you must load it. C. - Duplicating creates separate copies, which increases maintenance effort and memory usage. Not optimal. D. - You still want the query to refresh, since it’s the source for both dimension and fact.
A. Reference the Sales Data query Referencing creates a linked query that inherits transformations from the original. This minimizes maintenance effort — changes to Sales Data automatically flow to Product Dimension and Sales Fact. It avoids duplicating logic and keeps your queries DRY (Don't Repeat Yourself). E. Disable the load for the Sales Data query Since Sales Data is only used as a staging query, there's no need to load it into the data model. Disabling load reduces dataset size and improves performance.
A. Reference the Sales Data query to create the new queries. • Referencing the Sales Data query allows you to create new queries (Product Dimension and Sales Fact) that are based on the original data without duplicating it. E. Disable the load for the Sales Data query. Disabling the load for the Sales Data query ensures that the data from this query is not loaded into the data model, which helps minimize the size of the dataset. The Product Dimension and Sales Fact queries will still have access to the data, but the original Sales Data query won't consume additional resources by being loaded into the model.