You need to recommend a feature to support your backup solution. What should you include in the recommendation?

The correct answer is A. Transparent Data Encryption (TDE). 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

Submitted by viktor_hu· Mar 5, 2026Design database security solutions

Question

You need to recommend a feature to support your backup solution. What should you include in the recommendation?

Options

ATransparent Data Encryption (TDE)
BColumn-level encryption
CAn NTFS file permission
DA Secure Sockets Layer (SSL)

How the community answered

(39 responses)

A
85% (33)
B
5% (2)
C
3% (1)
D
8% (3)

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. Transparent Data Encryption (TDE)

Topics

#Transparent Data Encryption#Data at rest encryption#Backup security

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice