You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance that contains a database named TK_DB. TestKing.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. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application? (Select one or two.)
A.
You should consider adding a transaction Log on TK_DB, and set the information to be encrypted for a fixed time.
B.
Use BitLocker Drive Encryption on the hard drives on the SQL Server.
C.
Use EFS (Encrypting File System) on the hard drives on the SQL Server.
D.
You should consider enabling the Transparent Database Encryption on TK_DB and back up the transaction log.
E.
You should consider enabling the Transparent Database Encryption on TK_DB and
enabling the Transparent Database Encryption on master database.
F.
Use cell-level encryption for the specific data that needs to be kept safe.
Explanation:
With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now
have the choice between cell-level encryption as in SQL Server 2005, full database-level
encryption by using TDE, or the file-level encryption options provided by Windows. TDE is
the optimal choice for bulk encryption to meet regulatory compliance or corporate data
security standards. TDE works at the file level, which is similar to two Windows features:
the Encrypting File System (EFS) and BitLocker Drive Encryption, the new volume-level
encryption introduced in Windows Vista, both of which also encrypt data on the hard drive.
TDE does not replace cell-level encryption, EFS, or BitLocker.