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:

You are designing a monitoring application for a new SQL Server 2012 instance. You need to recommend asolution to generate a report that displays the 10 most frequent wait types that occur for the instance. What
should you include in the recommendation? More than one answer choice may achieve the goal. Select the
BEST answer.

You are designing a database named DB1. Changes will be deployed to DB1 every Wednesday night. You
need to recommend a strategy to deploy the changes to DB1. The strategy must meet the following
requirements:
The strategy must not disrupt backup operations.
DB1 must be unavailable to users while the changes are deployed.
You must be able to undo quickly the entire operation.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

You are designing a database for a university. The database will contain two tables named Classes and
StudentGrades that have the following specifications:
• Classes will store brochures in the XPS format. The brochures must be structured in folders and must be
accessible by using UNC paths.
• StudentGrades must be backed up on a separate schedule than the rest of the database.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies
should you identify? To answer, drag the appropriate technology to the correct table in the answer area.
Select and Place:

You are designing a database for a university. The database will contain two tables named Classes and
Enrollment that have the following specifications:
• Classes will store brochures in the XPS format. The brochures must be structured in folders and must be
accessible by using UNC paths.
• Enrollment will store information about students and their classes. Performance must be enhanced for
queries of the current enrollments.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies
should you identify?
To answer, drag the appropriate technology to the correct table in the answer area.
Select and Place: