ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam
Go to Exam

Exam 70-463 topic 3 question 75 discussion

Actual exam question from Microsoft's 70-463
Question #: 75
Topic #: 3
[All 70-463 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
References: https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility
by mickeygeorge at July 16, 2020, 9:39 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mickeygeorge
4 years, 10 months ago
Looks to be wrong choices listed here.Think it should be to use DTEXEC utility with /DebugDump option
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel