Question 640
A dashboard exhibits a one-day drop exactly when the upstream ETL job failed. What is the MOST appropriate Power BI design decision?
Explanation
Correct Answer
Pipeline failures create artifacts that can resemble real events, supporting separate data-quality disruption from business trend.
Incorrect Answers
Matched periods under consistent dimensions permit meaningful temporal comparison. It would address like-for-like adjacent weekly performance, not separate data-quality disruption from business trend.
Recurring peaks at similar calendar positions support a seasonality hypothesis. That targets evaluate annual holiday seasonality, not separate data-quality disruption from business trend.
Trend assessment separates systematic direction from short-term variation. It may suit distinguish trend from noise, not separate data-quality disruption from business trend.






Microsoft Power BI Data Analyst (PL-300) Practice Tests