Exam DP-300 topic 5 question 29 discussion

Actual exam question from Microsoft's DP-300

Question #: 29
Topic #: 5

You have two Azure virtual machines named Server1 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.

A. On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.
B. On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.
C. On Server2, create a proxy account.
D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.
E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.

Show Suggested Answer

Suggested Answer: CD 🗳️

by angelvenkovicch at April 27, 2024, 12:50 p.m.

Comments

Submit Cancel

jtrain

8 months, 3 weeks ago

Selected Answer: CD

The answer is C and D. https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-target-server?view=sql-server-ver16

upvoted 4 times

voodoo_sh

5 months, 1 week ago

correct, first thing is enable "AllowDownloadedJobsToMatchProxyName" on master (D), and then create a proxy account on target (C) So the answer is C,D If getting an error on downloading jobs, only then need to enable AllowDownloadedJobsToMatchProxyName on the target server (according to docs)

upvoted 1 times

...

st1a

8 months, 4 weeks ago

C,E Distributed jobs that have steps which are associated with a proxy run under the context of the proxy account on the target server. Make sure that the following conditions are met or job steps that are associated with a proxy will not be downloaded from the master server to the target: The master server registry subkey \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<*instance_name*>\SQL Server Agent\AllowDownloadedJobsToMatchProxyName (REG_DWORD) is set to 1 (true). By default, this subkey is set to 0 (false). A proxy account exists on the target server that has the same name as the master server proxy account under which the job step runs.

upvoted 3 times

...

04db10c

10 months, 1 week ago

Selected Answer: DE

D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. This registry entry allows SQL Server Agent jobs on Server1 to use the proxy account name (contoso\sqlproxy) when executing on Server2. This is essential for ensuring that the job steps are executed with the appropriate permissions on Server2. E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. Similarly, on Server2, setting this registry entry ensures that the downloaded job steps from Server1 can be executed using the proxy account (contoso\sqlproxy). This step ensures compatibility and security when job steps are executed on the target server (Server2). Therefore, the correct actions to perform are D and E: D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. These actions ensure that the SQL Server Agent jobs from Server1 can be downloaded and executed on Server2 using the specified proxy account, contoso\sqlproxy, while maintaining security and compatibility between the servers.

upvoted 2 times

...

pjfunner

11 months, 1 week ago

Selected Answer: CD

ChatGPT suggests C and D: Therefore, the correct answers are: C. On Server2, create a proxy account. D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 112. These actions will ensure successful execution of SQL Server Agent job steps between Server1 and Server2.

upvoted 3 times

...

angelvenkovicch

1 year ago

Selected Answer: AE

I think it's A,E