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?

Sign in or unlock DP-900 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.

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

Unlock DP-900 to see the answer

You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock DP-900 - $49.99 / 30 days Sign in

Topics

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

Full DP-900 Practice