Q: 17
HOTSPOT You have an Azure subscription. You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure. You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs. The solution must minimize administrative effort. Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 
Your Answer
Discussion
You'd have to choose SQL Virtual Machines for both MSX and TSX here. MSX/TSX jobs rely on full SQL Server Agent, which isn't supported on Managed Instance or Azure SQL. Easy to miss if you assume PaaS is always better.
SQL Virtual Machines for both MSX and TSX. Only way to get multi-server job support here, I think.
Option D. Failover groups is the way here, not geo-replication. Geo-replication needs app config changes, which is a trap.
A is wrong, it should be Azure SQL failover groups. Had something like this in a mock. Failover groups handle datacenter loss and keep the connection string the same, so apps don't need to change anything.
SQL Virtual Machines for both roles. That's my pick but open to being corrected if someone has seen MSX/TSX work with Managed Instance recently.
Be respectful. No spam.
