Which of the following solutions would meet the encryption requirement?

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?
A . Encrypting File System (EFS).
B . Transparent Data Encryption (TDE).
C . Windows Bitlocker Drive Encryption.
D . Secure Sockets Layer (SSL)

View Answer

Answer: B