How can this be achieved and still keep the performance and functionality of the web application?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC.com contains a lot of customer data
which is processed by the Web application. You need to keep the customer information safe since
it is confidential. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application?
Select one or two.

A.
You should consider adding a transaction Log on ABC_DB, and set the information to be
encrypted for a fixed time.

B.
Use BitLocker Drive Encryption on the hard drives on the SQL Server.

C.
Use EFS (Encrypting File System) on the hard drives on the SQL Server.

D.
You should consider enabling the Transparent Database Encryption on ABC_DB and back up
the transaction log.

E.
You should consider enabling the Transparent Database Encryption on ABC_DB and enabling
the Transparent Database Encryption on master database.

F.
Use cell-level encryption for the specific data that needs to be kept safe.

Explanation:

With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have
the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by
using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for

bulk encryption to meet regulatory compliance or corporate data security standards. TDE works at
the file level, which is similar to two Windows® features: the Encrypting File System (EFS) and
BitLocker™ Drive Encryption, the new volume-level encryption introduced in Windows Vista®,
both of which also encrypt data on the hard drive. TDE does not replace cell-level encryption,
EFS, or BitLocker.