Microsoft
70-450 · Question #57
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…
The correct answer is D. Use Transparent Data Encryption (TDE). See the full explanation below for the reasoning.
Question
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.)
Options
- AUse Bitlocker Encryption.
- BUse Cell-Level Encryption.
- CUse Encrypting File System.
- DUse Transparent Data Encryption (TDE).
How the community answered
(33 responses)- A6% (2)
- B3% (1)
- C9% (3)
- D82% (27)
Community Discussion
No community discussion yet for this question.