Microsoft
DP-700 · Question #69
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns. Table name | Column name | Description ---|---|--- SalesOrderDetail | ProductID | Contai
Sign in or unlock DP-700 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Ingest and transform data
Question
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.
You need to create an output that presents the summarized values of all the order quantities by year and product. The results must include a summary of the order quantities at the year level for all the products.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
| Table name | Column name | Description |
|---|---|---|
| SalesOrderDetail | ProductID | Contains the product ID of the ordered product |
| SalesOrderDetail | ModifiedDate | Contains the date of an order |
| SalesOrderDetail | OrderQty | Contains the order quantity |
| Product | ProductID | Contains the unique ID of a product |
| Product | Name | Contains a product name |
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Queries#Aggregation#Grouping Functions#Data Transformation