DP-300 Exam Question 86

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 87

    You have an Azure SQL database.
    You identify a long running query.
    You need to identify which operation in the query is causing the performance issue.
    What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
  • DP-300 Exam Question 88

    What should you use to migrate the PostgreSQL database?
  • DP-300 Exam Question 89

    You are creating a managed data warehouse solution on Microsoft Azure.
    You must use PolyBase to retrieve data from Azure Blob storage that resides in parquet format and load the data into a large table called FactSalesOrderDetails.
    You need to configure Azure Synapse Analytics to receive the data.
    Which four 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.