SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn
availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The
two datacenters are connected by a WAN link with a network latency of more than 200ms. Which of the
following failover types should you configure for the availability group?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn
availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The
two datacenters are connected by a fast WAN link with a network latency of less than 10ms. Which of the
following failover types should you configure for the availability group?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. The sales and marketing departments contain a total of 60 users. Each user
uses a custom application that stores data in a SQL Server database. Each user has a separate database. A
server named ABC-SQL1 hosts the 60 databases. You need to configure a backup solution for all the
databases. The solution must ensure that any new databases configured on ABC-SQL1 are automatically
added to the backup schedule. The backup schedule consists of a full backup every night, a differential backup
every hour and a transaction log backup every 15 minutes. How should you configure the backup solution?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. Computer users use custom applications that store data in SQL Server
databases hosted on a server named ABC-SQL1. You discover that the Windows Application event log on
ABC-SQL1 contains error events. You need to configure a solution that will run an application whenever an
event with a specific event ID number is generated in the Windows Application event log. What should youconfigure?

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: