You plan to deploy three highly available SQL Server environments that will use SQL Server 2012. You identify
the following specifications for each environment as shown following table.

You need to recommend which high-availability feature is required for each environment. Which features
should you identify? To answer, drag the appropriate feature to the correct requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. Your company identifies the following monitoring requirements:
Tempdb must be monitored for insufficient free space.
Deadlocks must be analyzed by using Deadlock graphs.
You need to identify which feature meets each monitoring requirement. Which features should you identify? To
answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. Your company identifies the following monitoring requirements for the
database:
The name of all stored procedures must start with “usp_” always.All distribution statistics must be updated daily.
You need to identify which feature must be used to meet each database requirement. Which features should
you identify?
Select and Place:

You plan to deploy SQL Server 2012. Your company identifies the following monitoring requirements for the
database:
An e-mail message must be sent when a user logs in.
An e-mail message must be sent if CPU utilization exceeds 90 percent.
You need to identify which feature meets each monitoring requirement. Which features should you identify? To
answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. Your company identifies the following monitoring requirements for the
database:
An e-mail message must be sent if the SQL Server Authentication mode changes.
An e-mail message must be sent if CPU utilization exceeds 90 percent.
You need to identify which feature meets each monitoring requirement. Which features should you identify? To
answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the
following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of
the time.
Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows. You need to recommend which options must be
defined for the columns. The solution must minimize the storage requirements for the tables. Which options
should you recommend? To answer, drag the appropriate options to the correct column in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. You identify the following security requirements for the deployment:
Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the
database engine.
All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor
overhead. Which features should you identify? To answer, drag the appropriate feature to the correct
requirement in the answer area.
Select and Place:

You plan to deploy SQL Server 2012. You are designing two stored procedures named SP1 and SP2 that have
the following requirements:
Prevent data read by SP1 from being modified by other active processes.
Prevent SP2 from performing dirty reads.
You need to recommend the isolation level for each stored procedure. The solution must maximize
concurrency. Which isolation levels should you recommend? To answer, drag the appropriate isolation level to
the correct stored procedure in the answer area.
Select and Place:

You plan to deploy a database to SQL Azure. You are designing two stored procedures named SP1 and SP2
that have the following requirements:
Prevent data read by SP1 from being modified by other active processes.
Allow SP2 to perform dirty reads.
You need to recommend the isolation level for the stored procedures. The solution must maximize concurrency.
Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct
stored procedure in the answer area.
Select and Place:

You plan to create a database. The database will be used by a Microsoft .NET application for a special event
that will last for two days. During the event, data must be highly available. After the event, the database will be
deleted. You need to recommend a solution to implement the database while minimizing costs. The solution
must not affect any existing applications. What should you recommend? More than one answer choice may
achieve the goal. Select the BEST answer.