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?

You need to design a stored procedure to update rows. The stored procedure must meet the following
requirements:
If more than one row is updated, an error must be raised to the application and the update must be
discarded.
The stored procedure must be designed to maximize concurrency.
What should you include in the design? 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 design a high availability strategy to guarantee database access in an event of server failure and
minimize data storage utilization. Which is the BEST solution?

You manage a SQL Server 2012 instance that contains a database named DB1. Users report that some
queries to DB1 take longer than expected. Although most queries run in less than one second, some queries
take up to 20 seconds to run. You need to view all of the performance statistics for each database file. Which
method should you use?

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the following
requirements:
The database schemas must be synchronized from SQLDev to SQLProd.
The database on SQLDev must be deployed to SQLProd by using a package.
The package must support being deployed to SQL Azure.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.