Microsoft Exam Questions

You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups.

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 configur

e?

A. a certificate

B. an MD5 hash

C. a DES key

D. an AES 256-bit key

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 opt

ions:

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