Microsoft
70-448 · Question #345
70-448 Question #345: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #345. The question stem and answer options stay visible for context.
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.