You maintain a SQL Server 2008 instance that contains a database named CustomerDB.
The CustomerDB database 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. You want to achieve this
goal without affecting the Web application.
What should you do?
A.
Enable Transparent Database Encryption for both the CustomerDB database and the
master database.
B.
Encrypt the sensitive data at the cell level by using the built-in encryption functions.
C.
Make the CustomerDB database accessible only through stored procedures and
functions.
D.
Enable Transparent Database Encryption for the CustomerDB database and back up the
transaction log.