PL-300 · Question #227
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…
The correct answer is A. Remove the rows in which sales [status] has a value of Canceled. D. "Users only use the DATE part of the Sales_Date". We can split date and time columns, it. 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.
Exhibit
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].
How the community answered
(30 responses)- A80% (24)
- B13% (4)
- C3% (1)
- E3% (1)
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.