Skip to Content

AI-900: How to choose Azure Cosmos DB for multiple APIs and data models

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.

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.

Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.