DP-300 Exam Question 6

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?
  • DP-300 Exam Question 7

    Based on the PaaS prototype, which Azure SQL Database compute tier should you use?
  • DP-300 Exam Question 8

    You create all of the tables and views for ResearchDB1.
    You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.
    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    DP-300 Exam Question 9

    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?
  • DP-300 Exam Question 10

    You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named Mil.
    You plan to perform an online migration of db1 to MM by using Azure Database Migration Service.
    You need to create the backups for the migration. The solution must minimize the number of backup files created.
    Which type of backups should you create, and how should you store the backups? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.