QuestionQ70

VerifiedImplement a secure environment

You deploy a SQL Server instance on an Azure Virtual Machine named VM1.

You need to create a SQL Server Agent job to rebuild indexes for the databases hosted on VM1. The solution must follow the principle of least privilege.

What should you create first?

Explanation

SQL Server Agent is a Windows service, and its job execution security is based on Windows accounts and SQL Server permissions. A dedicated local Windows account can be granted only the permissions required to perform the index rebuilds, avoiding an overly privileged service or administrator account. Managed identities and Elastic Job agents do not provide the local SQL Server Agent execution account for this workload.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!