70-463 · Question #174
70-463 Question #174: Real Exam Question with Answer & Explanation
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
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.
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.
Community Discussion
No community discussion yet for this question.