An administrator wants to pause a Synapse SQL resource to save costs during the weekend. Which resource type supports pausing and resuming?

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

Correct Answer: Dedicated SQL pool

Dedicated SQL pools have provisioned compute that can be paused to stop billing....

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

An administrator wants to pause a Synapse SQL resource to save costs during the weekend. Which resource type supports pausing and resuming?

✓ Correct Answer & ExplanationAzure Synapse Analytics

Correct Answer

Dedicated SQL pool

Why This Answer Is Correct

Dedicated SQL pools have provisioned compute that can be paused to stop billing.

📚 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?

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?

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

What is 'Synapse Pipeline' used for?

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