Which Azure service provides a managed relational database compatible with PostgreSQL?
Azure Database for PostgreSQL is the fully managed service for open-source PostgreSQL workloads.
Why this answer
Azure Database for PostgreSQL is a fully managed, enterprise-ready relational database service built on the open-source PostgreSQL engine. It provides built-in high availability, automated backups, and scaling, making it the correct choice for a managed PostgreSQL-compatible database in Azure.
Exam trap
The trap here is confusing Azure Cosmos DB for PostgreSQL (a distributed, sharded database) with the standard managed Azure Database for PostgreSQL, leading candidates to select the Cosmos DB option when the question asks for a managed relational database compatible with PostgreSQL.
How to eliminate wrong answers
Option A is wrong because Azure SQL Database is a managed relational database based on Microsoft SQL Server engine, not PostgreSQL. Option C is wrong because Azure Cosmos DB for PostgreSQL (formerly Hyperscale (Citus)) is a distributed, scale-out option that uses PostgreSQL but is primarily designed for multi-tenant and sharded workloads, not a standard managed relational database service. Option D is wrong because Azure Database for MariaDB is a managed relational database based on the MariaDB engine, which is a fork of MySQL, not PostgreSQL.