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?
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..