You administer a SQL Server 2008 instance. A payroll application is used to store sensitive
data in a database named PayrollDB.
You plan to implement the following security measure: -All the data files, log files, and
backup files of the database are automatically encrypted. You need to devise a method to
encrypt data. What should you include in your solution?
A.
Use a certificate to protect the data encryption key. Export the certificate to a file.
B.
Use cell-level encryption to protect sensitive data.
C.
Use a symmetric key provisioned through Extensible Key Management (EKM).
D.
Use Transparent Data Encryption (TDE) for the PayrollDB database.