What should you include in the recommendation?

You need to recommend a feature to support your backup solution.

What should you include in the recommendation?
A . Transparent Data Encryption (TDE)
B . Column-level encryption
C . An NTFS file permission
D . A Secure Sockets Layer (SSL)

View Answer

Answer: A

Explanation:

* Scenario: You must encrypt the backup files to meet regulatory compliance requirements. The encryption strategy must minimize changes to the databases and to the applications.

* Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery.