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

Gerardo

3 days ago

I'm not sure, but I think creating a symmetric key in DB1 could also work for encrypting the backup.

upvoted 0 times

...

Mariann

7 days ago

I agree with Peggy, creating a certificate in DB1 would be the right choice for encrypting the backup.

upvoted 0 times

...

Peggy

10 days ago

I think the answer is C) Create a certificate in DB1.

upvoted 0 times

...