Administering Relational Databases on Microsoft Azure — Question 29

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?

Answer options

• A. Increase scheduling priority
• B. Log on as a service
• C. Profile system performance
• D. Log on as a batch job

Correct answer: B

Explanation

The correct answer is B, as 'Log on as a service' allows the SQL Server Agent to run jobs without requiring extensive permissions, adhering to the principle of least privilege. The other options do not provide the necessary rights for the SQL Server Agent to function properly in this context.