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 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate