Exam DP-300 topic 6 question 23 discussion

Actual exam question from Microsoft's DP-300

Question #: 23
Topic #: 6

HOTSPOT -
You have an Azure subscription that contains the resources shown in the following table.

You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Create a replicate on the same logical server.
A High Availability (HA) replica uses the same page servers as the primary replica.
A named replica, just like an HA replica, uses the same page servers as the primary replica.
Box 2: Add an ApplicationIntent entry to the connection string.
Connecting to an HA replica.
In Hyperscale databases, the ApplicationIntent argument in the connection string used by the client dictates whether the connection is routed to the read-write primary replica or to a read-only HA replica. If ApplicationIntent is set to ReadOnly and the database doesn't have a secondary replica, connection will be routed to the primary replica and will default to the ReadWrite behavior.
Example:
-- Connection string with application intent
Server=tcp:<myserver>.database.windows.net;Database=<mydatabase>;ApplicationIntent=ReadOnly;User
ID=<myLogin>;Password=<myPassword>;Trusted_Connection=False; Encrypt=True;
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql&tabs=tsql https://sqlserverguides.com/read-only-replica-azure-sql/

by FrancesLee at Aug. 4, 2022, 3:45 a.m.

Comments

Submit Cancel

lukelin08

Highly Voted 2 years, 7 months ago

It is correct, but geo-replication is also a valid option for creating a readable secondary according to the article https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql&tabs=tsql https://sqlserverguides.com/read-only-replica-azure-sql/

upvoted 6 times

...

bingomutant

Most Recent 6 months, 4 weeks ago

Create a replica on the same logical server: This is correct because the Hyperscale service tier allows the creation of read-only replicas on the same logical server without needing geo-replication or an auto-failover group.

upvoted 1 times

...

testdumps2017

1 year, 8 months ago

https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql&tabs=tsql#high-availability-replica - answer is correct. Replica with ApplicationIntent

upvoted 2 times

...

HSQL

2 years, 2 months ago

The answer is not correct. We can't create a replica on the same logical server. We need to create or use a different logical server and create a geo-replica (Data management > Replica)

upvoted 2 times

U_C

2 years, 1 month ago

For Hypescale Service Tier, you can create High Availability replica. High Availability replica A High Availability (HA) replica uses the same page servers as the primary replica, so no data copy is required to add an HA replica. HA replicas are mainly used to increase database availability; they act as hot standbys for failover purposes. https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql&tabs=tsql#high-availability-replica

upvoted 6 times

...

FrancesLee

2 years, 9 months ago

Is it correct?