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 t

o 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?

A. You should configure SQL Server Agent jobs.

B. You should configure Change Data Capture.

C. You should configure Policy-Based Management.

D. You should configure a Maintenance Plan.

You work as a Database Administrator (DBA) for a company named ABC.com.

The company u

ses 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?

A. You should configure the asynchronous manual failover failover type.

B. You should configur

e the synchronous manual failover failover type.

C. You should configure the synchronous automatic failover failover type.

D. You should configure the Asynchronous automatic failover failover type.

You work as a Database Admi

nistrator (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 serve

rs 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?

A. You should configure the asynchronous

manual failover failover type.

B. You should configure the synchronous manual failover failover type.

C. You should configure the synchronous automatic failover failover type.

D. You should configure the Asynchronous automatic failover failover type.

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 differen

tial 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 chan

ges 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 backu

p and recovery requirements whilst ensuring the regular backup schedule is not disrupted? (Choose two.)

A. Take a full backup of the database before deploying the changes.

B. Take a copy-only backup of the database before deploying the changes.

C. Take a

snapshot of the database before deploying the changes.

D. Restore the database from the backup.

E. Restore the snapshot to another server and recover the required objects from the snapshot.

F. Revert the database to the snapshot.

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. CorpDB contains a table named SalesInfo.

You discover that some table has been deleted from the SalesInfo table.

You are unable to find out who deleted the information.

You need to impl

ement 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?

A. You should configure table permissions.

B. You should conf

igure a user role.

C. You should configure change data capture.

D. You should configure a trigger.

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 supports dirty reads. What should you do?

A. You should configure the stored procedure to use

the READ UNCOMMITTED isolation level.

B. You should configure the stored procedure to use the READ COMMITTED isolation level.

C. You should configure the stored procedure to use the READ SERIALIZABLE isolation level.

D. You should configure the stored pro

cedure to use the REPEATABLE READ isolation level.

E. You should configure the stored procedure to use the SNAPSHOT isolation level.

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 det

ails 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?

A. Secure Sockets Layer (SSL)

B. IP

Sec

C. Data encryption

D. Transparent Data Encryption (TDE)

E. Encrypting File System (EFS)

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 en

sures 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 ABCSQL1.

You configure a second server named ABC-SQL2 and install SQL Server 2012.

Which of the f

ollowing solutions would provide the high-availability and enable users to run reports on both copies of the databases?

A. AlwaysOn availability groups

B. A failover cluster

C. Database mirroring

D. Transaction log shipping

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 dis

cover 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

you configure?

A. You should configure an alert and a job.

B. You should configure an alert and a maintenance plan.

C. You should configure a trigger and a maintenance plan.

D. You should configure a trigger and a job.

E. You should configure an alert

and a trigger.