PrepAway - Latest Free Exam Questions & Answers

which is processed by the Web application. You need to keep the customer information safe since it is confiden

You work as a database administrator at Domain.com.
Domain.com is using a SQL Server 2008 instance that contains a database named CK_DB.
Domain.com contains a lot of customer data which is processed by the Web application.
You need to keep the customer information safe since it is confidential.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider adding a transaction Log on CK_DB, and set the information to be encrypted for a fixed time.

B.
You should consider enabling the Transparent Database Encryption on CK_DB and back up the transaction log.

C.
You should consider enabling the Transparent Database Encryption on CK_DB and then make a backup of the system data and the master database.

D.
You should consider making CK_DB running normal using stored procedures and functions that is set to encrypt data..


Leave a Reply