In Power Query Editor, you have a query named Sales Data that contains the following columns. You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Questions › Category: PL-300 › In Power Query Editor, you have a query named Sales Data that contains the following columns. You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

0 Vote Up Vote Down

Admin Staff asked 4 months ago

In Power Query Editor, you have a query named Sales Data that contains the following columns.
 
You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Reference the Sales Data query to create the new queries.

B. Disable the load for the Sales Fact query.

C. Duplicate the Sales Data query to create the new queries.

D. Clear Include in report refresh for the Sales Data query.

E. Disable the load for the Sales Data query.






 

Suggested Answer: AE



This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.