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?

You have a SQL Azure database named Database1. You need to design the schema for a table named table1.
Table1 will have less than one million rows. Table1 will contain the following information for each row:

The solution must minimize the amount of space used to store each row. Which data types should you
recommend for each column? To answer, drag the appropriate data type to the correct column in the answer
area.
Select and Place:

You have a server that has SQL Server 2012 installed. The server contains 100 user databases. You need to
recommend a backup solution for the user databases. The solution must meet the following requirements:
Perform a transaction log backup every hour.
Perform a full backup of each database every week.
Perform a differential backup of each database every day.
Ensure that new user databases are added automatically to the backup solution.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You have a server named SQL1 that has SQL Server 2012 installed. SQL1 hosts a database named
Database1. Database1 contains a table named Table1. Table1 is partitioned across five filegroups based on
the Date field. The schema of Table1 is configured as shown in the following table.

Table1 contains the indexes shown in the following table.

You need to recommend an index strategy to maximize performance for the queries that consume the indexes
available to Table1. Which type of index storage should you recommend? To answer, drag the appropriate
index storage type to the correct index in the answer area.
Select and Place:

You have a database named DB1. You plan to create a stored procedure that will insert rows into three different
tables. Each insert must use the same identifying value for each table, but the value must increase from one
invocation of the stored procedure to the next. Occasionally, the identifying value must be reset to its initial
value. You need to design a mechanism to hold the identifying values for the stored procedure to use. What
should you do? More than one answer choice may achieve the goal. Select the BEST answer.