CompTIA DataSys+ (DS0-001)Database Management and MaintenanceMedium
A database administrator is tasked with documenting the data flow and transformations that occur as data moves from various source systems, through an ETL process, and into a data warehouse. This documentation is crucial for understanding the origin, quality, and processing logic of the data. Which aspect of database documentation is the administrator focusing on?
- AData Lineage
- BPerformance Tuning Log
- CDatabase Schema Definition
- DData Dictionary
Show answer & explanationAnswer & explanation
Correct answer: A. Data Lineage
Data lineage documentation specifically tracks the origin, movement, and transformations of data as it flows through different systems and processes, which is exactly what the administrator needs to document for the ETL process into a data warehouse.
Why the other options are wrong
- B. A performance tuning log records changes made for performance optimization and their effects, unrelated to data flow documentation.
- C. Database schema definition describes the structure of tables, columns, and relationships within a single database, not the flow between systems.
- D. A data dictionary provides definitions and attributes for individual data elements, but doesn't typically detail the end-to-end flow and transformations.
Data Lineage
Documentation that describes the lifecycle of data, tracking its origin, transformations, and movement across various systems and processes within an organization.
- Essential for data governance, compliance, and auditing.
- Helps understand data quality issues and root causes.
- Often visualized using data flow diagrams.
Memory trick: Data Lineage is the data's journey, from birth to present.