Microsoft DP-900 Exam - Topic 3 Question 73 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 73
Topic #: 3

[All DP-900 Questions]

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?

Aservice principal authentication

BAzure Active Directory (Azure AD) authentication

CSQL authentication

Dcertificate authentication

Show Suggested Answer

Suggested Answer: B

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

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Luis

6 months ago

Certificate authentication? I don't see how that fits in here.

upvoted 0 times

...

William

6 months ago

100% agree, Azure AD is the way to go for security!

upvoted 0 times

...

Kimberlie

6 months ago

Wait, can you really use service principal for MFA? Sounds off.

upvoted 0 times

...

Frederica

7 months ago

I think SQL authentication is still used by some, but not for MFA.

upvoted 0 times

...

Alpha

7 months ago

Definitely Azure AD authentication for MFA!

upvoted 0 times

...

Brittni

7 months ago

Certificate authentication seems like it could work, but I don't recall it being the best option for enforcing MFA in Azure SQL.

upvoted 0 times

...

Maryln

7 months ago

I feel like SQL authentication is too basic for this requirement; it definitely doesn't have MFA capabilities.

upvoted 0 times

...

Paris

7 months ago

I remember practicing a similar question, and I think service principal authentication doesn't support MFA, so it can't be the answer.

upvoted 0 times

...

Cornell

8 months ago

I think Azure AD authentication is the way to go for MFA, but I'm not entirely sure if it supports all scenarios.

upvoted 0 times

...

Timothy

8 months 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.

upvoted 0 times

...

Nakisha

8 months 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.

upvoted 0 times

...

Tamar

8 months ago

This one seems straightforward - Azure AD authentication is the way to go for multi-factor authentication with an Azure SQL database.

upvoted 0 times

...

Candida

8 months 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.

upvoted 0 times

...

Avery

8 months 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.

upvoted 0 times

...

Krystal

8 months 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.

upvoted 0 times

...

Eugene

8 months 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.

upvoted 0 times

...

Reena

1 year ago

If I choose SQL authentication, can I use 'password123' as my password? It's a classic, you know.

upvoted 0 times

...

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.

upvoted 0 times

Stephanie

11 months ago

I always prefer using Azure AD authentication for my database connections.

upvoted 0 times

...

Bulah

12 months ago

Service principal authentication can be a bit complicated for regular users.

upvoted 0 times

...

Mila

12 months ago

Yeah, I think Azure AD authentication is the way to go for most users.

upvoted 0 times

...

Onita

12 months ago

I agree, Azure AD authentication is much simpler and more secure.

upvoted 0 times

...

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.

upvoted 0 times

...

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.

upvoted 0 times