You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.
The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.
You need to meet the requirements by using the least amount of administrative effort.
What should you do?

• A. Create one XML configuration file. Add a connection string for each target server. Choose the appropriate server in the package at build time.
• B. Create one registry configuration. Add a connection string for each target server. Choose the appropriate server in the package at build time.
• C. For each target server, create a separate package and include each package in the SSIS catalog. Run the appropriate server at package execution time.
• D. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.

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 writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?

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

DRAG DROP
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.
You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.
Which four 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.)

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

• A. Perform a file restore.
• B. Perform a transaction log restore.
• C. Perform a filegroup restore.
• D. Perform a restore from a full backup.

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found.
After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable.
You need to set the precedence constraints.
Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.)