Exam AZ-303 topic 4 question 2 discussion

This is from Az-303 Exam Manual: Azure Cosmos DB currently provides the following APIs in general availability (GA). ■   Core (SQL) API and MongoDB API for JSON document data. ■   Cassandra for a columnar or column-family datastore. ■   Azure Table API for key-value datastore. ■   Gremlin (graph) API for graph data.

given answer is correct as per below link zure Cosmos DB is Microsoft's globally distributed, multi-model database service. Where multi-model means Azure Cosmos DB supports multiple APIs and multiple data models, different APIs use different data formats for storage and wire protocol. For example, SQL uses JSON, MongoDB uses BSON, Table uses EDM, Cassandra uses CQL, Gremlin uses JSON format. Each API operates independently, except the Gremlin and SQL API, which are interoperable. https://docs.microsoft.com/en-us/azure/cosmos-db/faq

Keyword is "JSON" API. Look below Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. Where multi-model means Azure Cosmos DB supports multiple APIs and multiple data models, different APIs use different data formats for storage and wire protocol. For example, SQL uses JSON, MongoDB uses BSON, Table uses EDM, Cassandra uses CQL, Gremlin uses JSON format. As a result, we recommend using the same API for all access to the data in a given account. Each API operates independently, except the API for Gremlin and NoSQL, which are interoperable.

if we say MongoDB uses BSON. then, Choosing Gremlin as the API provides a graph-based view over the data. Remember that at the lowest level, all data in any Azure Cosmos DB is stored in an ARS format (Results will be returned in GraphSON format, ). So A is not right. https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options

B & D is correct answer

AD is correct as the question clearly asks for JSON. Here are the protocols : Azure Cosmos DB supports multiple APIs and multiple data models, different APIs use different data formats for storage and wire protocol. For example, SQL uses JSON, MongoDB uses BSON, Table uses EDM, Cassandra uses CQL, Gremlin uses JSON format. As a result, we recommend using the same API for all access to the data in a given account. Each API operates independently, except the Gremlin and SQL API, which are interoperable. READ : https://docs.microsoft.com/en-us/azure/cosmos-db/faq

Mongo and Core SQL Mongo: https://docs.mongodb.com/guides/server/introduction/ In MongoDB, data is stored as documents. These documents are stored in MongoDB in JSON (JavaScript Object Notation) format. JSON documents support embedded fields, so related data and lists of data can be stored with the document instead of an external table.

B and D, used it in a real life scenario

I think B&D are correct

I will go with B&D

B. MongoDB & D. Core SQL

Only Gremlin and SQL can support JSON.

Answer should be B & D

Core (SQL) - Core (SQL) is the default API for Azure Cosmos DB, which provides you with a view of your data that resembles a traditional NoSQL document store. You can query the hierarchical JSON documents with a SQL-like language. MongoDB - The data is stored in document format, which is the same as using Core (SQL). https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options B and D are correct

https://docs.microsoft.com/en-us/azure/cosmos-db/faq Can I use multiple APIs to access my data? For example, SQL uses JSON, MongoDB uses BSON, Table uses EDM, Cassandra uses CQL, Gremlin uses JSON format. As a result, we recommend using the same API for all access to the data in a given account.

I had this question in the exam that i took on July 14th 2021

Answer should be B & D Answer should be A & D https://docs.microsoft.com/en-us/azure/cosmos-db/faq Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. Where multi-model means Azure Cosmos DB supports multiple APIs and multiple data models, different APIs use different data formats for storage and wire protocol. For example, SQL uses JSON, MongoDB uses BSON, Table uses EDM, Cassandra uses CQL, Gremlin uses JSON format. As a result, we recommend using the same API for all access to the data in a given account. Each API operates independently, except the Gremlin and SQL API, which are interoperable.