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.
