Home » Microsoft » 70-764 v.2 » How should you complete the Transact-SQL statement?
HOTSPOT
You manage a Microsoft SQL Server environment with a database named salesOrders. You plan to encrypt data during database backups You need to ensure that you can recover the database encryption keys.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
— Creates a backup of the "AdventureWorks2012" master key. Because this master key is not encrypted by the service master key, a password must be specified when it is opened.
USE AdventureWorks2012;
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘sfj5300osdVdgwdfkli7’;
BACKUP MASTER KEY TO FILE = ‘c:tempexportedmasterkey’
ENCRYPTION BY PASSWORD = ‘sd092735kjn$&adsg’;
GO
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/back-up-a-database-master-key?view=sql-server-2017