DP-300 Exam Question 101

You have an Azure SQL database named that contains a table named Table1.
You run a query to bad data into Table1.
The performance Of Table1 during the load operation are shown in exhibit.

DP-300 Exam Question 102

You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • DP-300 Exam Question 103

    You have an Azure SQL database.
    You have a query and the associated execution plan as shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE:Each correct selection is worth one point.

    DP-300 Exam Question 104

    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 105

    You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1.
    You need to identify and repair any physical or logical corruption in DB1. The solution must meet the following requirements:
    * Minimize how long it takes to complete the procedure.
    * Minimize data loss.
    How should you complete the command? To answer, select the appropriate options in the answer area NOTE:
    Each correct selection is worth one point.