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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 2 Question 122 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 122
Topic #: 2
[All DP-300 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Melda
4 days ago
I thought sp_eddremotelogin was for something else.
upvoted 0 times
...
Christa
22 days ago
Mixed mode? That's a must for SQL Server!
upvoted 0 times
...
Malcom
28 days ago
Wait, are you sure? I thought it was xp_grant_login.
upvoted 0 times
...
Yasuko
1 month ago
Totally agree, that's the right procedure!
upvoted 0 times
...
Casie
1 month 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
1 month ago
B) xp_grant_login? Nah, that's for granting logins, not configuring authentication modes.
upvoted 0 times
...
Rasheeda
2 months ago
A) sp_eddremotelogin? Really? That's like trying to put out a fire with gasoline.
upvoted 0 times
...
Detra
2 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
2 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
2 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
2 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
2 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
3 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
...
Verlene
3 months ago
C) sp_change_users_login is the way to go. Gotta love those stored procedures!
upvoted 0 times
...
Teresita
3 months ago
Ah, I remember learning about this in class. I believe the correct answer is D - xp_instance_regwrite.
upvoted 0 times
...
Alonso
3 months ago
You need to run sp_change_users_login for mixed mode.
upvoted 0 times
...
Kristofer
4 months ago
D) xp_instance_regwrite is the correct answer. This procedure allows you to configure SQL Server to use mixed mode authentication.
upvoted 0 times
...
Davida
4 months ago
I'm a bit confused on the difference between mixed mode and other authentication modes. I'll need to review that before deciding.
upvoted 0 times
...
Micheal
4 months ago
Hmm, this seems straightforward. I think I'll try option C - sp_change_users_login.
upvoted 0 times
Celestina
3 months ago
I agree, option C sounds right.
upvoted 0 times
...
...

Save Cancel