nerdexam
MicrosoftMicrosoft

DP-300 · Question #322

DP-300 Question #322: Real Exam Question with Answer & Explanation

Sign in or unlock DP-300 to reveal the answer and full explanation for question #322. The question stem and answer options stay visible for context.

Submitted by yousef_jo· Mar 6, 2026Implement a secure environment for database services - specifically configuring SQL Server Agent job step security using credentials and proxies in an Azure IaaS SQL Server deployment.

Question

Drag and Drop Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server. SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain. Server1 hosts a file share named Share1. You need to ensure that a SOL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#SQL Server Agent#Proxies and Credentials#Azure SQL on VMs#Least Privilege Security
Full DP-300 PracticeBrowse All DP-300 Questions