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