Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 9 Question 89 Discussion

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.
D) On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1. and E) On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.
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.

Microsoft DP-300 Exam - Topic 9 Question 89 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 89
Topic #: 9
[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

by Laticia at Apr 27, 2024, 01:37 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Tomas
8 months ago
I’m not sure about the proxy account on Server2, though.
upvoted 0 times
...
Patti
8 months ago
Wait, are we really using registry entries for this? Sounds risky!
upvoted 0 times
...
Markus
8 months ago
I think you also need to grant user rights on Server2.
upvoted 0 times
...
Gail
9 months ago
Definitely agree with that!
upvoted 0 times
...
Lindsey
9 months ago
You need to set the registry entry on Server1.
upvoted 0 times
...
Marguerita
9 months ago
I vaguely recall that allowing downloaded jobs to run requires specific settings, so I think option D is definitely one of the answers we need.
upvoted 0 times
...
Asha
9 months ago
I’m a bit confused about whether we need to create a proxy account on Server2 or if we can just use the one from Server1. I need to double-check that.
upvoted 0 times
...
Fausto
9 months ago
I think we practiced a similar question where we had to set registry entries for proxy accounts. I feel like option D might be the right choice for Server1.
upvoted 0 times
...
Chandra
10 months ago
I remember something about granting user rights, but I'm not sure if it's the "Impersonate a client" or the "Access this computer from the network" one.
upvoted 0 times
...
Chantell
10 months ago
This seems like a pretty straightforward question, but I want to make sure I fully understand the requirements before selecting my answers. I'll need to carefully read through the details and think through the implications of each action to ensure I choose the right combination.
upvoted 0 times
...
Anisha
10 months ago
Okay, let me break this down step-by-step. First, I need to grant the contoso\sqlproxy account the appropriate user rights on Server2. Then I'll need to configure something on Server1 to allow the downloaded jobs to use that proxy account. I think I've got a good strategy here, but I'll want to carefully review the options to make sure I select the right actions.
upvoted 0 times
...
Rene
10 months ago
Hmm, I'm a bit confused about the difference between the "Impersonate a client after authentication" and "Access this computer from the network" user rights. I'll need to double-check the details on those to make sure I understand which one is the right choice.
upvoted 0 times
...
Leota
10 months ago
This looks like a pretty straightforward question about configuring proxy accounts and permissions for SQL Server Agent jobs. I think I've got a good handle on the key steps here.
upvoted 0 times
...
Isadora
10 months ago
I'm a bit confused by the options. Can DirBuster or w3af also be used for this purpose, or is CeWL the clear winner?
upvoted 0 times
...
Georgeanna
10 months ago
This is a tricky one. I'm not certain, but I feel like The Canon of Medicine is an older work, so Flemming couldn't have discovered it. I'll go with B to be safe.
upvoted 0 times
...
Maryanne
10 months ago
Hmm, I'm a bit unsure on this one. I know partitioning has to do with how the data is structured, but I'm not totally clear on the different options here.
upvoted 0 times
...
Tegan
2 years ago
E sounds more accurate for the registry part. 'AllowDownloadedJobsToNatchProxyName' on Server2 makes sense.
upvoted 0 times
...
Markus
2 years ago
Could be B, but maybe we also need to change the registry entry on Server1. So maybe D too?
upvoted 0 times
...
Maryanne
2 years ago
I agree. What about option B? 'Access this computer from the network' user right?
upvoted 0 times
...
Barrett
2 years ago
Same here. I think option A is necessary. Granting 'Impersonate a client after authentication' seems crucial for the proxy account.
upvoted 0 times
...
Tegan
2 years ago
Absolutely! The bit about SQL Server Agent job steps got me.
upvoted 0 times
...
Juliann
2 years ago
Anyone else find the latest Azure virtual machines question tough?
upvoted 0 times
...

Save Cancel