You are designing a database solution by using SQL Server 2008. The database has a
large number of tables that have columns that contain sensitive data. The sensitive data
must be protected. You need to choose an encryption strategy that has the minimum effect
on the performance of the server. What should you do? (More than one answer choice may
achieve the goal. Select the BEST answer.)
A.
Use Encrypting File System.
B.
Use Cell-Level Encryption.
C.
Use Bitlocker Encryption.
D.
Use Transparent Data Encryption (TDE).
Explanation: