Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 1 question 44 discussion

Actual exam question from Microsoft's DP-201

Question #: 44
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: A 🗳️
Cassandrsa is a type of NoSQL database.
NoSQL database (sometimes called as Not Only SQL) is a database that provides a mechanism to store and retrieve data other than the tabular relations used in relational databases.
Incorrect Answers:
B: Core (SQL) API is a relational database which does not fit this scenario.
C: Gremlin is the graph traversal language of Apache TinkerPop. Gremlin is a functional, data-flow language that enables users to succinctly express complex traversals on (or queries of) their application's property graph.
Reference:
https://www.tutorialspoint.com/cassandra/cassandra_introduction.htm

by maynard13x8 at April 11, 2021, 6:56 p.m.

Comments

Submit Cancel

rmk4ever

Highly Voted 4 years, 1 month ago

Ans: Core (SQL) API ref: https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/4-use-the-core-sql-api-to-store-a-product-catalog

upvoted 33 times

...

maynard13x8

Highly Voted 4 years, 1 month ago

As Microsoft recommend, when you create a cosmos dB from scratch and there isn’t any previous work that you could reuse, you should use sql api , unless you need relationships between data, in which case you should use gremnlin.

upvoted 9 times

rmk4ever

4 years, 1 month ago

you are right

upvoted 1 times

Mily94

4 years, 1 month ago

are you sure? "he product properties will be different for each product and additional properties will be added to products as needed" indicates NoSQL (Cassandra)

upvoted 5 times

...

corebit

Most Recent 3 years, 5 months ago

"You've decided to look at how the new project is going to store the catalog for your customer facing e-commerce site. The sales team is likely to need support for adding new product categories quickly. The team had issues in the past as the old system that was using a relational database was too structured. Any necessary changes to add properties to products required downtime to update the table schemas, queries, and databases." "Supporting new product categories is an important requirement for your project, and the Core (SQL) schema is flexible and requires a schemaless data store." https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/4-use-the-core-sql-api-to-store-a-product-catalog

upvoted 1 times

...

tes

3 years, 11 months ago

"Cassandra This API isn't a good choice in this particular scenario, because the schema is unknown and will change over time." https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/4-use-the-core-sql-api-to-store-a-product-catalog

upvoted 2 times

...

cadio30

4 years ago

By all means it is "SQL API" Reference: https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/

upvoted 1 times

...

toandm

4 years ago

Answer is Core (SQL) API. Core (SQL) API is a document database, which is also NoSQL database. It has the name SQL because you can use SQL language to query it, not because it is relational DB

upvoted 3 times

...

Hrabia

4 years ago

A. Cassandra API is correct. the product catalog was an example for cassandra api in the MS Learning Path for this exam.

upvoted 2 times

HeywwooodJab

3 years, 12 months ago

are you sure about that? https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/4-use-the-core-sql-api-to-store-a-product-catalog "Cassandra - This API isn't a good choice in this particular scenario, because the schema is unknown and will change over time."

upvoted 2 times

...