Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-900 Exam - Topic 3 Question 73 Discussion

Posted by Kristeen on Dec 23, 2023 at 02:05 PM

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

Suggested Answer: B

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
39 comments · newest first
LU
Luis 11 months ago
Certificate authentication? I don't see how that fits in here.
WI
William 11 months ago
100% agree, Azure AD is the way to go for security!
KI
Kimberlie 12 months ago
Wait, can you really use service principal for MFA? Sounds off.
FR
Frederica 12 months ago
I think SQL authentication is still used by some, but not for MFA.
AL
Alpha 1 year ago
Definitely Azure AD authentication for MFA!
BR
Brittni 1 year ago
Certificate authentication seems like it could work, but I don't recall it being the best option for enforcing MFA in Azure SQL.
MA
Maryln 1 year ago
I feel like SQL authentication is too basic for this requirement; it definitely doesn't have MFA capabilities.
PA
Paris 1 year ago
I remember practicing a similar question, and I think service principal authentication doesn't support MFA, so it can't be the answer.
CO
Cornell 1 year ago
I think Azure AD authentication is the way to go for MFA, but I'm not entirely sure if it supports all scenarios.
TI
Timothy 1 year ago
Service principal authentication? I'm not sure how that would work for user-level MFA. I'm leaning towards Azure AD as the best fit for this scenario.
NA
Nakisha 1 year ago
Hmm, I'm not sure about this one. I know Azure AD can do MFA, but I'm not certain if that's the only option. I'll need to think this through carefully.
TA
Tamar 1 year ago
This one seems straightforward - Azure AD authentication is the way to go for multi-factor authentication with an Azure SQL database.
CA
Candida 1 year ago
Okay, the key here is ensuring MFA, so I'm thinking Azure AD authentication is the right choice. It integrates with Azure's identity management and provides that extra security layer.
AV
Avery 1 year ago
This looks like a question on network service lifecycle management. I'll need to think through the different components involved in that process to determine the correct answer.
KR
Krystal 1 year ago
This seems straightforward to me. The only mass model that is not saved externally is the In-place mass model, so I'm confident that option B is the correct answer.
EU
Eugene 1 year ago
This seems like a lot of steps, but the instructions look clear. I'll take it one step at a time and make sure I don't skip anything important.
RE
Reena 1 year ago
If I choose SQL authentication, can I use 'password123' as my password? It's a classic, you know.
RU
Ruth 1 year ago
Hmm, service principal authentication? That sounds a bit too complex for a simple database connection. I'd rather just use Azure AD and be done with it.
ST
Stephanie 1 year ago
↳ replying to Ruth
I always prefer using Azure AD authentication for my database connections.
BU
Bulah 1 year ago
↳ replying to Ruth
Service principal authentication can be a bit complicated for regular users.
MI
Mila 1 year ago
↳ replying to Ruth
Yeah, I think Azure AD authentication is the way to go for most users.
ON
Onita 1 year ago
↳ replying to Ruth
I agree, Azure AD authentication is much simpler and more secure.
DA
Dana 1 year ago
Haha, certificate authentication? What is this, the 90s? I'll stick with Azure AD, thanks. It's the modern and secure option.
GE
Gearldine 1 year ago
I'm not sure if Azure AD is the right choice here. Shouldn't we be using SQL authentication instead? It's more traditional and might be better for this particular database.
ED
Edna 1 year ago
↳ replying to Gearldine
C) SQL authentication
KR
Kristel 1 year ago
↳ replying to Gearldine
B) Azure Active Directory (Azure AD) authentication
TR
Tracey 1 year ago
↳ replying to Gearldine
A) service principal authentication
XU
Xuan 2 years ago
Azure AD authentication is definitely the way to go. It's secure, easy to set up, and works seamlessly with Azure services.
FR
Francoise 1 year ago
↳ replying to Xuan
Azure AD authentication is definitely the way to go. It's secure, easy to set up, and works seamlessly with Azure services.
EM
Emmett 1 year ago
↳ replying to Xuan
D) certificate authentication
KR
Krystina 1 year ago
↳ replying to Xuan
C) SQL authentication
NA
Nada 1 year ago
↳ replying to Xuan
B) Azure Active Directory (Azure AD) authentication
CA
Carmen 1 year ago
↳ replying to Xuan
A) service principal authentication
BE
Beata 2 years ago
I'm not sure, but I think SQL authentication could also work for MFA.
BR
Brock 2 years ago
I agree with Tammara, Azure AD authentication provides a secure way to implement MFA.
TA
Tammara 2 years ago
I think we should use Azure Active Directory (Azure AD) authentication for MFA.
TH
Thaddeus 2 years ago
I'm not sure, but I think SQL authentication could also work for MFA.
NO
Nohemi 2 years ago
I agree with Ramonita, Azure AD authentication provides a secure way for users to connect.
RA
Ramonita 2 years ago
I think we should use Azure Active Directory (Azure AD) authentication for MFA.
0/2000 characters

Save Cancel