PL-300 · Question #382
You use Power Query Editor to preview a query that contains sales order data in the following columns: - Tax Amount - Sales Order ID - Freight Amount - Subtotal Amount - Total Item Quantity The Sales
Sign in or unlock PL-300 to reveal the answer and full explanation for question #382. The question stem and answer options stay visible for context.
Question
You use Power Query Editor to preview a query that contains sales order data in the following columns:
- Tax Amount
- Sales Order ID
- Freight Amount
- Subtotal Amount
- Total Item Quantity
The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount. You need to query the data to identify the following metrics by month:
- The average item quantity per order
- The average freight amount per order
- The maximum item quantity per order
How should you modify the query?
Options
- AIn the Total Item Quantity column, replace the null values with 0.
- BIn the Tax Amount column, remove rows that contain null values.
- CIn the Freight Amount column, remove rows that contain null values.
- DIn the Freight Amount column, replace the null values with 0.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 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.