You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

• A. CDC Splitter
• B. Audit
• C. Merge
• D. Pivot

You administer a Microsoft SQL Server 2012 database that has Trustworthy set to on. You create a stored procedure that returns database-level information from Dynamic Management Views.
You grant User1 access to execute the stored procedure.
You need to ensure that the stored procedure returns the required information when User1 executes the stored procedure. You need to achieve this goal by granting the minimum permissions required.
What should you do? Choose all that apply.

• A. Move the stored procedure to the User1 schema.
• B. Grant the db_datareader role on the database to User1.
• C. Grant the VIEW SERVER STATE permission to User1.
• D. Modify the stored procedure to include the EXECUTE AS OWNER statement. Grant VIEW SERVER STATE permissions to the owner of the stored procedure.
• E. Create a SQL Server login that has VIEW SERVER STATE permissions. Modify the stored procedure to include the EXECUTE AS {newlogin} statement.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are deploying a new SQL Server Integration Services (SSIS) package to several servers.
The package must meet the following requirements:
- INET Common Language Runtime (CLR) integration in SQL Server must not be enabled. - The Connection Managers used in the package must be configurable without editing the package. - The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?

• A. use the dtutll /copy command.
• B. create an OnError event handler.
• C. Run the package by using the dtexecui.exe utility and the SQL Log provider.
• D. use the Project Deployment Wizard.
• E. Deploy the package by using an msi file.
• F. Use the gacutil command.
• G. Add a data tap on the output of a component in the package data flow.
• H. Run the package by using the dtexec /dumperror /conn command.
• I. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
• J. create a reusable custom logging component.
• K. Run the package by using the dtexec /rep /conn command.

DRAG DROP
You administer three Microsoft SQL Server 2012 servers named ServerA, Servers, and ServerC.
ServerA is the acting principal and ServerB is the mirror.
You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB. You need to achieve this goal without delaying synchronization.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)