Exam DP-300 topic 6 question 9 discussion

Looks like the answer here should be YES. While the failover isn't automatic, geo-replication does meet the stated requirements: Up to four secondaries are supported in the same or different regions, and the secondaries can also be used for read-only access queries. Ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

Measure Up answer to this is NO.

Answer is Yes. Identical question is in Microsoft's Practice Exams and answer is Yes.

https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#locally-redundant-availability - the answer is NO

YES https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out The High Availability architecture of Basic, Standard, and General Purpose service tiers does not include any replicas. The read scale-out feature is not available in these service tiers. However, geo-replicas can provide similar functionality in these service tiers.

With geo replication you can accomplish the readable secondaries, and keep the db online in case of a disaster. "The High Availability architecture of Basic, Standard, and General Purpose service tiers does not include any replicas. The read scale-out feature is not available in these service tiers. However, geo-replicas can provide similar functionality in these service tiers." https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

I think the provided answer is correct. The key is "During normal operations, provide at least two readable copies of Sales". The geo-replication is for disaster recovery. It keeps the 2nd replica but this replica can not be accessed by the application in a transparent way during normal operations.

The question and the provided answer might be outdated so here is an updated one: A - Yes. General Purpose allows for Failover without manual intervention ... As we discussed in an earlier module in this learning path, all of Azure SQL is built on Azure Service Fabric, which serves as the Azure backbone. If Azure Service Fabric determines that a failover needs to occur, the failover will be similar to that of a failover cluster instance (FCI). The service fabric will look for a node with spare capacity and spin up a new SQL Server instance. The database files will then be attached, recovery will be run, and gateways will be updated to point applications to the new node. No virtual network or listener or updates are required. This capability is built in. https://docs.microsoft.com/en-us/learn/modules/azure-sql-high-availability/4-high-availability-architecture Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center (region). https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

As part of High Availability architecture, each single database, elastic pool database, and managed instance in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and several secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and will not affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost. Answer is B https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Answer is B. Only premium and business critical supports Zone redundancy.

I think the answer is yes. With geo-replication, manual failover is required, but the database would still be available. In normal operation, as we have geo-replication, there is primary and secondary. So two copies of data

Agreed. The question doesn't stipulate automatic failover. With geo-replication, manual failover is required, but the database would still be available.

there is no automatic failover with geo-replication so sales will not remains available, i think the answer is NO

Read-only replicas in General Purpose 0 built-in 0 - 4 using geo-replication