You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. A server named ABC-SQL1 hosts multiple databases that are accessed using
OLTP (Online Transaction Processing) applications. You are concerned about the lack of redundancy provided
by this single server solution.
You want to configure a solution that ensures high-availability for the databases while minimizing costs. You
need to ensure that the databases remain online in the event of a hardware failure of ABC-SQL1. You configure
a second server named ABC-SQL2 and install SQL Server 2012. Which of the following solutions would
provide the high-availability and enable users to run reports on both copies of the databases?

You work as a Database Administrator (DBA) for a company named ABC.com. The company has a Windows
Azure subscription. The company uses a cloud based SQL Server environment hosted on SQL Azure.
Developers in your company are creating an ecommerce website. You are designing a database for the
website. The database will be hosted on SQL Azure. The database will store and reuse web site login details
and customer credit card numbers. You need to ensure the username, passwords and credit card details are
securely stored in the database. Which of the following would be the most suitable secure storage solution?

You work as a Database Administrator (DBA) at ABC.com. You are in the process of deploying new servers
running SQL Server 2012. You need to deploy a SQL Server 2012 server to host databases used to host
databases used by Research and Development department. The databases used by the Research and
Development department will store sensitive data. A company security policy states that if Research and
Development department database files are moved to another server, the files must be encrypted. Which of the
following solutions would meet the encryption requirement?

You work as a Database Administrator (DBA) at ABC.com. The company has a SQL Server 2008 R2
environment. You have a requirement for a temporary database that requires the features of SQL Server 2012.
The database must be highly available for one week while it is in use after which time the database will be
deleted. Your solution must not affect the current SQL Server environment. Which of the following is the best
solution to meet the requirement?

You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012
servers running SQL Server 2012. The Sales department uses a database named SalesDB. SalesDB contains
a large table named Orders that lists every order ever received by the company. You want to improve the
performance of SalesDB. You want to configure the database to provide the fastest possible access to the most
recent orders. Historical orders can be stored using a slower storage solution. How can you achieve this goal?

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:

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: