Exam AZ-900 topic 1 question 154 discussion

A https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability

my answer is 'B' Azure SQL Datawarehouse is a cloud data warehouse for the enterprise. It's characterized by high resiliency through automatic scaling.

Answer: A. No change is needed Azure SQL Data Warehouse does indeed provide built-in high availability as one of its key benefits. This feature ensures the platform remains operational and resilient against failures, which aligns with the underlined statement. If you'd like to explore more about Azure SQL Data Warehouse or its other features like scaling, data compression, or versioning, let me know!

Azure SQL Data Warehouse (now known as Azure Synapse Analytics) provides built-in high availability as a key benefit. It ensures reliability by replicating data and using redundancy to prevent downtime or data loss in the event of failures. The other options: B. Automatic scaling: While scaling capabilities are available, they are not the same as high availability. C. Data compression: This is another feature but unrelated to high availability. D. Versioning: This is not a key feature of Azure SQL Data Warehouse.Azure SQL Data Warehouse (now known as Azure Synapse Analytics) provides built-in high availability as a key benefit. It ensures reliability by replicating data and using redundancy to prevent downtime or data loss in the event of failures. The other options: B. Automatic scaling: While scaling capabilities are available, they are not the same as high availability. C. Data compression: This is another feature but unrelated to high availability. D. Versioning: This is not a key feature of Azure SQL Data Warehouse.

From chatgpt, High availability is a key benefit of Azure SQL Data Warehouse (now part of Azure Synapse Analytics under the dedicated SQL pool). Here’s how high availability is built into the platform:

The correct answer is A. High availability is indeed built into the Azure SQL Data Warehouse platform, ensuring that your data is always accessible and resilient to failures.

arghh another one of these questions for which we will never know the true answer between A or B.

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale

I believe distinctive feature is automatic scaling.. HA of 99.9 is offered, however not a distinctive feature.

A https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability

I think the answer is No. This is because logically before going into the more expensive solution among the available two solutions (Availability zones and regions) one should first check the first logical solution. First, you check if you have availability zones in your region and you go for that solution because we are concerned about the single datacenter protection level. If you do not have availability zones in your region, you can opt for deploying into another region. But this choice cannot be picked up first, without checking alternatives. That is how I see it, otherwise, they would not have mentioned "single datacenter in the question text.

For everyone's sake, "high availability" are the underlined words.

"Redundant regional servers for high availability"

"platform" is the key, all the solutions are not platforms, except ASQL WH

i see no line!!!

High availability requires an SLA of > 99.9%, SLA for AZ Synaptics is 99,9% so B. automatic scaling

SQL Data Warehouse is Azure Synapse Analytics now