DP-300 Exam Question 71

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 72

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.
What should you include in the recommendation?
  • DP-300 Exam Question 73

    You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1.
    The only user who was created is the server administrator.
    You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication.
    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 74

    You have 50 Azure SQL databases.
    You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.
    What should you do?
  • DP-300 Exam Question 75

    You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named Appl. Appl uses db1.
    You need to enable Resource Governor for a App1. The solution must meet the following requirements:
    App1 must be able to consume all available CPU resources.
    App1 must have at least half of the available CPU resources always available.
    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 NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.