🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 7 hours remaining!

CompTIA Data+ DA0-002 (V2) Practice Question

A data analyst is investigating a sales dashboard where the "Average Order Value" (AOV) metric appears significantly lower than historical averages. The analyst has already confirmed the source data is accurate and the report is refreshing correctly. The current AOV formula in the BI tool is SUM(Sales_Total) / COUNT(Order_ID). The analyst suspects the logic does not correctly account for returned orders, which are recorded as separate transactions with negative Sales_Total values. Which of the following is the most direct troubleshooting step to perform a calculation review?

  • Rerun the ETL job that loads data from the transactional database into the data warehouse to ensure data integrity.

  • Submit the report's source code and data model to another analyst for a peer review.

  • Manually calculate the AOV for a small, targeted sample of orders that includes both sales and returns, and then compare the result against the value shown in the report.

  • Apply a global filter to the dashboard to exclude all transactions with negative 'Sales_Total' values.

CompTIA Data+ DA0-002 (V2)
Visualization and Reporting
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot