Microsoft Azure Data Fundamentals — Question 16

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?

Answer options

• A. Azure Functions
• B. Microsoft SQL Server Integration Services (SSIS)
• C. PolyBase
• D. Azure Data Factory

Correct answer: C

Explanation

The correct answer is C, PolyBase, as it allows querying external data stored in Azure Data Lake Storage Gen 2 directly from Azure Synapse Analytics using Transact-SQL. Options A and B do not provide the capability to directly query files in this context, while D, Azure Data Factory, is primarily used for data integration and orchestration, not direct querying.