Exam AZ-305 topic 2 question 27 discussion

Correct answer: B https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api 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) If you’re looking for a managed open source relational database with high performance and geo-replication, Azure Cosmos DB for PostgreSQL is the recommended choice.

The correct answer is B. PostgreSQL. Azure Cosmos DB's API for PostgreSQL provides full support for SQL queries, geo-replication, and allows you to store and access data relationally. It offers automatic and instant scalability, global distribution, and effortless replication of data across Azure regions, fulfilling all of your mentioned requirements. A. Apache Cassandra is a NoSQL database that does not natively support SQL queries. While it does offer some SQL-like capabilities, it is not a fully relational database. C. MongoDB is a NoSQL database and does not support the relational data model, although it does provide SQL-like query language. D. NoSQL is a type of database design that can store and retrieve data, but it isn't a specific API. Also, not all NoSQL databases support SQL queries and relational data storage.

B. PostgreSQL

B is correct

These are databases not APIs so I don't quite understand this question.

If you’re looking for a managed open source relational database with high performance and geo-replication, Azure Cosmos DB for PostgreSQL is the recommended choice. To learn more, see the Azure Cosmos DB for PostgreSQL introduction.

B. PostgreSQL Azure Cosmos DB provides support for multiple APIs, each tailored to different data models and query languages. The PostgreSQL API is well-suited for applications that require relational data storage and the ability to execute SQL queries. It offers compatibility with the PostgreSQL wire protocol and supports standard SQL syntax, allowing you to leverage your existing SQL skills and tools. Additionally, the PostgreSQL API in Azure Cosmos DB provides built-in support for geo-replication, allowing you to replicate your data across multiple regions for high availability and disaster recovery purposes. This ensures that your data is accessible and resilient even in the event of a regional outage or failure. Therefore, the recommended API for Azure Cosmos DB in this scenario is the PostgreSQL API.

If you’re looking for a managed open source relational database with high performance and geo-replication, Azure Cosmos DB for PostgreSQL is the recommended choice. To learn more, see the https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api#api-for-postgresql

B: PostgreSQL But finding proper info in one place..... I am not DB guy at all. https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api#api-for-postgresql

API for NoSQL is native to Azure Cosmos DB.