Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 11 discussion

Actual exam question from Microsoft's DP-300

Question #: 11
Topic #: 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 General Purpose service tier and failover groups.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by MediMedi at Oct. 28, 2020, 1:18 a.m.

Comments

Submit Cancel

themickou

Highly Voted 2 years, 10 months ago

https://docs.microsoft.com/en-us/learn/modules/azure-sql-high-availability/7-higher-availablity-options you cannot have multiples replicas with auto failover and we need 2 here so NO

upvoted 11 times

jerkyflexoff

2 years ago

I agree with this answer, but the question is crappy. They don't suggest if still available is read only or read/write. To me available is, business as usual R/W a fail over would trigger read only availability.

upvoted 1 times

...

U_C

2 years, 8 months ago

With auto-failover groups or geo-replication, you can use the replicas as read-only endpoint. Note that with General Purpose you only get one replica per failover group or geo-replica. With business critical, since there's also an AG involved, you can use the geo-replica's primary as well as the read only secondary, both as read only endpoints. Answer is No.

upvoted 1 times

U_C

2 years, 8 months ago

I am wrong. Answer is Yes. https://channel9.msdn.com/Series/Azure-SQL-for-Beginners/Geo-replication-and-Auto-failover-Groups-in-Azure-SQL-51-of-61

upvoted 1 times

...

ChengKuo

Highly Voted 2 years, 11 months ago

Answer is correct; though In the Premium and Business Critical service tiers, applications could have "read-only replicas" at no extra cost, but "read-only replicas " is disabled at cannot be enabled in Basic, Standard, or General Purpose service tiers ; https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

upvoted 7 times

...

voodoo_sh

Most Recent 3 months, 2 weeks ago

Selected Answer: A

I think the answer is Yes. Failover groups provide two readable copies of the database - one is primary, second is secondary. p.s. Ofc question is open to interpretation - what they mean under two readable copies - is it 1 primary and two replicas of it, or it can be 2 servers (primary and secondary), both of which can be read from. Crappy question, bad work by whoever make it.

upvoted 1 times

...

voodoo_sh

4 months, 4 weeks ago

Selected Answer: B

If by "data center" they mean just one zone in a region, not a whole region, then answer is No. Failover Groups replicate data to another region, and if primary region has an outage, database will not failover automatically 1 hour minimum. So database will be unavailable for some time. And requirements say Sales must remain available.

upvoted 1 times

...

Motanel

8 months, 1 week ago

Selected Answer: B

B is correct

upvoted 1 times

...

reachmymind

1 year, 9 months ago

Selected Answer: B

NO as Fail-over Group provides only Primary & Secondary (only 1 read replica) https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db?tabs=azure-powershell

upvoted 2 times

...

pm4certs

2 years, 8 months ago

Given answer is correct...though failover groups gives you secondary read copy of the data but in case of outage, your database won't be available as failover groups have a grace period of one hour so during that one hour, it might be down

upvoted 1 times

U_C

2 years, 4 months ago

Because there are RW/RO listeners in failover group, the secondary replic is always available.

upvoted 1 times

...

vicky007_87

2 years, 10 months ago

Answer: Yes Reason: Auto-Failover group if created for a General Purpose service tier will create a replica in another region which will provide protection against datacenter disaster and Auto-failover group also supports read-scale so we get two read replica (primary replica which is read/write and Auto-failover replica in another region which is read-only replica).

upvoted 4 times

...

ondemand

2 years, 11 months ago

I think the answer should be No. cause general purpose doesn't support HA with zone redundant. but we need to Ensure that Sales remains available if a datacenter fails. ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-general-purpose-business-critical

upvoted 1 times

...

MediMedi

3 years, 1 month ago

Not clear if failover group would satisfy: at least two readable copies of Sales.

upvoted 1 times

adalfege

3 years, 1 month ago

Failover group wont. "Auto-failover groups support replication of all databases in the group to only one secondary server or instance in a different region." https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell

upvoted 2 times

BobbyTables

2 years, 11 months ago

Right, but the secondary is readable. So, the primary plus secondary would be two readable copies /during normal operations./

upvoted 3 times

ChengKuo

2 years, 11 months ago

It will depends on what is the "normal operations" referring to; in case it includes the applications, the read replica is not supported ; but yes from Server instance perspective, with auto failover groups on there the secondary server db should be readable says from SSMS, it's hard to decide yes or not for this question

upvoted 2 times

ChengKuo

2 years, 11 months ago

Did further search, general purpose tier can have 0 - 4 Read-only replicas using geo-replication which is auto configured by failover group, so the answer should be "YES"

upvoted 3 times

...