You are designing an app that will use Azure Cosmos DB to collate sales from multiple countries. You need to recommend an API for the app. The solution must meet the following requirements…

The correct answer is B. PostgreSQL. Store data relationally: - NoSQL stores data in document format - MongoDB stores data in a document structure (BSON format) Support SQL Queries: - Apache Cassandra uses Cassandra Query Language (CQL) https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api

Submitted by cyberguy42· Mar 6, 2026Design data storage solutions

Question

You are designing an app that will use Azure Cosmos DB to collate sales from multiple countries. You need to recommend an API for the app. The solution must meet the following requirements: - Support SQL queries. - Support geo-replication. - Store and access data relationally. Which API should you recommend?

Options

AApache Cassandra
BPostgreSQL
CMongoDB
DNoSQL

How the community answered

(33 responses)

A
3% (1)
B
85% (28)
C
9% (3)
D
3% (1)

Explanation

Store data relationally: - NoSQL stores data in document format - MongoDB stores data in a document structure (BSON format) Support SQL Queries: - Apache Cassandra uses Cassandra Query Language (CQL) https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api

Topics

#Cosmos DB for PostgreSQL#geo-replication#relational data#SQL queries

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice