70-463 · Question #174
You are designing an extract, transform, and load (ETL) solution that loads data into dimension tables. The ETL process involves many transformation steps. You need to ensure that the design can provi
The correct answer is C. Develop a custom data lineage solution.. Data lineage is the discipline of tracking the origin, movement, transformations, and final destination of data throughout its lifecycle. A custom data lineage solution addresses both requirements directly: it can capture audit metadata (who loaded what, when, from which source,
Question
You are designing an extract, transform, and load (ETL) solution that loads data into dimension tables. The ETL process involves many transformation steps. You need to ensure that the design can provide:
- Auditing information for compliance and business user acceptance
- Tracking and unique identification of records for troubleshooting and
error correction What should you do?
Options
- ACreate a SQL Common Language Runtime (SQLCLR) component that records all
- BCreate a version control repository for the transformation steps in Team Foundation
- CDevelop a custom data lineage solution.
- DDevelop a Data Quality Services (DQS) solution.
How the community answered
(46 responses)- A17% (8)
- B4% (2)
- C70% (32)
- D9% (4)
Explanation
Data lineage is the discipline of tracking the origin, movement, transformations, and final destination of data throughout its lifecycle. A custom data lineage solution addresses both requirements directly: it can capture audit metadata (who loaded what, when, from which source, through which transformation steps) for compliance, and it can assign and persist unique identifiers to records for troubleshooting and error correction. A SQLCLR component (A) is a low-level implementation mechanism, not an architectural solution. Version control (B) tracks source code changes, not data movement. Data Quality Services (D) focuses on cleansing and matching data, not on lineage or audit trails.
Topics
Community Discussion
No community discussion yet for this question.