Câu 19: PL-300: Microsoft Power BI Data Analyst

You have a Power BI query named Sales that imports the columns shown in the following table. Users only use the date 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 point.

1. A. Remove the rows in which Sales[Status] has a value of Canceled. — đáp án hiện tại
2. B. Remove Sales[Sales_Date].
3. C. Change the data type of Sale[Delivery_Time] to Integer.
4. D. Split Sales[Sale_Date] into separate date and time columns.
5. E. Remove Sales[Canceled Date]. — đáp án hiện tại