Microsoft Exam DP-300 Topic 3 Question 109 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 109
Topic #: 3

You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! 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?

ACreate a symmetric key in DB1.

BEnable visualization-based security (VBS) on Server1.

CCreate a certificate in DB1.

DCreate a certificate in the master database of SQLl.

Show Suggested Answer

Suggested Answer: B

by Kanisha at Jan 25, 2025, 02:36 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Malinda

2 days ago

Hmm, I'm not sure about enabling VBS on Server1. That seems like it might be overkill for just creating an encrypted backup. I'd go with creating a certificate in DB1 instead.

upvoted 0 times

...

Hoa

7 days ago

To encrypt the backup of DB1, I think creating a certificate in the master database of SQL1 is the way to go. Option D seems like the correct choice here.

upvoted 0 times

...