During a data-quality incident review, an entry-level analyst notices that the "Average Order Value" metric on an executive dashboard spiked immediately after a weekend ETL deployment. Before rolling back the job, the analyst must trace the metric through every upstream table and transformation and see which other dashboards or models would be affected by any fix. Which type of documentation will provide the complete, end-to-end record of how the metric's data is sourced, transformed, and loaded across systems?
An end-to-end data lineage document for the metric
A hierarchy structure diagram of the order data domain
The data dictionary entry that defines the metric's fields
The original system-level data-flow diagram created during design
Documentation that captures data lineage shows the full journey of a data element-from its original data source, through each ETL transformation and intermediate table, to the final report or model. Because it records both upstream inputs and downstream dependencies, the analyst can isolate the step where the ETL change introduced the error and gauge the impact on other assets. A data dictionary only defines fields and their business meaning; it does not map the path those fields take. A hierarchy structure diagram organizes data elements in parent-child relationships but lacks transformation details. A data-flow diagram illustrates high-level system flows defined during design time, yet it rarely includes the historical, step-by-step view required for root-cause or impact analysis.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is data lineage, and why is it important in data analysis?
Open an interactive chat with Bash
What is an ETL process, and how does it relate to data lineage?
Open an interactive chat with Bash
How does a data dictionary differ from a data lineage document?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Data Governance
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .