You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?

The correct answer is C. PolyBase. PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, you can now use PolyBase to access external…

Submitted by hans_de· Mar 30, 2026Describe an analytics workload on Azure

Question

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?

Options

AAzure Functions
BMicrosoft SQL Server Integration Services (SSIS)
CPolyBase
DAzure Data Factory

How the community answered

(34 responses)

A
3% (1)
B
6% (2)
C
91% (31)

Explanation

PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, you can now use PolyBase to access external data in SQL Server, Oracle, Teradata, and MongoDB. https://docs.microsoft.com/en-gb/learn/modules/explore-data-storage-processing-azure/3- explore-azure-synapse-analytics

Topics

#PolyBase#Azure Synapse Analytics#Azure Data Lake Storage Gen2#T-SQL

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice