Microsoft
DP-300 · Question #416
Drag and Drop Question You have an Azure subscription that contains a SQL Server on Azure virtual Machines instance named SQLVM1. You need to ensure that SQL Server Agent jobs on SQLVM1 can run operat
Sign in or unlock DP-300 to reveal the answer and full explanation for question #416. The question stem and answer options stay visible for context.
Submitted by ricky.ec· Mar 6, 2026Implement a secure environment for database solutions - specifically configuring SQL Server Agent proxies and credentials to control job step execution security contexts on SQL Server running on Azure Virtual Machines.
Question
Drag and Drop Question You have an Azure subscription that contains a SQL Server on Azure virtual Machines instance named SQLVM1. You need to ensure that SQL Server Agent jobs on SQLVM1 can run operating system commands. Which four T-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order. Answer:
Exhibit
Answer Area
Drag items
USE masterCREATE CREDENTIALEXEC dbo.sp_grant_login_to_proxyEXEC dbo.sp_grant_proxy_to_subsystemUSE msdbEXEC dbo.sp_add_proxy
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#Proxy Accounts#T-SQL Administration#Azure SQL on VMs