ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 1 question 45 discussion

Actual exam question from Microsoft's DP-300
Question #: 45
Topic #: 1
[All DP-300 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer:
by U_C at April 4, 2023, 1:33 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SOLUTION_ZICO
Highly Voted 1 year, 6 months ago
Most, but not all, SQL Server Agent features are currently supported on Azure SQL Managed Instance. The Multi Server Administration feature is not supported on Azure SQL Managed Instance.
upvoted 6 times
voodoo_sh
7 months, 1 week ago
MSX: SQL virtual machines TSX: SQL virtual machines
upvoted 5 times
...
...
igorclapa
Highly Voted 1 year, 8 months ago
Most, but not all, SQL Server Agent features are currently supported on Azure SQL Managed Instance. The Multi Server Administration feature is not supported on Azure SQL Managed Instance. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16
upvoted 6 times
...
Christian_garcia_martin
Most Recent 1 month, 1 week ago
Virtual machines for both
upvoted 2 times
...
SumitraBr
5 months, 4 weeks ago
MSX: Use SQL Server on Azure Virtual Machines. TSX: Use SQL Server on Azure Virtual Machines. MSX/TSX jobs are only available on SQL Server installations with SQL Server Agent, which is a feature of SQL Server running on Windows or Azure Virtual Machines. PaaS solutions like Azure SQL Database and Azure SQL Managed Instance do not support MSX/TSX functionality because they do not expose SQL Server Agent in the same way.
upvoted 2 times
...
Davidjsanchez
8 months, 2 weeks ago
Important Most, but not all, SQL Server Agent features are currently supported on Azure SQL Managed Instance. The Multi Server Administration feature is not supported on Azure SQL Managed Instance.
upvoted 2 times
chefdba
7 months, 3 weeks ago
what is the correct answer?
upvoted 1 times
...
...
bingomutant
9 months, 3 weeks ago
SQL Virtual Machines for both.do not natively support MSX/TSX jobs (master/target job server configurations). The MSX/TSX job feature is primarily supported by SQL Server running on virtual machines (SQL on Azure VMs)
upvoted 1 times
...
dorwai
10 months, 3 weeks ago
Virtual Machines is my answer as according to https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16 the Multiserver Envirnment is not supported on SQL Managed Instances
upvoted 3 times
...
04db10c
1 year, 3 months ago
Answer : MSX : Virtual Machines and TSX : SQL Managed Intanecs
upvoted 3 times
04db10c
1 year, 1 month ago
Seems like answer is correct based on the ChatGPT ChatGPT To ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs while minimizing administrative effort, you should select the following SQL deployment options: Master Server (MSX): Azure SQL Managed Instance Target Server (TSX): Azure SQL Managed Instance Explanation: Azure SQL Managed Instance provides a fully managed SQL Server instance in the cloud, offering compatibility with on-premises SQL Server features, including multiserver administration and support for master/target (MSX/TSX) jobs. By selecting Azure SQL Managed Instance as both the master server (MSX) and the target server (TSX), you ensure that the migrated environment can be managed using multiserver administration and supports MSX/TSX jobs while minimizing administrative effort. Therefore, the correct options are: Master Server (MSX): Azure SQL Managed Instance Target Server (TSX): Azure SQL Managed Instance
upvoted 1 times
learnazureportal
6 months, 3 weeks ago
MSX (Master Server): SQL Virtual Machines SQL Virtual Machines offer full control and compatibility for managing multiserver jobs via MSX/TSX. TSX (Target Server): SQL Virtual Machines Only SQL Virtual Machines can function as a target for multiserver jobs in Azure.
upvoted 2 times
...
...
...
[Removed]
1 year, 8 months ago
For the scenario you've described where you need multiserver administration with master/target (MSX/TS) jobs in Azure and want to minimize administrative effort, the deployment options would be: MSX (Master Server): SQL Managed Instances TSX (Target Server): SQL Managed Instances Azure SQL Managed Instances provide a version of SQL Server that supports SQL Agent and multiserver management, which is necessary for setting up and managing MSX/TS jobs. This would allow you to migrate your on-premises SQL Server instances to Azure with full support for SQL Server Agent jobs, minimizing the changes and administrative effort required in transitioning to the cloud. Azure SQL Database does not support SQL Server Agent, which is required for MSX/TS jobs. SQL Virtual Machines could also support this, but it would not minimize administrative effort as much as managed instances since it would be like managing another on-premises server.
upvoted 2 times
04db10c
1 year, 3 months ago
SQL managed Instances : The Multi Server Administration feature for master/target (MSX/TSX) jobs aren't supported. So TSX is possible on Managed Instances for MSX : we need Virtual Server machines to manage MSX/TSX
upvoted 4 times
...
...
bsk1983
1 year, 10 months ago
On Azure SQL Managed Instance, The Multi Server Administration feature for master/target (MSX/TSX) jobs are not supported. as per info from below Microsoft URL. SO, I think answer is Azure Virtual machines for MSX and TSX setup. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16 https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
upvoted 5 times
...
bsk1983
1 year, 10 months ago
On Azure SQL Managed Instance, The Multi Server Administration feature for master/target (MSX/TSX) jobs are not supported. as per info from below Microsoft URL. SO, I think answer is Azure Virtual machines for MSX https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16 https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
upvoted 4 times
...
vjeruvwioorimyjrmt
1 year, 11 months ago
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql#sql-server-agent The Multi Server Administration feature for master/target (MSX/TSX) jobs are not supported. SQLVM only in both cases :(
upvoted 4 times
...
victorlie
2 years ago
Multiserver administration only applies to Managed Instance and SQL Server. Check this: https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16
upvoted 1 times
Avacato
1 year, 11 months ago
But what I see is "The Multi Server Administration feature is not supported on Azure SQL Managed Instance."
upvoted 8 times
...
...
U_C
2 years, 3 months ago
The Master Server (MSX) and Target Server (TSX) are SQL Server concepts used for managing multiple servers at once. The Master Server (MSX) is the central server that manages one or more Target Servers (TSX). By using MSX, you can manage multiple SQL Server instances as if they were a single entity. MSX simplifies the administration tasks of managing multiple servers by allowing you to execute tasks on multiple servers at once, such as backing up databases or running queries. The Target Server (TSX) is a SQL Server instance that is managed by the Master Server (MSX). TSX instances can be located on the same physical server as the MSX instance or on a different server. MSX/TSX can also be used for managing SQL Server Agent jobs, where you can define jobs at the master server and then distribute them to the target servers. This feature helps in centrally managing and scheduling SQL Server Agent jobs across multiple servers.
upvoted 4 times
...
U_C
2 years, 3 months ago
The answer is correct.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel