Exam PL-300 topic 2 question 123 discussion

HOTSPOT
-

You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet.

Sales_Spreadsheet contains the following columns:

• Customer ID
• Customer Name
• Date
• Total Sales Amount

You plan to use the Sales Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements:

• The Customer query must contain the Customer ID and Customer Name columns.
• The Sales query must contain the Customer ID, Date, and Total Sales Amount columns.
• Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure that only one location is used to update the logic.

You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model?

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Suggested Answer: