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 confi

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

A. By configuring database mirroring.

B. By configuring a failover clust

er.

C. By partitioning the Orders table.

D. By partitioning a partitioned view of the Orders table.

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 st

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

A. Encrypting File System (EFS).

B. Transparent Data Encrypt

ion (TDE).

C. Windows Bitlocker Drive Encryption.

D. Secure Sockets Layer (SSL)