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

Gwenn

13 days ago

Gotta love those tricky certification questions, am I right? Creating a certificate in the master database is the way to go, no doubt. Option D is the clear choice here.

upvoted 0 times

...

Hyman

14 days ago

Hold up, did you say SQL Server 2022? I've been living under a rock, I guess. Anyway, creating a certificate in the master database sounds like the right move. Option D for the win!

upvoted 0 times

...

Tamala

22 days ago

Ah, I see! We need to create a master key in the master database first, and then use that to create a certificate for the encrypted backup. Option D is the way to go.

upvoted 0 times

Lelia

2 days ago

Option D) Create a certificate in the master database of SQL1.

upvoted 0 times

...

Malinda

1 months 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

Dorcas

16 days ago

User3: Agreed, creating a certificate in DB1 should do the trick for creating an encrypted backup.

upvoted 0 times

...

Donette

17 days ago

User4: Definitely, creating a certificate in DB1 is the correct option.

upvoted 0 times

...

Xenia

20 days ago

User3: I agree, creating a certificate in DB1 should do the trick.

upvoted 0 times

...

Odette

20 days ago

User2: Yeah, that sounds like the right choice. It's a more targeted approach.

upvoted 0 times

...

Glynda

23 days ago

User1: I think creating a certificate in DB1 is the way to go.

upvoted 0 times

...

Essie

30 days ago

User2: Yeah, that sounds like the right choice.

upvoted 0 times

...

Jettie

1 months ago

User1: I think creating a certificate in DB1 is the way to go.

upvoted 0 times

...

Hoa

1 months 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

...