Question 229 of 388
Choose 2You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:The report will facilitate the following analysis:- The count of orders and the sum of total sales by Order Date- The count of customers who placed an order- The average quantity per orderYou need to reduce data refresh times and report query times.Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
✓AFilter the data to only the NorthWest region sales territory.
BRemove the CustomerKey and ProductKey columns.
✓CRemove the TaxAmt and Freight columns.
DSet the data type for SatesOrderNumber to Decimal Number
✓
Correct Answer: A, C
Filter the data to only the NorthWest region sales territory.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.