Microsoft
DP-300 · Question #419
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server1 contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1. You create a master key…
The correct answer is D. Create a certificate in the master database of SQL1. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-an-encrypted-
Submitted by renata2k· Mar 6, 2026Implement a secure environment
Question
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server1 contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1. You create a master key in the master database of SQL1. You need to create an encrypted backup of DB1. What should you do?
Options
- ACreate a symmetric key in DB1.
- BEnable virtualization-based security (VBS) on Server1.
- CCreate a certificate in DB1.
- DCreate a certificate in the master database of SQL1.
How the community answered
(45 responses)- A2% (1)
- B9% (4)
- C7% (3)
- D82% (37)
Explanation
https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-an-encrypted-
Topics
#encrypted backup#certificate#master database#backup encryption
Community Discussion
No community discussion yet for this question.