Home » Microsoft » 70-462 v.2 » Which three actions should you perform in sequence?
DRAG DROP
You have a server that has SQL Server 2016 installed.
You need to configure native SQL Server backups for a database named Customers. The solution must use backup encryption.
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 orders.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
The following are prerequisites for encrypting a backup:
1. Create a Database Master Key for the master database:
2. Create a certificate or asymmetric Key to use for backup encryption.
3. You can encrypt a backup when creating the backup of a database in any of the following dialog boxes:
Back Up Database (Backup Options Page) On the Backup Options page, you can select Encryption, and specify the encryption algorithm and the certificate or asymmetric key to use for the encryption.
Using Maintenance Plan Wizard When you select a backup task, on the Options tab of the Define Backup ()Task page, you can select Backup Encryption, and specify the encryption algorithm and the certificate or key to use for the encryption.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption