Your application requires a relational database that can automatically scale compute resources up and down based on demand, and pause during periods of inactivity to save costs. Which option should you choose?

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

Correct Answer: Azure SQL Database Serverless

Azure SQL Database Serverless automatically scales compute for single databases and bills for compute used per second....

📋Part of Microsoft Certified: Azure Fundamentals (AZ-900) · Azure Certification Practice
Real Exam ScenarioAzure SQL Database

Your application requires a relational database that can automatically scale compute resources up and down based on demand, and pause during periods of inactivity to save costs. Which option should you choose?

✓ Correct Answer & ExplanationAzure SQL Database

Correct Answer

Azure SQL Database Serverless

Why This Answer Is Correct

Azure SQL Database Serverless automatically scales compute for single databases and bills for compute used per second.

📚 What This Question Tests

This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Fundamentals (AZ-900). Understanding Azure SQL Database 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 Fundamentals (AZ-900) Questions →Browse All Azure Exams →

More Azure SQL Database Practice Questions

A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?

Which Azure SQL Database service tier is best suited for most business workloads, providing balanced compute and storage options?

Which Azure service is a fully managed relational database that provides near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine?

What is the purpose of Transparent Data Encryption (TDE) in Azure SQL Database?

You need to store and manage relational data for multiple independent databases while sharing a fixed set of resources (CPU and memory). Which Azure SQL Database feature should you use?

← Back to Microsoft Certified: Azure Fundamentals (AZ-900) Full Practice Hub