exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 30 discussion

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

You have an Azure subscription that contains an Azure SQL database named SQL1.

SQL1 is in an Azure region that does not support availability zones.

You need to ensure that you have a secondary replica of SQL1 in the same region.

What should you use?

  • A. log shipping
  • B. active geo-replication
  • C. Microsoft SQL Server failover clusters
  • D. auto-failover groups
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
OBIJUAN88
7 months, 2 weeks ago
Selected Answer: B
Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary database is also known as a geo-secondary or geo-replica. https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?source=recommendations&view=azuresql
upvoted 2 times
...
BrenFa101
9 months, 3 weeks ago
Answer is correct. You can create a new logical server in the same region and use geo-replication to add a replica to it. The 2 logical servers will exist in the same datacenter
upvoted 2 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 ...