exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 19 discussion

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

You have a new Azure subscription.
You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.
You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. From the properties of DB1, configure geo-replication.
  • B. From the properties of Server1, add a failover group.
  • C. Create a new Azure SQL Database server named Server2.
  • D. From the properties of Server1, configure retention for DB1.
  • E. Create a new Azure SQL Database instance named DB2.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️

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
Ajgb
3 weeks, 5 days ago
Selected Answer: AB
Configure rep then create fog
upvoted 1 times
...
2f5c7cd
6 months, 3 weeks ago
Selected Answer: BC
BC
upvoted 1 times
...
OBIJUAN88
2 years ago
Selected Answer: BC
Seems correct. You add Server1 to a failover group as primary server and have to create a secondary server in case of a failover occurs.
upvoted 4 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago