Skip to main content
  1. Public practice questions
  2. AZ-900 Practice Exams | Azure Fundamentals
  3. Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

Question 292 — Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

How does Azure Synapse Analytics deliver end-to-end analytics at cloud scale? (Select 1 answer).

  1. It stores petabytes of data and runs queries on relational and non-relational data.

  2. It stores terabytes of data and performs in-depth drilling to provide data insights.

  3. It uses functions in two modes: data storage and data analytics.

  4. It provisions clusters with multiple services to perform a specific task efficiently.

Correct answers

  1. It stores petabytes of data and runs queries on relational and non-relational data.

Explanations

Correct:
It stores petabytes of data and runs queries on relational and non-relational data.
Azure Synapse enables cloud-scale analytics by seamlessly integrating big data and data warehousing. It stores and processes petabytes of data, allowing queries across relational and non-relational datasets with high performance.

Wrong:
It stores terabytes of data and performs in-depth drilling to provide data insights.
Azure Synapse is designed for massive-scale data processing, handling petabytes of data rather than being limited to terabytes.

It uses functions in two modes: data storage and data analytics.
This oversimplifies the capabilities of Azure Synapse, which integrates multiple advanced data and analytics features.

It provisions clusters with multiple services to perform a specific task efficiently.
While clusters may be part of Azure Synapse's architecture, its primary advantage lies in its unified approach to data storage and analytics.