Microsoft
70-432 · Question #69
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…
The correct answer is D. For the CustomerDB database, enable Transparent Database Encryption and back up the. See the full explanation below for the reasoning.
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
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C6% (2)
- D81% (25)
Community Discussion
No community discussion yet for this question.