You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. The CorpDB database contains a table named
SalesInfo.
You discover that some information has been deleted from the SalesInfo table. You are
unable to find out who deleted the information.
You need to implement a solution to monitor the deletion of any further information from
the SalesInfo table. You want to minimize the development effort required for the solution.
What should you configure?

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) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
Company developers are testing a custom application. The developers report that
deadlocks often occur when the application runs a query. The developers have asked you
to help identify which transaction is causing the deadlocks.
How should you troubleshoot the issue?

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) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the no other transactions can modify data that has been read by
the stored procedure until the current transaction completes.
What should you do?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the stored procedure cannot perform dirty reads.
What should you do?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB.

A full backup of CorpDB is taken every week.
A differential backup of CorpDB is taken every night at midnight.
A transaction log backup of CorpDB is taken at 8am, 12pm, 4pm and 8pm.
You plan to deploy some changes to CorpDB at after the 4pm log backup completes. You
need to ensure that you can undo the changes quickly if the deployment fails. During the
deployment of the changes, no other changes must be made by users to the database.
You need a backup and recovery strategy for deploying the changes.
Which two of the following actions would meet the backup and recovery requirements
whilst ensuring the regular backup schedule is not disrupted? (Choose two).

You work as a Systems Administrator at a company named 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 by the 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 and log files are moved to another server, the files must be encrypted.
Which of the following solutions would meet the encryption requirement?

Your role as a Database Administrator (DBA) at ABC.com includes the management of the
Microsoft SQL Server 2012 database server infrastructure. All servers are members of a
single Active Directory Domain Services (AD DS) domain named ABC.com.
A database server named ABC-SQL1 runs Microsoft SQL Server 2012. You plan to create a
database on ABC-SQL1. Database users have logins configured on ABC-SQL1. The
database will be configured to use SQL Server 2012 authentication.
A recently installed database server named ABC-SQL2 also runs Microsoft SQL Server
2012. Only the default logins have been created on ABC-SQL2.
You need to ensure that you can copy the database from ABC-SQL1 to ABC-SQL2 and that
users can access the database without the need to configure logins for the users.
What should you do?

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?