PL-300 · Question #227
PL-300 Question #227: Real Exam Question with Answer & Explanation
The correct answer is A: Remove the rows in which sales [status] has a value of Canceled.. A - Removing the Canceled ROWS will keep only Finished: “Only rows with a Status of Finished are used in analysis.” reduces the load times of the query which is a requirement here.
Question
You 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.
Options
- ARemove the rows in which sales [status] has a value of Canceled.
- BChange the data type of sale [Delivery_Time] to Integer
- CRemoves (Canceled Date).
- D"Users only use the DATE part of the Sales_Date". We can split date and time columns, it
- ERemove sales [Sales_Date].
Explanation
A - Removing the Canceled ROWS will keep only Finished: “Only rows with a Status of Finished are used in analysis.” reduces the load times of the query which is a requirement here.
Topics
Community Discussion
No community discussion yet for this question.