Microsoft
70-448 · Question #345
You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Integration Services (SSIS) solution contains 10 packages. All packages perform the extract, transform…
The correct answer is D. Add an Audit Transformation component within the Data Flow task. See the full explanation below for the reasoning.
Question
You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Integration Services (SSIS) solution contains 10 packages. All packages perform the extract, transform, and load (ETL) tasks to populate a data warehouse. The packages are deployed to multiple servers and executed by several users. You need to log the user and start time for each package execution as columns in the destination tables of the data warehouse. What should you do?
Options
- AAdd a Data Profiling task to the Control Flow task.
- BAdd a SQL Server Profiler Log Provider to the package.
- CAdd a Transfer Logins component to the Control Flow task.
- DAdd an Audit Transformation component within the Data Flow task.
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C3% (1)
- D83% (24)
Community Discussion
No community discussion yet for this question.