DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ11

Monitor, configure, and optimize database resources

You have an Azure virtual machine named Server1 running Windows Server 2022. Server1 hosts a Microsoft SQL Server 2022 instance named SQL1 and a database named DB1.

You create a master key in the master database on SQL1.

You need to create an encrypted backup of DB1.

What should you do?

Explanation

Encrypted SQL Server backups require a database master key in the master database and a certificate or asymmetric key on the SQL Server instance. Since the master key already exists in master, creating a certificate there supplies the required encryptor for the DB1 backup.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!