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:
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 file that
contains the tapped data.