Question 227 of 388
Choose 2You have a Power Bl query named Sates that imports the columns shown in the following table. Users only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.You need to reduce the load times of the query without affecting the analysis.Which two actions achieve this goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one pant.
✓ARemove the rows in which sales [status] has a value of Canceled.
BChange the data type of sale [Delivery_Time] to IntegerC.Removes (Canceled Date).
✓DSplit Sales [Sale_Date] into separate date and time columns.
ERemove sales [Sales_Date].
✓
Correct Answer: A, D
Remove the rows in which sales [status] has a value of Canceled.
▥
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.