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 Exam DP-300 Topic 5 Question 108 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 108
Topic #: 5
[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 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
4 days 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
5 days 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
7 days 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
...
Altha
14 days ago
I'm not sure about that. Maybe we should double check the documentation before the exam.
upvoted 0 times
...
Zana
21 days ago
I agree with Kaitlyn. We need to use sp_change_users_login to configure SQL1 for mixed mode authentication.
upvoted 0 times
...
Kaitlyn
23 days ago
I think the answer is C) sp_change_users_login.
upvoted 0 times
...
Stevie
27 days 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
29 days 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
Shay
2 days ago
B) xp_grant_login - That's not the right procedure either.
upvoted 0 times
...
Eleni
10 days ago
B) xp_grant_login - That's not the correct procedure either.
upvoted 0 times
...
Rodrigo
10 days ago
A) sp_eddremotelogin - No, that's not the right procedure for configuring mixed mode authentication.
upvoted 0 times
...
Tegan
14 days ago
A) sp_eddremotelogin - No, that's not the correct procedure for configuring mixed mode authentication.
upvoted 0 times
...
...

Save Cancel