Microsoft
70-432 · Question #191
You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application to access their…
The correct answer is D. Enable Transparent Database Encryption for the CustomerDB database and back up the. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database 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. You want to achieve this goal without affecting the Web application. What should you do?
Options
- AEnable Transparent Database Encryption for both the CustomerDB database and the master
- BEncrypt the sensitive data at the cell level by using the built-in encryption functions.
- CMake the CustomerDB database accessible only through stored procedures and functions.
- DEnable Transparent Database Encryption for the CustomerDB database and back up the
How the community answered
(43 responses)- A2% (1)
- B14% (6)
- C7% (3)
- D77% (33)
Community Discussion
No community discussion yet for this question.