MENU
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?
A)
B)
C)
D)
Suggested Answer: C
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
13 comments · newest first
RE
Rene
11 months ago
Nah, I disagree, D seems more appropriate for this scenario.
WH
Whitley
11 months ago
Definitely A, I've used it before for similar tasks.
DO
Dominga
12 months ago
Wait, can you really change the password like that? Sounds risky!
IZ
Izetta
12 months ago
I think Option C might be better, not sure though.
LI
Lindsey
1 year ago
Option B is the correct choice for changing the password.
SH
Sharika
1 year 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!
DE
Denae
1 year 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.
QU
Quentin
1 year 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.
LE
Leontine
1 year ago
I think we might need to use the ALTER CERTIFICATE statement, but I'm not completely sure which option has the correct syntax.
TE
Tess
1 year 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.
IZ
Izetta
1 year 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.
LA
Laura
1 year 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.
KI
King
1 year 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.