Question

You handle a Microsoft SQL Server environment. You plan to encrypt data when you create a backup. What should you configure?

A. MD5 hash
B. certificate
C. AES 256 bit key
D. DES

Answer 1

To encrypt data during a backup in a Microsoft SQL Server environment, you should configure a certificate, which contains a public key for encryption and a private key for decryption.

Step-by-step explanation:

When encrypting data during a backup in a Microsoft SQL Server environment, you should configure a certificate. A certificate is a digital object that is used to encrypt and decrypt data. It contains a public key that is used to encrypt data during the backup process, and a private key that is used to decrypt the data when it is restored.

Configuring a certificate ensures that the data is protected and can only be accessed by those with the corresponding private key. Other options like MD5 hash, AES 256 bit key, and DES are not suitable for encrypting data during backup.

For example, if you have a certificate named 'BackupCert', you can use the following command to encrypt data during a backup:

BACKUP DATABASE YourDatabase TO DISK = 'C:\Backup\YourDatabase.bak' WITH ENCRYPTION (ALGORITHM = AES_256, SERVER CERTIFICATE = BackupCert)