Administering a SQL Database Infrastructure — Question 62

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?

Answer options

• A. a certificate
• B. an MD5 hash
• C. a DES key
• D. an AES 256-bit key

Correct answer: D

Explanation

The correct answer is D, as AES 256-bit key encryption provides a strong level of security for backups in SQL Server. Options A, B, and C do not meet the encryption requirements for secure backups; a certificate is not specifically for encryption, an MD5 hash is used for integrity checking, and a DES key is considered less secure compared to AES.