Microsoft
70-463 · Question #123
70-463 Question #123: Real Exam Question with Answer & Explanation
The correct answer is B: The add_data_tap stored procedure should only be used to troubleshoot data issues.. The add_data_tap stored procedure in SSIS is intended only for troubleshooting data flow issues and requires the caller to be an administrator on the machine where the tap output files are written.
Question
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use of the add_data_tap stored procedure. Which of the following is TRUE with regards to using add_data_tap stored procedure? (Choose all that apply.)
Options
- ALimiting the number of rows that are captured during the data tap is not advisable.
- BThe add_data_tap stored procedure should only be used to troubleshoot data issues.
- CThe add data tap process is validated prior to the package being executed.
- DYou must be an administrator on the machine on which the stored procedure is run to open
Explanation
The add_data_tap stored procedure in SSIS is intended only for troubleshooting data flow issues and requires the caller to be an administrator on the machine where the tap output files are written.
Common mistakes.
- A. Limiting the number of rows captured IS advisable because uncapped data taps can generate very large files and negatively impact package performance during execution.
- C. The data tap process is NOT validated before the package executes - validation occurs at a separate stage and data tap configuration does not undergo pre-execution validation.
Concept tested. SSIS add_data_tap stored procedure usage and requirements
Community Discussion
No community discussion yet for this question.