Question 362 of 388
Choose 2In 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.
✓AReference the Sales Data query to create the new queries.
BDisable the load for the Sales Fact query.
CDuplicate the Sales Data query to create the new queries.
DClear Include in report refresh for the Sales Data query.
✓EDisable the load for the Sales Data query.
✓
Correct Answer: A, E
Reference the Sales Data query to create the new queries.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.