DP-500 · Question #96
Which of the following is not a valid option to analyze data using Azure Synapse Analytics?
The correct answer is C. SQL Elastic Pool. SQL Elastic Pool is an Azure SQL Database feature, not an analysis compute option within Azure Synapse Analytics.
Question
Options
- ASpark Pool
- BDedicated SQL Pool
- CSQL Elastic Pool
- DServerless SQL Pool
How the community answered
(50 responses)- A2% (1)
- B2% (1)
- C88% (44)
- D8% (4)
Why each option
SQL Elastic Pool is an Azure SQL Database feature, not an analysis compute option within Azure Synapse Analytics.
Spark Pool is a valid Azure Synapse Analytics compute option that provides Apache Spark-based distributed processing for big data analytics.
Dedicated SQL Pool (formerly Azure SQL Data Warehouse) is a valid Synapse Analytics compute option that provides enterprise-scale data warehousing with massively parallel processing.
SQL Elastic Pool is a resource-sharing model within Azure SQL Database that allows multiple databases to share a combined pool of compute and storage resources. It belongs to Azure SQL Database, not Azure Synapse Analytics, and is therefore not a valid Synapse analysis option. The correct Synapse compute options are Spark Pool, Dedicated SQL Pool, and Serverless SQL Pool.
Serverless SQL Pool is a valid Synapse Analytics compute option that enables on-demand T-SQL querying of data in Azure storage without provisioning dedicated resources.
Concept tested: Azure Synapse Analytics compute pool types and capabilities
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/overview-what-is
Topics
Community Discussion
No community discussion yet for this question.