What should you configure?

You manage a Microsoft SQL Server environment.

You plan to encrypt data when you create backups.

You need to configure the encryption options for backups.

What should you configure?
A . a certificate
B . an MD5 hash
C . a DES key
D . an AES 256-bit key

View Answer

Answer: D

Explanation:

To encrypt during backup, you must specify an encryption algorithm, and an encryptor to secure the encryption key. The following are the supported encryption options: Encryption Algorithm: The supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES Encryptor: A certificate or asymmetric Key

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup­encryption