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...

Questions › Category: PL-300 › 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…

0 Vote Up Vote Down

Admin Staff asked 6 months ago

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.

A. Remove the rows in which Sales[Status] has a value of Canceled.

B. Remove Sales[Sales_Date].

C. Change the data type of Sale[Delivery_Time] to Integer.

D. Split Sales[Sale_Date] into separate date and time columns.

E. Remove Sales[Canceled Date].






 

Suggested Answer: AD

A: Removing uninteresting rows will increase query performance.
D: Splitting the Sales_Date column will make comparisons on the Sales date faster.

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate