Exam AZ-900 All QuestionsBrowse all questions from this exam
Question 154

This question requires that you evaluate the underlined text to determine if it is correct.

One of the benefits of Azure SQL Data Warehouse is that high availability is built into the platform.

Instructions: Review the underlined text. If it makes the statement correct, select `No change is needed`. If the statement is incorrect, select the answer choice that makes the statement correct.

    Correct Answer: A

    One of the benefits of Azure SQL Data Warehouse is that high availability is built into the platform. Microsoft Azure SQL Data Warehouse, now part of Azure Synapse Analytics, offers a service-level agreement (SLA) of 99.9% for availability, which is a direct result of the high availability features implemented in the platform. Ensuring minimal downtime and maintaining data availability are essential features of cloud-based data warehouses and are critical for enterprises that rely on continuous data processing and analytics. Therefore, no change is needed.

Discussion
RSMCT2011Option: A

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

ultraOriginalVillain

Yes. This is the key: " The high availability solution is designed to ensure that committed data is never lost due to failures " The whole idea of 'high availability'

bantu_1

This is for database now warehouse

ssssss78

question is about sql data warehouse and not sql database

PleeOption: B

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

kilowd

Guarantee of 99.9% availability, as well as regulatory compliance built in, so you don’t need your DBAs to take care of any of this, it’s all taken care of for you. https://blog.pragmaticworks.com/azure-sql-data-warehouse-features-and-advantages

kilowd

Answer is A

ultraOriginalVillain

It's DataWAREHOUSE. It's a data dump!! what are you scaling? You want to make the massive sea of data highly available.

Massy

Yes, a datawarehouse for BIG DATA Analysis

Wafi79

i see no line!!!

Forkbeard

There is no line. The other question about underlined text also didn't have a line. It's an extra challenge :/

JC_de_SevillaOption: A

SQL Data Warehouse is Azure Synapse Analytics now

pheebsbabeOption: A

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

itiswhatitisOption: A

Aaaaaaaaaaaaaaaaaaa

N9Option: C

I think C should be answer

NoursBear

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

Kee93Option: 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

subhalaOption: B

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

KHALID_KORENAOption: A

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

SAFMOption: A

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.

SAFM

Sorry, comment is under the wrong question.

buiducvuOption: A

"Redundant regional servers for high availability"

EliasYahyaOption: A

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

sken999Option: B

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

pep138

disagree to this as while the SLA for Azure Synapse Analytics includes an uptime guarantee that is part of its high availability capabilities, it is not the only factor that contributes to high availability. My answer is A.

Pa1theAchieverOption: A

Option A

JKRowlingsOption: A

Answer is A. No change