Microsoft
70-432 · Question #121
You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores customer data for the company. The customers use a Web application to access their profile data. You need to…
The correct answer is C. Enable Transparent Database Encryption for DB1 and then back up the transaction logs. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 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. Your solution must not affect the Web application or impact performance. What should you do?
Options
- AEncrypt the customer data at the cell level and then back up DB1.
- BConfigure access to DB1 to only use stored procedures and functions.
- CEnable Transparent Database Encryption for DB1 and then back up the transaction logs.
- DEncrypt the customer data at the folder level by using Encrypted File System (EFS) and then
How the community answered
(49 responses)- A4% (2)
- B16% (8)
- C71% (35)
- D8% (4)
Community Discussion
No community discussion yet for this question.