Which APIs to Use for NoSQL Database Model and Type
Question
You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type.
Developers need to access data in the database using an API.
You need to determine which API to use for the database model and type.
Which two APIs should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.BE
B: Azure Cosmos DB is the globally distributed, multimodel database service from Microsoft for mission-critical applications. It is a multimodel database and supports document, key-value, graph, and columnar data models.
E: Wide-column stores store data together as columns instead of rows and are optimized for queries over large datasets. The most popular are Cassandra and
HBase.
https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction https://www.mongodb.com/scale/types-of-nosql-databasesThe given scenario describes the use of a NoSQL database with a key-value and wide-column data model. To access data from this type of database using an API, we need to consider the specific API provided by the database provider or the available APIs for NoSQL databases. Below are the details of each API option mentioned in the question:
A. Table API: Table API is a part of Azure Cosmos DB, which is a multi-model NoSQL database service provided by Microsoft Azure. This API is used for accessing data in Azure Cosmos DB using a tabular data model with a partition key and a row key. This API is not suitable for a key-value and wide-column NoSQL database.
B. MongoDB API: MongoDB API is an API provided by Azure Cosmos DB, which supports the MongoDB protocol and enables us to use MongoDB client drivers to access data from Azure Cosmos DB. However, this API is not suitable for a key-value and wide-column NoSQL database.
C. Gremlin API: Gremlin API is another API provided by Azure Cosmos DB, which is used for accessing graph data stored in the NoSQL database. This API is not suitable for a key-value and wide-column NoSQL database.
D. SQL API: SQL API is an API provided by Azure Cosmos DB, which is used for accessing data using SQL-like queries. This API can be used for accessing data in a NoSQL database with a key-value and wide-column data model. Therefore, SQL API is one of the correct answers.
E. Cassandra API: Cassandra API is an API provided by Azure Cosmos DB, which is used for accessing data from Apache Cassandra databases. This API is suitable for a wide-column NoSQL database. Therefore, Cassandra API is another correct answer.
In conclusion, the correct answers for the given scenario are D (SQL API) and E (Cassandra API).
