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.
Bạn đang xem 2. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS