WHAT LEVEL OF PROTECTION DOES TRANSPARENT DATA ENCRYPTION (TDE) PRO...

1. What level of protection does transparent data encryption (TDE) provide?

A. Cell-level

B. File-level

C. Database-level

D. Drive-level

The correct answer is C. Answers A, B, and D are incorrect because TDE

is designed to provide database-level specifically. Cell-level data encryption

is a different method of data encryption provided by SQL Server 2008 and

file-level (or EFS) and drive-level (bitLocker) are Windows features.