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?

Question

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?

Accepted Answer

B. Use cell-level encryption to protect sensitive data.

Answer

A. Use a certificate to protect the data encryption key. Export the certificate to a file.

Answer

C. Use a symmetric key provisioned through Extensible Key Management (EKM).

Answer

D. Use Transparent Data Encryption (TDE) for the PayrollDB database.

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…

Question

Options

How the community answered

Community Discussion