DP-300: Administering Microsoft Azure SQL Solutions Dumps
Free Microsoft DP-300 Exam Dumps
Here you can find all the free questions related with Microsoft Administering Microsoft Azure SQL Solutions (DP-300) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Microsoft Administering Microsoft Azure SQL Solutions Exam. These premium versions are provided as DP-300 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the Administering Microsoft Azure SQL Solutions Exam premium files for free, Good luck with your Microsoft Administering Microsoft Azure SQL Solutions Exam.
Question No: 21
MultipleChoice
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 General Purpose service tier and geo-replication.
Does this meet the goal?
Options
Answer BExplanation
Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster.
By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW).