Microsoft
70-432 · Question #191
70-432 Question #191: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #191. The question stem and answer options stay visible for context.
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
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.