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.

You have two SQL Server 2012 instances named SQLDev and SQLProd. You plan to create a new database
on SQLProd that will use SQL Server Authentication. You need to ensure that when the new database is copied
from SQLProd to SQLDev, users can connect to the database on SQLDev if they do not have a login on the
SQLDev instance. What should you use? More than one answer choice may achieve the goal. Select the BEST
answer

You have two servers named SQL1 and SQL2 that have SQL Server 2008 installed. SQL1 contains a database
that is mirrored asynchronously to SQL2. The database contents are updated once a month. You need to
upgrade the database to SQL Server 2012. The solution must minimize downtime. Which upgrade steps should
you recommend? 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 have four databases that are accessed by using an Online Transaction Processing (OLTP) application.
The databases are stored on a server named SQL1 that has SQL Server 2012 installed. You plan to deploy an
additional server that has SQL Server 2012 installed. You need to design a high-availability solution for the
databases that meets the following requirements:
If SQL1 fails, the databases must be available.
Users must be able to run reports against a secondary copy of the databases.
What should you include in the design? More than one answer choice may achieve the goal. Select the BEST
answer.

You have a SQL Server 2012 instance named SQL1. SQL1 creates error events in the Windows Application
event log. You need to recommend a solution that will run an application when SQL1 logs a specific error in the
Application log. Which SQL elements should you include in the recommendation? (Each correct answer
presents part of the solution. Choose all that apply.)

You have a SQL Server 2012 environment that contains 20 servers. The corporate security policy states that all
SQL Server 2012 instances must meet specific security standards. You need to recommend a management
strategy for the SQL Server 2012 servers. What should you include in the recommendation? More than one
answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2012 database named DB1. You plan to import a large number of records from a SQL
Azure database to DB1. You need to recommend a solution to minimize the amount of space used in the
transaction log during the import operation. What should you include in the recommendation?