You are designing an application that uses Azure Cosmos DB to consolidate sales data from multiple countries. The chosen API must support SQL-style queries, geo-replication, and relational storage and access. Which API should you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: PostgreSQL.
Why this is the answer
The correct answer is PostgreSQL. Azure Cosmos DB for PostgreSQL offers relational storage and access, supports SQL-style queries, and provides geo-replication capabilities, aligning with all the requirements. Apache Cassandra is a NoSQL database that offers geo-replication but is not relational and uses its own query language (CQL), not SQL. MongoDB is also a NoSQL document database, not relational, and uses a JSON-based query language. The NoSQL (Core SQL API) in Cosmos DB is a document database, not relational, despite supporting a SQL-like query language.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed