Microsoft
70-432 · Question #229
70-432 Question #229: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #229. The question stem and answer options stay visible for context.
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?
Options
- AUse a certificate to protect the data encryption key. Export the certificate to a file.
- BUse cell-level encryption to protect sensitive data.
- CUse a symmetric key provisioned through Extensible Key Management (EKM).
- DUse Transparent Data Encryption (TDE) for the PayrollDB database.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.