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?
A.
Create a SQL Common Language Runtime (SQLCLR) component that records all
transformation steps in a Microsoft SharePoint list.
B.
Create a version control repository for the transformation steps in Team Foundation
Server (TFS).
C.
Develop a custom data lineage solution.
D.
Develop a Data Quality Services (DQS) solution.
C