DP-300 Exam Question 66

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 67

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have an Azure Data Lake Storage account that contains a staging zone.
    You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
    Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse.
    Does this meet the goal?
  • DP-300 Exam Question 68

    You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
    You need to limit the number of IOPs that App2 queries generate on SQL1.
    Which two actions should you perform on SQL1? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • DP-300 Exam Question 69

    You have SQL Server on an Azure virtual machine.
    You need to add a 4-TB volume that meets the following requirements:
    Maximizes IOPs
    Uses premium solid state drives (SSDs)
    What should you do?