9. When transparent data encryption (TDE) is enabled, database backups are
encrypted. If you cannot locate the associated Certificate and private key files,
what happens to the data if you need to restore the encrypted database?
A. Everything will be readable since the Certificate and private key can be
recreated.
B. The data will not be readable since the Certificate and private key files are
lost.
C. Only encrypted columns will not be readable.
D. Everything will be readable once the database encryption has been turned
off in the master database.
The correct answer is B. Answers A, C, and D are incorrect since the original
Certificate and private key files are required to decrypt the database. It is very
important to store these files in a secure location other than with the database
backup to mitigate the possibility of not being able to decrypt a database.
Bạn đang xem 9. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P147 POTX