Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 14 discussion

Actual exam question from Microsoft's DP-200

Question #: 14
Topic #: 1

A company plans to use Azure SQL Database to support a mission-critical application.
The application must be highly available without performance degradation during maintenance windows.
You need to implement the solution.
Which three technologies should you implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Premium service tier
B. Virtual machine Scale Sets
C. Basic service tier
D. SQL Data Sync
E. Always On availability groups
F. Zone-redundant configuration

Show Suggested Answer

Suggested Answer: AEF 🗳️
A: Premium/business critical service tier model that is based on a cluster of database engine processes. This architectural model relies on a fact that there is always a quorum of available database engine nodes and has minimal performance impact on your workload even during maintenance activities.
E: In the premium model, Azure SQL database integrates compute and storage on the single node. High availability in this architectural model is achieved by replication of compute (SQL Server Database Engine process) and storage (locally attached SSD) deployed in 4-node cluster, using technology similar to SQL
Server Always On Availability Groups.

F: Zone redundant configuration -
By default, the quorum-set replicas for the local storage configurations are created in the same datacenter. With the introduction of Azure Availability Zones, you have the ability to place the different replicas in the quorum-sets 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).
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability

by Huepig at March 19, 2020, 1:10 p.m.

Comments

Submit Cancel

bansal_vikrant

Highly Voted 4 years, 11 months ago

Look at the Conclusion section in the below link. It clearly mentions Always on and thus the provided answer is correct [A,E,F] https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability

upvoted 19 times

induna

4 years, 11 months ago

I think it is confusing because the Premium tier says "similar to Always On" but I agree with the answer because you can apply Always On AGs to the VMs that host the SQL Servers

upvoted 4 times

...

hello_there_

3 years, 11 months ago

The question asks "how should YOU configure". The documentation states that "High availability is implemented using a technology similar to SQL Server Always On availability groups", but this is an implementation detail of the premium/business critical service tiers, not something you have to configure yourself. That said, the other answers make even less sense.

upvoted 1 times

...

sidharthamanu

Highly Voted 5 years ago

The given answer[A,E,F] is correct. Same can be understood from given link - https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability

upvoted 9 times

...

GeorgiP

Most Recent 4 years, 2 months ago

Correct answer is A & F; "Always On availability groups" are integral part of (already included in) Premium tier zone redundant availability: "High availability is implemented using a technology similar to SQL Server Always On availability groups." https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla For better understanding of the above once and for all, pls look at the illustrations too.

upvoted 2 times

...

syu31svc

4 years, 6 months ago

Between Premium and Basic, Premium would be the better choice Data Sync is definitely irrelevant for this question VM Scale Sets is also wrong for sure So answer is AEF

upvoted 4 times

...

Egocentric

4 years, 6 months ago

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability. here there describe it nicely. A<E<F is the answer

upvoted 1 times

...

hart232

4 years, 8 months ago

Re premium- High availability requirement - As an extra benefit, the premium availability model includes the ability to redirect read-only Azure SQL connections to one of the secondary replicas.

upvoted 1 times

...

LeandroAmore

4 years, 11 months ago

The correct answer is A and F, in here https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla microsoft says: The underlying database files (.mdf/.ldf) are placed on the attached SSD storage to provide very low latency IO to your workload. High availability is implemented using a technology similar to SQL Server Always On availability groups. but it says SIMILAR and you don't implement always on, Microsoft does it for you.

upvoted 3 times

zac874997967

4 years, 9 months ago

But the question asked for three technologies。。

upvoted 4 times

...

Huepig

5 years, 2 months ago

You can not implement Alway On Availability Group on Azure Database Premium or any SKU. https://docs.microsoft.com/en-au/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15

upvoted 8 times

zenomas

5 years, 2 months ago

Right, "Always On Available" only applicable to on-prem "SQL Server".

upvoted 1 times

abeworld

5 years, 1 month ago

Its on azure too : https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-overview answer is correct

upvoted 7 times

abeworld

5 years, 1 month ago

actually this is for Azure VM - so my answer is not correct.

upvoted 2 times

...

M0e

4 years, 8 months ago

For Azure SQL DB it is called "Failover groups" so the correct answer is: Premium service tier, Failover groups and Zone-redundant configuration.

upvoted 1 times

...

soak

5 years ago

This is true, always on availability groups is for on premise. Answer should be Premium service tier, SQL Data Sync and Zone-redundant configuration.

upvoted 1 times

...