Microsoft Exam DP-300 Topic 8 Question 100 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 100
Topic #: 8

You have two Azure virtual machines named Server 1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com.

Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server.

On Server1, you create a proxy account named contoso\sqlproxy.

You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

AOn Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.

BOn Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.

COn Server2. create a proxy account.

DOn Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1.

EOn Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.

Show Suggested Answer

Suggested Answer: D, E

by Stephane at Sep 13, 2024, 11:40 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Fletcher

2 months ago

I bet the person who wrote this question was just sitting there, cackling to themselves, thinking 'Let's see if they can figure out this little riddle!'

upvoted 0 times

...

Gearldine

2 months ago

Wait, we're dealing with SQL Server and Active Directory? This is like a nerdy version of 'The Odd Couple'!

upvoted 0 times

...

Melissa

2 months ago

Hold up, why do we need to create a proxy account on Server2? Isn't the whole point to use the one we already created on Server1? I think options B and D are the way to go here.

upvoted 0 times

Sarina

1 months ago

I agree. We should also consider option D, which involves setting the AllowDownloadedJobsToNatchProxyName registry entry on Server1 to enable the job steps to run on Server2.

upvoted 0 times

...

Tammy

1 months ago

Yes, you're right. Option C suggests creating a proxy account on Server2, which is necessary for the job steps to be executed on that server.

upvoted 0 times

...

Aleta

1 months ago

I think we need to create a proxy account on Server2 to allow the SQL Server Agent job steps to be downloaded and run on Server2.

upvoted 0 times

...

Nettie

2 months ago

I'm not sure about creating a proxy account on Server2. Maybe we should focus on setting the registry entry on Server1 instead.

upvoted 0 times

...

Leigha

2 months ago

I agree with Nicolette. Granting the necessary user rights on Server2 is crucial for the SQL Server Agent job steps to run smoothly.

upvoted 0 times

...

Laurel

2 months ago

I'm gonna go with option B and E. Gotta give that proxy account the right permissions on Server2 and tweak the registry on both servers. Easy peasy, let's move on to the next question!

upvoted 0 times

Devorah

1 months ago

Let's move on to the next question. Keep up the good work!

upvoted 0 times

...

Dorian

1 months ago

Great job! You've got the right actions to ensure the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.

upvoted 0 times

...

Jennie

2 months ago

Don't forget to also set the AllowDownloadedJobsToMatchProxyName registry entry to 1 on both Server1 and Server2.

upvoted 0 times

...

Elin

2 months ago

Option B and E are the correct choices. Make sure to grant the contoso\\sqlproxy account the right permissions on Server2.

upvoted 0 times

...

Nicolette

2 months ago

I think we should perform actions A and B.

upvoted 0 times

...

Hmm, the question says we need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2. I reckon we'll need to set the AllowDownloadedJobsToNatchProxyName registry entry on both Server1 and Server2.

upvoted 0 times

...

Goldie

3 months ago

I think we need to grant the proxy account the 'Access this computer from the network' user right on Server2, and also set the AllowDownloadedJobsToNatchProxyName registry entry to 1 on Server2. That should do the trick.

upvoted 0 times

Nidia

2 months ago

E) On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.

upvoted 0 times

...

Carlene

2 months ago

B) On Server2, grant the contoso\\sqlproxy account the Access this computer from the network user right.

upvoted 0 times

...

Haley

2 months ago

A) On Server2, grant the contoso\\sqlproxy account the Impersonate a client after authentication user right.

upvoted 0 times

...

Microsoft Exam DP-300 Topic 8 Question 100 Discussion

Contribute your Thoughts:

Fletcher

Gearldine

Melissa

Sarina

Tammy

Aleta

Nettie

Leigha

Laurel

Devorah

Dorian

Jennie

Elin

Nicolette

Nieves

Goldie

Nidia

Carlene

Haley