Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
E is not an option as it is not stated to be used in the analysis. Only Sales_Date and Status were indicated to be used in the analysis
Option A removes all the rows that have Status value of Cancelled leaving the rows that have Status value of Finished with Null Values in the Cancelled Date column. Then Option B will apply to remove the Cancelled Date column so far it's no longer needed.
A is not controversial, E is correct because the aim is to reduce loading time (not the size of the model or anything else), option D on its own does not reduce the loading time, but option E does.