You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost

You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores
customer data for the company. The customers use a Web application to access their profile
data.

You need to protect the customer data such that data files, log files, and subsequent
backups are as secure as possible even if the backup media is lost. Your solution must not
affect the Web application or impact performance.
What should you do?

A.
Encrypt the customer data at the cell level and then back up DB1.

B.
Configure access to DB1 to only use stored procedures and functions.

C.
Enable Transparent Database Encryption for DB1 and then back up the transaction logs.

D.
Encrypt the customer data at the folder level by using Encrypted File System (EFS) and
then back up the transaction logs.