Microsoft DP-300 Exam - Topic 2 Question 122 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 122
Topic #: 2

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 Joseph at Nov 22, 2025, 09:12 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tashia

3 months ago

I feel confident about C) too. It’s commonly used for this setup.

upvoted 0 times

...

Robt

3 months ago

C) is definitely the best option. It aligns with SQL Server's user management.

upvoted 0 times

...

Royce

4 months ago

A) sp_eddremotelogin? That’s for remote logins, not mixed mode.

upvoted 0 times

...

Ira

4 months ago

Not so sure about C). What about A)?

upvoted 0 times

...

Ahmed

4 months ago

I agree, C) is the right choice. Mixed mode needs user mapping.

upvoted 0 times

...

Valda

4 months ago

I think it's C) sp_change_users_login. It makes sense for user authentication.

upvoted 0 times

...

Melda

4 months ago

I thought sp_eddremotelogin was for something else.

upvoted 0 times

...

Christa

5 months ago

Mixed mode? That's a must for SQL Server!

upvoted 0 times

...

Malcom

5 months ago

Wait, are you sure? I thought it was xp_grant_login.

upvoted 0 times

...

Yasuko

5 months ago

Totally agree, that's the right procedure!

upvoted 0 times

...

Casie

5 months ago

D) xp_instance_regwrite is the way to go. It's like using a magic wand to make your SQL Server do your bidding.

upvoted 0 times

...

Dominga

6 months ago

B) xp_grant_login? Nah, that's for granting logins, not configuring authentication modes.

upvoted 0 times

...

Rasheeda

6 months ago

A) sp_eddremotelogin? Really? That's like trying to put out a fire with gasoline.

upvoted 0 times

...

Detra

6 months ago

I vaguely recall that xp_instance_regwrite might be related to configuration settings, but I can't remember if it applies here.

upvoted 0 times

...

Jospeh

6 months ago

I’m a bit confused; I thought sp_change_users_login was for fixing orphaned users, not for setting authentication modes.

upvoted 0 times

...

Robt

6 months ago

I remember practicing a question similar to this, and I feel like it had something to do with changing user logins. Could it be C?

upvoted 0 times

...

Joseph

6 months ago

I think mixed mode authentication is about allowing both SQL Server and Windows authentication, but I'm not sure which stored procedure to use.

upvoted 0 times

...

Glory

7 months ago

Okay, I've got a strategy - I'll eliminate the options that don't seem relevant, then choose between the remaining ones based on my understanding of mixed mode authentication.

upvoted 0 times

...

Golda

7 months ago

I'm not too familiar with SQL Server administration tasks like this. I'll need to carefully read through the question and options to figure out the best approach.

upvoted 0 times

...