Designing an Azure Data Solution (legacy) — Question 36

You are designing a product catalog for a customer. The product data will be stored in Azure Cosmos DB. The product properties will be different for each product and additional properties will be added to products as needed.
Which Cosmos DB API should you use to provision the database?

Answer options

• A. Cassandra API
• B. Core (SQL) API
• C. Gremlin API

Correct answer: A

Explanation

The Cassandra API is the correct choice because it supports flexible schemas and allows for different product properties to be added dynamically. The Core (SQL) API is better suited for structured data with a fixed schema, while the Gremlin API is designed for graph data, which does not align with the needs of a product catalog.