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? A. In the Total Item Quantity column, replace the null values with 0. B. In the Tax Amount column, remove rows that contain null values. C. In the Freight Amount column, remove rows that contain null values. D. In the Freight Amount column, replace the null values with 0. Suggested Answer: D This question is in PL-300 Microsoft Power BI Data Analyst Exam For getting Microsoft Certified: Power BI Data Analyst Associate Certificate Disclaimers: The website is not related to, affiliated with, endorsed or authorized by Microsoft. The website does not contain actual questions and answers from Microsoft's Certification Exams. Trademarks, certification & product names are used for reference only and belong to Microsoft.
Please login or Register to submit your answer