Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 — Question 29

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. A package in the project extracts data from a
Microsoft Azure SQL Database. The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

Answer options

• A. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
• B. Execute the catalog.add_data_tap stored procedure with the package execution_id.
• C. Run the DTEXEC utility with the /Reporting V option.
• D. Run the DTEXEC utility with the /Logger option.

Correct answer: D

Explanation

The correct answer is D because using the /Logger option with the DTEXEC utility allows for detailed logging of the package execution, which can generate the necessary debug files. Options A and B involve stored procedures that do not directly relate to generating the specified debug files, while option C focuses on a reporting feature rather than logging for troubleshooting.