You plan to deploy SQL Server 2012. You identify the following security requirements for the deployment:
Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the
database engine.
All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor
overhead. Which features should you identify? To answer, drag the appropriate feature to the correct
requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. You are designing two stored procedures named SP1 and SP2 that have
the following requirements:
Prevent data read by SP1 from being modified by other active processes.
Prevent SP2 from performing dirty reads.
You need to recommend the isolation level for each stored procedure. The solution must maximize
concurrency. Which isolation levels should you recommend? To answer, drag the appropriate isolation level to
the correct stored procedure in the answer area.
Select and Place:

You plan to deploy a database to SQL Azure. You are designing two stored procedures named SP1 and SP2
that have the following requirements:
Prevent data read by SP1 from being modified by other active processes.
Allow SP2 to perform dirty reads.
You need to recommend the isolation level for the stored procedures. The solution must maximize concurrency.
Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct
stored procedure in the answer area.
Select and Place:

You plan to create a database. The database will be used by a Microsoft .NET application for a special event
that will last for two days. During the event, data must be highly available. After the event, the database will be
deleted. You need to recommend a solution to implement the database while minimizing costs. The solution
must not affect any existing applications. What should you recommend? More than one answer choice may
achieve the goal. Select the BEST answer.

You need to validate rows before they are added to a table every time a row is added using a user-defined
function. What should you use? More than one answer may achieve the goal. Select the BEST answer.

You need to recommend the actions that are required to partition a table. In which order should the four actions
be performed? To answer, move the actions from the list to the answer area and arrange them in the correct
order.
Build List and Reorder:

You need to recommend a backup process for an Online Transaction Processing (OLTP) database. The
process must meet the following requirements:
Ensure that if a hardware failure occurs, you can bring the database online with a minimum amount of data
loss.
Minimize the amount of administrative effort required to restore any lost data.
What should you include in the recommendation? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
Build List and Reorder:

You need to move a database in between servers. You need to guarantee database users will be able to login
in the database with a minimum of management effort. Select the BEST answer.

You need to grant access to a OLTP database regardless of the user operating the application. Which strategy
should you use? Select the BEST answer.

You need to ensure that a stored procedure fails if an INSERT statment within the stored procedure fails. What
action should you take?