Evaluate the underlined statement: "One of the benefits of Azure SQL Data Warehouse is that high availability is built into the platform." If the statement is correct, select 'No change is needed'. If incorrect, choose the option that corrects it.
Choose an answer
Tap an option to check your answer.
Correct answer: No change is needed.
Why this is the answer
The statement is correct. Azure Synapse Analytics (formerly Azure SQL Data Warehouse) is a Platform as a Service (PaaS) offering, meaning Microsoft manages the underlying infrastructure, including ensuring high availability. This built-in redundancy and automatic failover capabilities are a core benefit of PaaS services, relieving users from managing these aspects themselves. Automatic scaling, data compression, and versioning are also features or benefits of Azure Synapse Analytics, but they do not directly address the concept of high availability being built into the platform. Automatic scaling refers to adjusting compute resources based on workload, data compression is about optimizing storage, and versioning relates to managing changes to data or code. While important, none of these are synonymous with the platform's inherent high availability.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed