You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
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.)
A.
Limiting the number of rows that are captured during the data tap is not advisable.
B.
The add_data_tap stored procedure should only be used to troubleshoot data issues.
C.
The add data tap process is validated prior to the package being executed.
D.
You must be an administrator on the machine on which the stored procedure is run to open the
file that contains the tapped data.
Explanation: