Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
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 configure?
Correct Answer: D
Explanation/Reference: Explanation: To 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 create 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/