nerdexam
Microsoft

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.

Implement and manage a data analytics environment

Question

Which of the following is not a valid option to analyze data using Azure Synapse Analytics?

Options

  • ASpark Pool
  • BDedicated SQL Pool
  • CSQL Elastic Pool
  • DServerless SQL Pool

How the community answered

(50 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    88% (44)
  • D
    8% (4)

Why each option

SQL Elastic Pool is an Azure SQL Database feature, not an analysis compute option within Azure Synapse Analytics.

ASpark Pool

Spark Pool is a valid Azure Synapse Analytics compute option that provides Apache Spark-based distributed processing for big data analytics.

BDedicated SQL Pool

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.

CSQL Elastic PoolCorrect

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.

DServerless 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

#Azure Synapse Analytics#Synapse Pools#Data Analysis Compute#Azure Services

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice