Microsoft Exam DP-300 Topic 7 Question 91 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 91
Topic #: 7

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 Emilio at May 24, 2024, 03:38 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

7 months ago

Haha, good thing they're not asking us to create a proxy account on Server1, that would be too easy! B and D sound like the way to go.

upvoted 0 times

William

6 months ago

D) On Server1, set the AllowDownloadedDobsTonatehProxyName registry entry to 1.

upvoted 0 times

...

Na

6 months ago

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

upvoted 0 times

...

I think the correct answers are B and D. Granting the proxy account the 'Access this computer from the network' user right on Server2 and setting the registry entry on Server1 seem to be the key steps here.

upvoted 0 times

Carylon

6 months ago

Yes, setting the registry entry on Server1 is also necessary for the SQL Server Agent job steps to run on Server2.

upvoted 0 times

...

Florinda

6 months ago

I agree, granting the 'Access this computer from the network' user right on Server2 is important.

upvoted 0 times

...

Microsoft Exam DP-300 Topic 7 Question 91 Discussion

Contribute your Thoughts:

Marva

Serina

Ivan

Cecily

Sharee

Genevive

Una

Kiera

Luann

Beatriz

William

Na

Hortencia

Carylon

Florinda