← Back to exam page

DP-300 – Administering Relational Databases on Microsoft Azure (beta)

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (New Update)

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:

The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.

Administrative effort must be minimized.

What should you use to host the databases?

Select an option, then click Submit answer.

  • ○

    a single Azure SQL database

  • ○

    an Azure SQL Database elastic pool

  • ○

    SQL Server on Azure Virtual Machines

  • ○

    Azure SQL Managed Instance
Question 14 (Mixed Questions)

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?

Select an option, then click Submit answer.

  • ○

    Configure service endpoints.
  • ○

    Configure virtual network peering.
  • ○

    Deploy an Azure firewall.
  • ○

    Configure network security groups (NSGs).
Question 15 (New Update)

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:

The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.

Administrative effort must be minimized.

What should you use to host the databases?

Select an option, then click Submit answer.

  • ○

    a single Azure SQL database

  • ○

    an Azure SQL Database elastic pool

  • ○

    SQL Server on Azure Virtual Machines

  • ○

    Azure SQL Managed Instance