Which Azure Synapse component allows you to query data directly from your data lake (S3/ADLS Gen2) using standard T-SQL without provisioning dedicated resources?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Serverless SQL pool

Serverless SQL pools allow you to process data on-demand with pay-per-query pricing....

📋Part of Microsoft Certified: Azure Administrator Associate (AZ-104) · Azure Certification Practice
Real Exam ScenarioAzure Synapse Analytics

Which Azure Synapse component allows you to query data directly from your data lake (S3/ADLS Gen2) using standard T-SQL without provisioning dedicated resources?

✓ Correct Answer & ExplanationAzure Synapse Analytics

Correct Answer

Serverless SQL pool

Why This Answer Is Correct

Serverless SQL pools allow you to process data on-demand with pay-per-query pricing.

📚 What This Question Tests

This question evaluates your knowledge of Azure Synapse Analytics — a core concept tested in Microsoft Certified: Azure Administrator Associate (AZ-104). Understanding Azure Synapse Analytics is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.

All Microsoft Certified: Azure Administrator Associate (AZ-104) Questions →Browse All Azure Exams →

More Azure Synapse Analytics Practice Questions

You are analyzing petabytes of data for business intelligence reports. You need a fully managed, serverless enterprise data warehouse that supports SQL queries. Which service is best suited for this task?

What is the primary role of Azure Synapse Analytics in a modern data warehouse architecture?

How does Azure Synapse interact with Azure Data Lake Storage Gen2 (ADLS Gen2)?

What is 'Synapse Pipeline' used for?

Which programming languages are supported in Azure Synapse Spark pools to process big data?

← Back to Microsoft Certified: Azure Administrator Associate (AZ-104) Full Practice Hub