Azure SQL Data Warehouse Benefits - Exam AZ-900: Microsoft Azure Fundamentals

High Availability in Azure SQL Data Warehouse

Prev Question Next Question

Question

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.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

A

Azure Data Warehouse (now known as Azure Synapse Analytics) is a PaaS offering from Microsoft. As with all PaaS services from Microsoft, SQL Data

Warehouse offers an availability SLA of 99.9%. Microsoft can offer 99.9% availability because it has high availability features built into the platform.

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-faq

The correct answer is B. Role-Based Access Control (RBAC) roles.

Role-Based Access Control (RBAC) is a security system used in Azure to control access to resources based on the roles assigned to users or groups. It enables administrators to manage access to Azure resources, such as Virtual Desktop resources, by assigning roles to users or groups. These roles are defined with a set of permissions that determine what actions the user or group can perform on the resource.

RBAC can be used to grant permissions to various Azure resources, including Virtual Desktop resources. This includes permissions to create, update, delete, or read Virtual Desktop resources, as well as permissions to manage the Virtual Desktop infrastructure.

Tags are labels that can be applied to Azure resources to help organize and identify them. They are not used to grant permission to resources.

Resource groups are containers used to manage and organize Azure resources. They can be used to manage access to resources, but they are not used to grant permission to resources.

Application Security Groups are used to manage network security in Azure. They can be used to create network security rules that allow or deny traffic to Virtual Desktop resources, but they are not used to grant permission to resources.

Therefore, B. Role-Based Access Control (RBAC) roles are used to grant permission to Azure Virtual Desktop resources.

The underlined text states that "high availability is built into the platform" in reference to Azure SQL Data Warehouse.

This statement is correct. Azure SQL Data Warehouse is a cloud-based, enterprise-level data warehousing service that is built on the Azure platform. It is designed to deliver fast query performance over large volumes of data, and it provides high availability by default.

The service provides multiple layers of redundancy to ensure that the data warehouse remains available even in the face of hardware failures or other issues. For example, data is replicated across multiple nodes within a data center, and backups are taken regularly to ensure that data can be restored in the event of a disaster.

Therefore, the correct answer is A. No change is needed.