AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a fully managed PostgreSQL database with automatic backups, high availability, and intelligent performance recommendations?
⚠ Common exam trap
Many candidates confuse Azure Cosmos DB for PostgreSQL (a distributed, horizontally-scalable option) with the fully managed single-node Azure Database for PostgreSQL, which is the correct answer for automatic backups and intelligent performance recommendations.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Azure Database for PostgreSQL
Azure Database for PostgreSQL is a fully managed Platform-as-a-Service (PaaS) offering that provides built-in automatic backups, high availability with a 99.99% SLA, and intelligent performance recommendations via the Query Performance Insight and Automatic Tuning features. It handles patching, backups, and replication automatically, freeing you from administrative overhead.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a fully managed relational database, but it runs the proprietary Microsoft SQL Server engine, not PostgreSQL. It uses Transact-SQL (T-SQL) and offers SQL Server-specific features such as elastic pools and SQL Analytics, which are irrelevant to PostgreSQL workloads. Because the database engine is fundamentally different, migrating or connecting a PostgreSQL client to Azure SQL Database would fail at the protocol and syntax level.
- ✓
Azure Database for PostgreSQL
Why this is correct
Azure Database for PostgreSQL is the fully managed Platform-as-a-Service (PaaS) offering for open-source PostgreSQL. It automatically handles high availability, patching, backups, and scaling, with performance tuning features such as intelligent insights. As the standard managed service for PostgreSQL in Azure, it lets developers focus on applications rather than infrastructure operations.
- ✗
Azure Cosmos DB for PostgreSQL
Why it's wrong here
Azure Cosmos DB for PostgreSQL is a distributed database service that extends PostgreSQL using the Citus extension to shard data across multiple nodes. It is designed for multi-tenant, high-scale, or geo-distributed applications that need horizontal scaling, not for typical single-node PostgreSQL deployments. The standard fully managed, non-scaled offering is Azure Database for PostgreSQL, making Cosmos DB for PostgreSQL an over-specialized choice for most workloads.
- ✗
PostgreSQL on Azure VMs
Why it's wrong here
PostgreSQL on Azure VMs is an Infrastructure-as-a-Service (IaaS) deployment where you provision a virtual machine and install and configure PostgreSQL yourself. This approach requires you to manage the operating system, PostgreSQL version upgrades, security patches, backups, and high availability, which is operationally intensive. Azure Database for PostgreSQL is a fully managed Platform-as-a-Service that offloads these administrative tasks, making PaaS the appropriate choice for a managed PostgreSQL experience.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Availability
Availability is the measure of how often a system or service is operational and accessible when needed, typically expressed as a percentage of uptime.
Key term
Azure Database for PostgreSQL
Azure Database for PostgreSQL is a fully managed, scalable relational database service in Microsoft Azure that runs the open-source PostgreSQL engine, handling backups, patching, and high availability for you.
About these practice questions
This AZ-900 question is part of Courseiva's 981-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.