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

You manage a M

icrosoft 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. an SHA-256 hash

D. an AES 256-bit key

T

o encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key).

Example: in order to create an encrypted backup we must cr

eate a Database Master Key.

USE SampleDB

GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = MSSQLTips.com;

GO

We must create a certificate to act as an encryptor.

Use SampleDB

GO

CREATE CERTIFICATE SampleDB_Backup_Certificate

WITH SUBJECT = SQL

Server 2014;

GO

Now we are ready to create encrypted backups.

References: https://www.mssqltips.com/sqlservertip/3145/sql-server-2014-backup-encryption/