DP-300 Exam Question 6

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
During normal operations, provide at least two readable copies of Sales.
Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Does this meet the goal?
  • DP-300 Exam Question 7

    You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
    You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
    Which resource type should you use to create the alert?
  • DP-300 Exam Question 8

    You have an Azure subscription.
    You need to deploy an Azure SQL managed instance that meets the following requirements:
    * Optimize latency.
    * Maximize the memory-to-vCore ratio.
    Which service tier and hardware generation should you use? To answer, select the apocopate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 9

    You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.
    You need to recommend a deployment solution that meets the following requirements:
    * Provides a Service Level Agreement (SLA) of at least 99.95%
    * Replicates databases in the same group synchronously
    * Minimizes the latency of database writes
    What should you recommend?
  • DP-300 Exam Question 10

    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.