DP-300 Exam Question 11

You have an Azure SQL database named DB1.
You need to display the estimated execution plan of a query by using the query editor in the Azure portal.
What should you do first?
  • DP-300 Exam Question 12

    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 13

    You have an Azure subscription that contains the resources shown in the following table.

    You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.
    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 14

    You plan to move two 100-GB databases to Azure.
    You need to dynamically scale resources consumption based on workloads. The solution must minimize
    downtime during scaling operations.
    What should you use?
  • DP-300 Exam Question 15

    You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD) user named user1.
    You need to test impersonation of user1 in db1 by running a SELECT statement and returning to the original execution context.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.