nerdexam
Microsoft

DP-300 · Question #184

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual…

The correct answer is A. Configure service endpoints. During virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned: Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on) Storage…

Submitted by salim_om· Mar 6, 2026Plan and implement data platform resources

Question

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection. You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service. You need to configure VNET1 to support the migration. What should you do?

Options

  • AConfigure service endpoints.
  • BConfigure virtual network peering.
  • CDeploy an Azure firewall.
  • DConfigure network security groups (NSGs).

How the community answered

(32 responses)
  • A
    72% (23)
  • B
    6% (2)
  • C
    3% (1)
  • D
    19% (6)

Explanation

During virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned: * Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on) * Storage endpoint * Service bus endpoint This configuration is necessary because Azure Database Migration Service lacks internet https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

Topics

#Azure Database Migration Service#SQL Managed Instance#service endpoints#ExpressRoute

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice