ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 7 discussion

Actual exam question from Microsoft's DP-300
Question #: 7
Topic #: 6
[All DP-300 Questions]

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.
Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.
You set the Read/Write failover policy to Automatic.
What are two results of the configuration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. In the event of a datacenter or Azure regional outage, the databases will fail over automatically.
  • B. In the event of an outage, the databases in the primary instance will fail over immediately.
  • C. In the event of an outage, you can selectively fail over individual databases.
  • D. In the event of an outage, you can set a different grace period to fail over each database.
  • E. In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by MarutiN at Nov. 14, 2020, 12:13 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Jas_dandiwal
Highly Voted 4 years, 2 months ago
answer is right, there is grace period of an hour in geo redundancy
upvoted 9 times
Sr18
10 months, 1 week ago
A and E are correct. Minimum grace allowed is 1 HR
upvoted 1 times
...
ramelas
3 years, 5 months ago
your argument is not valid since geo-replication is not supported by Azure SQL Managed Instance but Auto Failover groups is supported
upvoted 1 times
...
...
JakubWBialystok
Highly Voted 4 years, 3 months ago
A and D.
upvoted 5 times
...
Chunchi
Most Recent 3 years, 3 months ago
Selected Answer: AE
Look correct
upvoted 3 times
...
themickou
4 years, 2 months ago
Because verification of the scale of the outage and how quickly it can be mitigated involves human actions by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases in the failover group regardless of their data synchronization state. https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell
upvoted 2 times
...
Dhiva_
4 years, 5 months ago
Given answer is correct
upvoted 3 times
...
MarutiN
4 years, 5 months ago
What about option B
upvoted 1 times
Luke97
4 years, 4 months ago
Not immediately. The failover would happen after "Grace Period" (min 60 mins).
upvoted 7 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago