WHEN TRANSPARENT DATA ENCRYPTION (TDE) IS ENABLED, WHICH OF THE FOL...

8. When transparent data encryption (TDE) is enabled, which of the following

system catalog views will the database show as encrypted?

A. Sys.databases

B. Sys.all_objects

C. Sys.all_columns

D. Sys.configurations

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

“is_encrypted” column is not available in these system views.