MENU
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?
Suggested Answer: D
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
TA
Tashia
6 months ago
I feel confident about C) too. It’s commonly used for this setup.
RO
Robt
6 months ago
C) is definitely the best option. It aligns with SQL Server's user management.
RO
Royce
7 months ago
A) sp_eddremotelogin? That’s for remote logins, not mixed mode.
IR
Ira
7 months ago
Not so sure about C). What about A)?
AH
Ahmed
7 months ago
I agree, C) is the right choice. Mixed mode needs user mapping.
VA
Valda
7 months ago
I think it's C) sp_change_users_login. It makes sense for user authentication.
ME
Melda
7 months ago
I thought sp_eddremotelogin was for something else.
CH
Christa
8 months ago
Mixed mode? That's a must for SQL Server!
MA
Malcom
8 months ago
Wait, are you sure? I thought it was xp_grant_login.
YA
Yasuko
8 months ago
Totally agree, that's the right procedure!
CA
Casie
8 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.
DO
Dominga
9 months ago
B) xp_grant_login? Nah, that's for granting logins, not configuring authentication modes.
RA
Rasheeda
9 months ago
A) sp_eddremotelogin? Really? That's like trying to put out a fire with gasoline.
DE
Detra
9 months ago
I vaguely recall that xp_instance_regwrite might be related to configuration settings, but I can't remember if it applies here.
JO
Jospeh
9 months ago
I’m a bit confused; I thought sp_change_users_login was for fixing orphaned users, not for setting authentication modes.
RO
Robt
9 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?
JO
Joseph
9 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.
GL
Glory
10 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.
GO
Golda
10 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.
VE
Verlene
10 months ago
C) sp_change_users_login is the way to go. Gotta love those stored procedures!
TE
Teresita
10 months ago
Ah, I remember learning about this in class. I believe the correct answer is D - xp_instance_regwrite.
AL
Alonso
11 months ago
You need to run sp_change_users_login for mixed mode.
KR
Kristofer
11 months ago
D) xp_instance_regwrite is the correct answer. This procedure allows you to configure SQL Server to use mixed mode authentication.
DA
Davida
11 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.
MI
Micheal
11 months ago
Hmm, this seems straightforward. I think I'll try option C - sp_change_users_login.
AM
Amie
6 months ago
I beliAmie it doesn't need a restart.
LU
Luis
6 months ago
Does anyone know if it requires a restart?
KE
Kenia
6 months ago
Mixed mode is essential for flexibility.
JO
Jose
6 months ago
I was thinking the same!
CE
Celestina
10 months ago
I agree, option C sounds right.