Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and
Server2 that have SQL Server 2012 installed. The servers are located in separate building within your campus.
The latency of the WAN link between the buildings is less than 10 ms. You plan to implement an AlwaysOn
availability group on both servers. You need to recommend a failover type for the availability group. Whatshould you recommend?

Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and
Server2 that have SQL Server 2012 installed. Server1 is located in the Seattle office. Server2 is located in the
Montreal office. The latency of the WAN link between the Montreal office and the Seattle office is more than
200 ms. You plan to implement an AlwaysOn availability group on both servers. You need to recommend a
failover type for the availability group. What should you recommend?

You plan to install two SQL Server 2012 environments named Environment1 and Environment2. Your company
identifies the following availability requirements for each environment:
Environment1 must have mirroring with manual failover implemented.
Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2012 servers that must be deployed to each
environment to ensure that all data remains available if a physical server fails. How many servers should you
identify? To answer, drag the appropriate number to the correct environment in the answer area.
Select and Place:

You plan to install two SQL Server 2012 environments named Environment1 and Environment2. Your company
identifies the following availability requirements for each environment:
Environment1 must have mirroring with automatic failover implemented.
Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2012 servers that must be deployed to each
environment to ensure that all data remains available if a physical server fails. How many servers should you
identify? To answer, drag the appropriate number to the correct environment in the answer area.
Select and Place:

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: