Home » Microsoft » 70-764 v.2 » 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 encryption the SQL backups.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
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