DP-300 Exam Question 81

You have an Azure subscription that contains an Azure SQL database named SQL1.
SQL1 is in an Azure region that does not support availability zones.
You need to ensure that you have a secondary replica of SQLI in the same region.
What should you use?
  • DP-300 Exam Question 82

    You have an instance of SQL Server on Azure Virtual Machines named SQL1.
    SQL1 contains an Extended Events session named session1 that captures Microsoft SQL Server events.
    You need to correlate the session events with events captured by Event Tracing for Windows (ETW).
    What should you do for session1?
  • DP-300 Exam Question 83

    Hotspot Question
    You have an Azure subscription.
    You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.
    How should you complete the ARM template? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 84

    Hotspot Question
    You have an Azure SQL database named DB1 that contains a table named Table1.
    You run a query to load data into Table1.
    The performance metrics of Table1 during the load operation are 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 85

    You have an Azure SQL database named DB1 in the General Purpose service tier.
    The performance metrics for DB1 are shown in the following exhibit.

    You need to reduce the Log IO percentage. The solution must minimize costs.
    What should you do?