WHICH OF THE FOLLOWING BEST DESCRIBES TRANSPARENT DATA ENCRYPTION (...

2. Which of the following best describes transparent data encryption (TDE)?

A. Data in specific columns is encrypted.

B. Encrypts everything, such as indexes, stored procedures, functions, keys, etc,

without sacrificing security or leaking information on the disk.

C. Once data types have been changed to varbinary, everything will be

encrypted.

D. Once database schemas have been changed to accommodate data encryption,

everything will be encrypted.

The correct answer is B. Answer A refers to cell-level/column-level data

encryption. Answers C and D are incorrect since database changes are not

necessary in order to use TDE.