Microsoft DP-300 Exam - Topic 10 Question 56 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 56
Topic #: 10

You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password. You need to change the password for the private key. Which Transact-SQL statement should you run?

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: C

by James at Jun 24, 2022, 12:09 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rene

5 months ago

Nah, I disagree, D seems more appropriate for this scenario.

upvoted 0 times

...

Whitley

6 months ago

Definitely A, I've used it before for similar tasks.

upvoted 0 times

...

Dominga

6 months ago

Wait, can you really change the password like that? Sounds risky!

upvoted 0 times

...

Izetta

6 months ago

I think Option C might be better, not sure though.

upvoted 0 times

...

Lindsey

6 months ago

Option B is the correct choice for changing the password.

upvoted 0 times

...

Sharika

6 months ago

I think the answer could be Option A, but I vaguely remember there being a specific way to reference the private key. I hope I’m not mixing it up!

upvoted 0 times

...

Denae

6 months ago

I feel like Option C looks familiar, but I’m hesitant because I can't remember if it was specifically for changing the password or something else.

upvoted 0 times

...

Quentin

6 months ago

I remember practicing a similar question about changing passwords for certificates, but I can't recall the exact command. I hope it’s not too different.

upvoted 0 times

...

Leontine

7 months ago

I think we might need to use the ALTER CERTIFICATE statement, but I'm not completely sure which option has the correct syntax.

upvoted 0 times

...

Tess

7 months ago

This is a good question to test our understanding of SLAs. I think the key is ensuring the language and metrics used are clear and meaningful to all stakeholders, so I'd go with A.

upvoted 0 times

...

Izetta

7 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the different health monitor settings and how they might apply to verifying firewall functionality.

upvoted 0 times

...

Laura

7 months ago

Hmm, I'm a bit unsure about this one. I know DNS is related to domain name resolution, but I can't remember if it uses TCP or UDP. I'll have to think this through carefully.

upvoted 0 times

...

King

7 months ago

Okay, I think I've got a strategy for this. I'll compare the details of each vulnerability and consider the potential impact to different types of institutions.

upvoted 0 times

...