nerdexam
Microsoft

DP-300 · Question #271

You have an instance of SQL Server on Azure Virtual Machines named VM1. You plan to schedule a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. You need to configure the

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

Submitted by ngozi_ng· Mar 6, 2026Implement a secure environment

Question

You have an instance of SQL Server on Azure Virtual Machines named VM1. You plan to schedule a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. You need to configure the account that will be used by the agent. The solution must use the principle of least privilege. Which operating system user right should you assign to the account?

Options

  • AIncrease scheduling priority
  • BLog on as a service
  • CProfile system performance
  • DLog on as a batch job

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#Service Accounts#Least Privilege#OS User Rights
Full DP-300 Practice