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.

You deploy a database by using SQL Server 2012. The database contains a table named Table1. You need to
recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount
of custom code required. What should you recommend?

You deploy a database by using SQL Server 2012. The database contains a table named Table1. You need to
recommend a solution that meets the following requirements:
• Stores the most recent data from Table1 by using the fastest storage solution possible.
• Stores the historical data from Table1 by using a slower storage solution.
What should you recommend?

You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You
need to identify which transaction causes the deadlock. What should you do? More than one answer choice
may achieve the goal. Select the BEST answer.

You are designing two stored procedures named Procedure1 and Procedure2. You identify the following
requirements:
Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored
procedure.
Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure. Which technologies should you
identify? To answer, drag the appropriate technology to the correct stored procedure in the answer area.
(Answer choices may be used once, more than once, or not at all.)
Select and Place:

You are designing a SQL Server database for an order fulfillment system. You create a table named
Sales.Orders by using the following script:

Each order is tracked by using one of the following statuses:
Fulfilled
Shipped
Ordered
Received
You need to design the database to ensure that you can retrieve the status of an order on a given date. The
solution must ensure that new statuses can be added in the future. What should you do? More than one answer
choice may achieve the goal. Select the BEST answer.

You are designing an authentication strategy for a new server that has SQL Server 2012 installed. The strategy
must meet the following business requirements:
The account used to generate reports must be allowed to make a connection during certain hours only.
Failed authentication requests must be logged.
You need to recommend a technology that meets each business requirement. The solution must minimize the
amount of events that are logged. Which technologies should you recommend? To answer, drag the
appropriate solution to the correct business requirement in the answer area.
Select and Place: