Which three actions should you perform in sequence?

DRAG DROP

You store Microsoft SQL Server backups at an off-site location that has no protection from unauthorized access. Your organization has not implemented hardware security modules (HSM).

You need to implement a solution for encrypting the SQL backups.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Step 1: Create a database master key of the master database.

Step 2: Create a certificate for the backups. Create a Backup Certificate: Create a backup certificate in the master database.

Step 3: Backup the database: Specify the encryption algorithm and certificate to use.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-an­encrypted-backup?view=sql-server-2017