Correct Answer: Azure SQL Virtual Machines
Running SQL on a VM gives you full control but requires you to manage patching and backups....
Correct Answer
Azure SQL Virtual Machines
Why This Answer Is Correct
Running SQL on a VM gives you full control but requires you to manage patching and backups.
This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Administrator Associate (AZ-104). 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.
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?
What are the two primary purchasing models for Azure SQL Database?
An administrator wants to manage a group of several Azure SQL Databases together to share a single set of resources (like CPU and RAM). Which feature should they use?
Which Azure SQL feature automatically scales compute based on workload demand and bills for compute used per second?
What is 'Active Geo-Replication' in Azure SQL Database used for?