Microsoft
70-432 · Question #69
70-432 Question #69: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Question
You are the administrator SQL 2008 instance with a database named DB1. The company stores clients data in DB1. Clients can access their profile data by using a Web application. You must ensure the security of the customer data, you must ensure that even if the backup media is lost, data files, log files and subsequent backups and so on are quite safe. Which action should you perform to achieve this goal?
Options
- AFor both the CustomerDB database and the master database, enable Transparent Database
- BYou should use the built-in encryption functions to encrypt the sensitive data at the cell level.
- CYou should make the CustomerDB database accessible only through stored procedures and
- DFor the CustomerDB database, enable Transparent Database Encryption 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.