Microsoft Exam DP-300 Topic 5 Question 108 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 108
Topic #: 5

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.

You need to configure SQL1 to use mixed mode authentication.

Which procedure should you run?

Asp_eddremotelogin

Bxp_grant_login

Csp_change_users_login

Dxp_instance_regwrite

Show Suggested Answer

Suggested Answer: D

by Cathrine at Jan 09, 2025, 08:47 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Danica

2 months ago

A) sp_eddremotelogin - Wait, what? Is this a trick question or something? I've never even heard of that stored procedure!

upvoted 0 times

...

Desire

2 months ago

D) xp_instance_regwrite - Classic Microsoft, always making us dig into the registry. That's the only way to get this done, I bet.

upvoted 0 times

...

Jarvis

2 months ago

Hmm, I'm leaning towards B) xp_grant_login. Doesn't that deal with granting access to remote logins? Sounds like what we need for mixed mode authentication.

upvoted 0 times

Janine

2 months ago

Yes, xp_grant_login is the right choice for configuring SQL1 to use mixed mode authentication.

upvoted 0 times

...

Svetlana

2 months ago

I think you're right, xp_grant_login is the correct procedure for granting access to remote logins.

upvoted 0 times

...

Altha

3 months ago

I'm not sure about that. Maybe we should double check the documentation before the exam.

upvoted 0 times

...

Zana

3 months ago

I agree with Kaitlyn. We need to use sp_change_users_login to configure SQL1 for mixed mode authentication.

upvoted 0 times

...

Kaitlyn

3 months ago

I think the answer is C) sp_change_users_login.

upvoted 0 times

...

Stevie

3 months ago

C) sp_change_users_login - I'm pretty sure this is the way to go. Changing the login mode should be done through this stored procedure.

upvoted 0 times

...

Marya

3 months ago

D) xp_instance_regwrite - That's gotta be it! It's all about modifying the registry settings for the SQL Server instance, right?

upvoted 0 times

Lanie

2 months ago

D) xp_instance_regwrite - Incorrect, the correct procedure is C) sp_change_users_login.

upvoted 0 times

...

Micheline

2 months ago

C) sp_change_users_login - Yes, that's the correct procedure for configuring SQL1 to use mixed mode authentication.

upvoted 0 times

...

Minna

2 months ago

C) sp_change_users_login - Yes, that's the correct procedure for configuring SQL1 to use mixed mode authentication.

upvoted 0 times

...

Shay

2 months ago

B) xp_grant_login - That's not the right procedure either.

upvoted 0 times

...

Eleni

3 months ago

B) xp_grant_login - That's not the correct procedure either.

upvoted 0 times

...

Rodrigo

3 months ago

A) sp_eddremotelogin - No, that's not the right procedure for configuring mixed mode authentication.

upvoted 0 times

...

Tegan

3 months ago

A) sp_eddremotelogin - No, that's not the correct procedure for configuring mixed mode authentication.

upvoted 0 times

...