nerdexam
Microsoft

DP-500 · Question #94

Which of the following file types is NOT supported by the Serverless SQL Pool in Azure Synapse Analytics?

The correct answer is A. Avro. Avro is the file format not natively supported by the Serverless SQL Pool in Azure Synapse Analytics for direct querying via OPENROWSET.

Query and transform data

Question

Which of the following file types is NOT supported by the Serverless SQL Pool in Azure Synapse Analytics?

Options

  • AAvro
  • BParquet
  • CJSON
  • DCSV

How the community answered

(21 responses)
  • A
    90% (19)
  • C
    5% (1)
  • D
    5% (1)

Why each option

Avro is the file format not natively supported by the Serverless SQL Pool in Azure Synapse Analytics for direct querying via OPENROWSET.

AAvroCorrect

The Serverless SQL Pool supports Parquet, CSV, JSON, and Delta Lake formats for querying files in Azure Data Lake or Blob Storage via OPENROWSET. Avro format is not in the supported file format list for Serverless SQL Pool, making it the correct answer for the unsupported format.

BParquet

Parquet is one of the primary and most performant formats supported by Serverless SQL Pool's OPENROWSET function.

CJSON

JSON files are supported by Serverless SQL Pool and can be queried using OPENROWSET with the appropriate WITH clause or JSON_VALUE functions.

DCSV

CSV (and other delimited text formats) is fully supported by Serverless SQL Pool and is one of the most commonly queried file types.

Concept tested: Serverless SQL Pool supported file formats in Azure Synapse Analytics

Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage

Topics

#Azure Synapse Analytics#Serverless SQL Pool#File formats

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice