AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides managed relational database compatible with open-source PostgreSQL?
⚠ Common exam trap
Test-takers frequently confuse 'Azure Cosmos DB for PostgreSQL' (a distributed, multi-model service) with a standard managed relational PostgreSQL database, assuming the name implies full relational compatibility, when in fact it is optimized for sharded, globally distributed workloads and lacks some PostgreSQL features like triggers and foreign keys in certain configurations.
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 relational database service specifically built for PostgreSQL, providing high availability, automated backups, and built-in security. It is the correct choice because it directly offers a managed PostgreSQL-compatible database without requiring any middleware or translation layer.
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 Managed Instance
Why it's wrong here
Azure SQL Managed Instance is a fully managed instance of Microsoft SQL Server that provides near-100% compatibility with the on-premises SQL Server engine. It is part of the Azure SQL family, using T-SQL and the TDS protocol, and is not designed to execute PostgreSQL code or accept PostgreSQL client connections. Unlike Azure Database for PostgreSQL, Managed Instance is intended for migrating existing SQL Server workloads, not PostgreSQL workloads. Hence, it is not a valid choice for a PostgreSQL-based application.
- ✓
Azure Database for PostgreSQL
Why this is correct
Azure Database for PostgreSQL is the correct answer because it is a fully managed Platform-as-a-Service (PaaS) offering that runs the open-source PostgreSQL engine. It provides built-in features such as automatic backups, point-in-time restore, high availability, and automated patching, with no administrative overhead. The service supports PostgreSQL's native wire protocol, extensions, and tools, making it directly compatible with existing PostgreSQL applications. This aligns exactly with the need for a managed PostgreSQL database in Azure.
- ✗
Azure Cosmos DB for PostgreSQL
Why it's wrong here
Azure Cosmos DB for PostgreSQL is a distributed database service based on the Citus extension, which horizontally scales PostgreSQL across multiple nodes. It is designed for large-scale, multi-tenant workloads that exceed a single node's capacity. However, it is not the standard fully managed PostgreSQL offering; that is Azure Database for PostgreSQL, which provides a simpler single-node deployment with automatic backups and high availability. Therefore, it is incorrect for a basic PostgreSQL migration scenario.
- ✗
Azure SQL Database Hyperscale
Why it's wrong here
Azure SQL Database Hyperscale is a service tier within Azure SQL Database, which is built on Microsoft SQL Server, not PostgreSQL. It is specifically engineered to support extremely large databases—up to 100 TB—by using a distributed storage architecture. Since it uses the TDS protocol and T-SQL language, it is not wire-compatible with PostgreSQL clients or queries. This makes it wrong when the requirement is a PostgreSQL-compatible managed database.
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
High availability
High availability is a system design approach that aims to keep applications and services operational and accessible with minimal downtime, even when some components fail.
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.