Microsoft Exam DP-300 Topic 4 Question 96 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 96
Topic #: 4

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 Delmy at Jul 16, 2024, 01:00 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nan

4 months ago

Let's go with options A and B then, and skip option C.

upvoted 0 times

...

Melita

4 months ago

Hah, I bet the person who wrote this question was just bored and wanted to see how many options they could come up with. SQL Server, Active Directory, and virtual machines? Sounds like a party!

upvoted 0 times

Barrie

3 months ago

C) On Server2. create a proxy account.

upvoted 0 times

...

Kristeen

3 months ago

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

upvoted 0 times

...

Christoper

4 months ago

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

upvoted 0 times

...

Marguerita

4 months ago

Hold up, is this a trick question? I bet the real answer is to just use a magic wand and make the servers work together. Who needs user rights and registry settings when you've got wizard powers?

upvoted 0 times

Tess

3 months ago

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

upvoted 0 times

...

Marg

4 months ago

C) On Server2. create a proxy account.

upvoted 0 times

...

Benedict

4 months ago

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

upvoted 0 times

...

Lacey

4 months ago

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

upvoted 0 times

...

Otis

4 months ago

I think option C is not necessary since we already have the contoso\sqlproxy account on Server1.

upvoted 0 times

...

Joseph

5 months ago

I'm not sure about option C, do we really need to create a proxy account on Server2?

upvoted 0 times

...

Bernadine

5 months ago

I'm going with B and D. Gotta give that proxy account the necessary network access, and the registry setting on Server1 will make sure the jobs can actually use the proxy.

upvoted 0 times

...

Nan

5 months ago

I agree with Otis, those options seem to make sense.

upvoted 0 times

...

Nan

5 months ago

D and E sound like the right choices. We need to set the registry entries on both Server1 and Server2 to allow the downloaded jobs to run through the proxy account.

upvoted 0 times

Rodolfo

3 months ago

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

upvoted 0 times

...

Annabelle

4 months ago

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

upvoted 0 times

...

I think option B is the way to go. Granting the contoso\sqlproxy account the 'Access this computer from the network' user right on Server2 is crucial for the SQL Server Agent job steps to be downloaded and executed.

upvoted 0 times

Hobert

4 months ago

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

upvoted 0 times

...

Annelle

4 months ago

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

upvoted 0 times

...

Otis

5 months ago

I think we should choose option A and B.

upvoted 0 times

...

Microsoft Exam DP-300 Topic 4 Question 96 Discussion

Contribute your Thoughts:

Nan

Melita

Barrie

Kristeen

Christoper

Marguerita

Tess

Marg

Benedict

Lacey

Otis

Joseph

Bernadine

Nan

Nan

Rodolfo

Annabelle

Malinda

Hobert

Annelle

Otis