Learn how to choose Azure Cosmos DB, a fully managed NoSQL database service that supports multiple APIs and data models, such as document, key-value, graph, and column-family.
Table of Contents
Question
Tradewind Traders is planning to migrate to Azure cloud services but before they do, management has asked you to spend some time researching the Database solutions available in Azure with specific regard to the use of multiple APIs. Based on your research, which of the following cloud database solutions is most appropriate to provide this feature?
A. Azure Cosmos DB
B. Azure Database for PostgreSQL
C. Azure Database for MySQL
D. Azure SQL Database
Answer
A. Azure Cosmos DB
Explanation
Cosmos DB’s level of flexibility means that as you migrate your company’s databases to Azure Cosmos DB, your developers can stick with the API where they’re most comfortable.
The answer to the question is A. Azure Cosmos DB. Here is why:
Azure Cosmos DB is a fully managed NoSQL database service that supports multiple APIs and data models. By using different APIs, you can access and query your data in Azure Cosmos DB as if it were a document, key-value, graph, or column-family database. The APIs that Azure Cosmos DB supports are:
- API for NoSQL: This is the native API for Azure Cosmos DB that stores data in document format. It offers the best end-to-end experience and performance as it is fully integrated with the Azure Cosmos DB service and SDKs.
- API for MongoDB: This API implements the wire protocol of MongoDB, an open-source document database. It allows you to use the existing MongoDB drivers, tools, and resources to interact with Azure Cosmos DB.
- API for PostgreSQL: This API implements the wire protocol of PostgreSQL, an open-source relational database. It allows you to use the existing PostgreSQL drivers, tools, and resources to interact with Azure Cosmos DB.
- API for Cassandra: This API implements the wire protocol of Cassandra, an open-source column-family database. It allows you to use the existing Cassandra drivers, tools, and resources to interact with Azure Cosmos DB.
- API for Gremlin: This API implements the wire protocol of Gremlin, an open-source graph database. It allows you to use the existing Gremlin drivers, tools, and resources to interact with Azure Cosmos DB.
- API for Table: This API implements the wire protocol of Azure Table storage, a key-value database. It allows you to use the existing Azure Table storage drivers, tools, and resources to interact with Azure Cosmos DB.
You can choose any one of these APIs to build your application or migrate your existing data to Azure Cosmos DB. However, you can only use one API against a container, multiple are not possible due to the way the data is stored and retrieved. The only exception is Gremlin and NoSQL API, which can be used together as they share the same data model.
The other options, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure SQL Database, are not correct because they do not support multiple APIs. They are single-model database services that only support their respective APIs and data models.
Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Azure AI Fundamentals AI-900 exam and earn Microsoft Azure AI Fundamentals AI-900 certification.
