BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 8 Question 98 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 98
Topic #: 8
[All DP-300 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: D, E

Contribute your Thoughts:

Sanjuana
1 months ago
I think option C is not necessary. Let's stick with A and B for now.
upvoted 0 times
...
Belen
2 months ago
I'm not sure about option C. Do we really need to create a proxy account on Server2?
upvoted 0 times
...
Xenia
2 months ago
I agree with Sanjuana. Those options seem to be the right ones.
upvoted 0 times
...
Charlene
2 months ago
This is a good one. I reckon the solution is B and D. Simple and straightforward, just the way I like it.
upvoted 0 times
Catalina
12 days ago
Great, it's always nice when the solution is simple and straightforward like this.
upvoted 0 times
...
Casie
13 days ago
That makes sense. Those actions should ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.
upvoted 0 times
...
Carmen
14 days ago
I agree, granting the contoso\\sqlproxy account the Access this computer from the network user right on Server2 and setting the AllowDownloadedJobsToNatchProxyName registry entry to 1 on Server1 should do the trick.
upvoted 0 times
...
Annmarie
16 days ago
I think you're right. B and D seem to be the correct actions to perform.
upvoted 0 times
...
...
Brett
2 months ago
Haha, this question is a bit tricky, isn't it? I'd go with B, D, and E. Gotta love those registry settings!
upvoted 0 times
...
Pura
2 months ago
Hmm, I'm not sure about that. I think we also need to create the proxy account on the target server, so I'd say the answer is B, D, and C.
upvoted 0 times
Nettie
1 months ago
I agree, we also need to set the AllowDownloadedJobsToMatchProxyName registry entry to 1 on Server2.
upvoted 0 times
...
Jeannetta
1 months ago
I think we need to grant the contoso\\sqlproxy account the Access this computer from the network user right on Server2.
upvoted 0 times
...
Xochitl
1 months ago
We also need to set the AllowDownloadedJobsToMatchProxyName registry entry to 1 on Server2.
upvoted 0 times
...
Tanesha
2 months ago
I think we need to grant the contoso\\sqlproxy account the Access this computer from the network user right on Server2.
upvoted 0 times
...
...
Leatha
2 months ago
I think the correct answers are B and D. We need to grant the proxy account the necessary permissions on the target server and also set the registry entry on the master server.
upvoted 0 times
Hoa
1 months ago
Make sure to follow both steps to ensure the job steps can be downloaded and run successfully.
upvoted 0 times
...
Raina
1 months ago
Setting the AllowDownloadedJobsToNatchProxyName registry entry to 1 on Server1 is also necessary for the SQL Server Agent job steps to run on Server2.
upvoted 0 times
...
Cecilia
2 months ago
I agree, granting the proxy account the Access this computer from the network user right on Server2 is important.
upvoted 0 times
...
...
Sanjuana
2 months ago
I think we should choose option A and B.
upvoted 0 times
...

Save Cancel