DP-700 · Question #69
DP-700 Question #69: Real Exam Question with Answer & Explanation
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.
Question
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 | 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 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.
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.