ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 1 question 11 discussion

Actual exam question from Microsoft's DP-200
Question #: 11
Topic #: 1
[All DP-200 Questions]

You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type.
Developers need to access data in the database using an API.
You need to determine which API to use for the database model and type.
Which two APIs should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Table API
  • B. MongoDB API
  • C. Gremlin API
  • D. SQL API
  • E. Cassandra API
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
B: Azure Cosmos DB is the globally distributed, multimodel database service from Microsoft for mission-critical applications. It is a multimodel database and supports document, key-value, graph, and columnar data models.
E: Wide-column stores store data together as columns instead of rows and are optimized for queries over large datasets. The most popular are Cassandra and
HBase.
References:
https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction https://www.mongodb.com/scale/types-of-nosql-databases
by JCM at Sept. 20, 2019, 11:02 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mustaphaa
Highly Voted 5 years, 5 months ago
it should ba A and E
upvoted 97 times
Vijaya
4 years, 7 months ago
as per documentation mongo API is multi-model and supports document, key-value, graph, and columnar data models so answer is correct ref https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-introduction
upvoted 2 times
ThiruthuvaRajan
3 years, 10 months ago
Answer is clearly A and E. No documentation refers to Mongo API .
upvoted 1 times
...
Sasidhar39
3 years, 11 months ago
No, the documentation didn't refer to that
upvoted 1 times
...
...
...
avestabrzn
Highly Voted 5 years, 1 month ago
key value --> Table API graph --> Gremlin API document --> SQL API and MongoDB API columnar --> Cassandra API so, the answer is A,E
upvoted 87 times
Nayon
3 years, 10 months ago
right answer is A,E but slight change in your description. key value --> Cassandra API graph --> Gremlin API document --> SQL API and MongoDB API columnar --> Table API https://cloud.netapp.com/blog/azure-cvo-blg-azure-nosql-types-services-and-a-quick-tutorial#H_H1
upvoted 3 times
...
...
massnonn
Most Recent 3 years, 5 months ago
the correct answer is Table Api e Cassandra Api. so A - E
upvoted 1 times
...
LG5
4 years ago
It's A and E.
upvoted 1 times
...
deepz8
4 years, 1 month ago
Key-Value -> Table API Wide column -> Cassandra API
upvoted 1 times
...
SilNilanjan
4 years, 2 months ago
A & E certainly
upvoted 1 times
...
ssantos
4 years, 2 months ago
Table API and Cassandra API for sure
upvoted 1 times
...
afonsomeireles
4 years, 3 months ago
It's A (Table API for key-value pairs) and E (Cassandra API for wide-columns)
upvoted 1 times
...
rmn900
4 years, 4 months ago
AE. Table uses key/value. Not MongoDB. B is wrong.
upvoted 1 times
...
chaoxes
4 years, 4 months ago
Should be A (Table API) and E (Cassandra API). Table API is the best solution for key-value model.
upvoted 1 times
...
ViniJsr
4 years, 5 months ago
Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database. It's a globally distributed, low latency, high throughput solution with client SDKs available for . NET, Java, Python, and Node. So Answer will be A and E
upvoted 1 times
...
syu31svc
4 years, 5 months ago
It's A & E Cassandra is wide-table and Table is key
upvoted 1 times
...
Aditya167
4 years, 5 months ago
it should be A and E
upvoted 1 times
...
UKiran
4 years, 5 months ago
Answer is Table APi and cassandra API
upvoted 2 times
...
lingjun
4 years, 5 months ago
I think it should be MongoDB, since it uses key-value (which is the json format in document). but not storing the key-value pairs(then should be Table API)
upvoted 1 times
lingjun
4 years, 5 months ago
https://www.mongodb.com/key-value-database
upvoted 1 times
...
lingjun
4 years, 5 months ago
ignore it. I would go for Table
upvoted 1 times
...
...
narun
4 years, 5 months ago
It should be D and E. Before Azure Cosmos DB existed, Redis or the Table API might have been a good fit for this kind of data; however, Core (SQL) API is now the better choice, as it offers a richer query experience, with improved indexing over the Table API.
upvoted 4 times
...
nacondras
4 years, 7 months ago
The answer should be Table API for key value and Cassandra API for wide column
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago