You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. The
package includes several data flows. Now you receive an e-mail from your company CIO,
according to his requirement, you have to make use of the Business Intelligence
Development Studio to monitor the data that passes through each path in the data flow.
Besides this, the company CIO also wants the data flow logic is retained. You have to
achieve this goal. So what action should you perform?
A.
In order to accomplish the task, the Audit transformation should be used
B.
In order to accomplish the task, the Data Viewer tool should be used
C.
In order to accomplish the task, you should use breakpoints in the Script component
D.
In order to accomplish the task, the Data Profiling task should be used