DP-300 Exam Question 66

You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1.
You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux.
You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 67

You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.
Which resource provider should you enable?
  • DP-300 Exam Question 68

    You are developing an application that uses Azure Data Lake Storage Gen 2.
    You need to recommend a solution to grant permissions to a specific application for a limited time period.
    What should you include in the recommendation?
  • DP-300 Exam Question 69

    You have an Azure SQL database named db1 on a server named server1.
    You need to modify the MAXDOP settings for db1.
    What should you do?
  • DP-300 Exam Question 70

    You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
    You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
    You need to recommend a database service for the deployment. The solution must minimize administrative effort.
    What should you include in the recommendation?