BenchMark Quizzes by MDFT Pro

Manage SQL Server Instances With A Single User Account

You work for MDFT Pro, a well-known training agency with an Azure subscription linked to an Azure Active Directory tenant. Mark, the SQL Server Infrastructure Manager, operates 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances for different training departments and course management systems. Currently, each SQL Server instance requires separate administrative credentials, making management complex and time-consuming. Mark wants to simplify administration by ensuring that all SQL Server instances can be managed using a single user account with consistent permissions across all instances. He has asked you to implement a solution that enables centralized authentication and account management for the SQL Server environment.

What should you do first?

Choose the correct answer from the options below.

Explanations for each answer:

Enable a user-assigned managed identity on each virtual machine is incorrect. User-assigned managed identities are used for Azure resource authentication, not for managing SQL Server instances with a single domain account.
Deploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain is correct. Deploying Azure AD DS and joining the VMs to the domain allows you to use a single domain user account to manage all SQL Server instances centrally.
Enable a system-assigned managed identity on each virtual machine is incorrect. System-assigned managed identities are used for Azure resource authentication, not for SQL Server instance management with a single account.
Join the virtual machines to the Azure AD tenant is incorrect. Azure AD join doesn't provide the domain services needed for traditional SQL Server authentication and central account management.

Learn more about Azure Active Directory Domain Services:

Azure AD Domain Services

Practice Exam

Manage SQL Server Instances With A Single User Account

Discuss this question on social media: