What should you include in your solution?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *