⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

1 day, 22 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

During the monthly refresh of a sales dashboard, an ETL pipeline ingests a third-party CSV file into a staging table and then loads it into the data warehouse. After the most recent run, thousands of rows now display NULL in the Customer_ID column, so lookup joins in downstream reports fail. A quick inspection shows the vendor changed the file delimiter from a comma to a pipe (|), shifting every field by one position. Which report-validation technique, if it had been executed immediately after the staging load, would most likely have detected this corrupt data before it reached the dashboard?

  • Add a calculated field in the dashboard that substitutes "Unknown" for any NULL Customer_ID value.

  • Increase the ETL job frequency from monthly to hourly so future files are processed sooner.

  • Apply corporate branding and color-scheme guidelines to the dashboard template before publication.

  • Perform a source-to-target reconciliation that checks row counts and column-level hash totals between the CSV and the staging table.

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.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot