What should you do?

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.