70-463 · Question #123
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…
The correct answer is B. The add_data_tap stored procedure should only be used to troubleshoot data issues. D. You must be an administrator on the machine on which the stored procedure is run to open. 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
How the community answered
(27 responses)- B96% (26)
- C4% (1)
Why each option
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.
Limiting the number of rows captured IS advisable because uncapped data taps can generate very large files and negatively impact package performance during execution.
add_data_tap is a diagnostic tool designed specifically to capture data flow output at a given data flow path for troubleshooting purposes - it is not intended for production use or routine data capture.
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.
Because the stored procedure writes data tap output files to the file system of the server running the package, the caller must have administrator privileges on that machine to create and access those files.
Concept tested: SSIS add_data_tap stored procedure usage and requirements
Source: https://learn.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-add-data-tap
Topics
Community Discussion
No community discussion yet for this question.