BenchMark Quizzes by MDFT Pro

Identify Azure Cosmos DB APIs That Use SQL Syntax

You work as a database architect at MDFT Pro, a well-known training agency that provides Microsoft certification courses. The academy is planning to migrate their student management system to Azure Cosmos DB to handle the growing number of students and course data.

Mark, the lead developer, has asked you to identify which Azure Cosmos DB APIs support SQL syntax for querying data. This will help the development team choose the most appropriate API for their existing SQL-based reporting tools and ensure a smoother migration process.

Which Azure Cosmos DB APIs use SQL syntax?

Choose all correct answers from the options below.

Explanations for each answer:

MongoDB is incorrect. The MongoDB API supports MongoDB Query Language (MQL), which is object-oriented, not SQL syntax.
Core is correct. The Core (SQL) API uses SQL syntax for querying data, making it familiar to developers with SQL experience and compatible with existing SQL-based tools.
Cassandra is correct. The Cassandra API supports CQL (Cassandra Query Language), which is based on SQL syntax and provides familiar querying capabilities for developers.
Table is incorrect. The Table API works with key-value data and uses requests based on a namespace, similar to Azure Blob Storage, not SQL syntax.
Gremlin is incorrect. The Gremlin API is designed for graph data and uses graph syntax, not SQL syntax.

Learn more about Azure Cosmos DB APIs:

Azure Cosmos DB APIs

Exam Preparation Quiz

Identify Azure Cosmos DB APIs That Use SQL Syntax