BenchMark Quizzes by MDFT Pro

Select Deployment Options For MSX/TSX Multiserver Administration

You work for MDFT Pro, a well-known training agency planning to migrate 10 on-premises Microsoft SQL Server instances to Azure. Mark, the SQL Server Centralization Lead, manages SQL Server instances that support different regional training centers across the country. Each instance hosts databases for student records, course schedules, and trainer assignments specific to each region. Mark wants to implement multiserver administration using master/target (MSX/TSX) jobs to centrally manage scheduled maintenance tasks, backup operations, and data synchronization across all 10 instances. The solution must minimize administrative effort by allowing jobs to be defined once on the master server and automatically distributed to all target servers.

Which SQL deployment options should you select as the master server (MSX) and the target servers (TSX)?

Choose all correct answers from the options below.

Explanations for each answer:

Deploy MSX as SQL Database is incorrect. Azure SQL Database does not support SQL Server Agent or multiserver administration features required for MSX.
Deploy MSX as SQL Managed Instance is incorrect. While SQL Managed Instance supports SQL Server Agent, it does not support multiserver administration (MSX/TSX) features.
Deploy MSX as SQL Server on Azure Virtual Machines is correct. SQL Server on Azure Virtual Machines provides full support for multiserver administration and can serve as the master server (MSX).
Deploy TSX as SQL Database is incorrect. Azure SQL Database does not support SQL Server Agent or multiserver administration features required for TSX.
Deploy TSX as SQL Managed Instance is incorrect. While SQL Managed Instance supports SQL Server Agent, it does not support multiserver administration (MSX/TSX) features as target servers.
Deploy TSX as SQL Server on Azure Virtual Machines is correct. SQL Server on Azure Virtual Machines provides full support for multiserver administration and can serve as target servers (TSX).

Learn more about Multiserver Administration With SQL Server Agent:

SQL Server Multiserver Administration

Practice Exam

Select Deployment Options For MSX/TSX Multiserver Administration

Discuss this question on social media: