DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 11


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.

Show Answer
Correct Answer: AE

To access data in a NoSQL database that uses both key-value and wide-column types, the appropriate APIs to use would be the Table API and the Cassandra API. The Table API is well-suited for key-value storage, providing efficient access and manipulation of key-value pairs. On the other hand, the Cassandra API is designed for wide-column storage, which is optimized for handling large datasets where data is stored in columns instead of rows.

Discussion

34 comments
Sign in to comment
mustaphaa
Nov 26, 2019

it should ba A and E

Vijaya
Sep 1, 2020

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

Sasidhar39
May 4, 2021

No, the documentation didn't refer to that

ThiruthuvaRajan
Jun 12, 2021

Answer is clearly A and E. No documentation refers to Mongo API .

Sasidhar39
May 4, 2021

No, the documentation didn't refer to that

ThiruthuvaRajan
Jun 12, 2021

Answer is clearly A and E. No documentation refers to Mongo API .

avestabrzn
Mar 7, 2020

key value --> Table API graph --> Gremlin API document --> SQL API and MongoDB API columnar --> Cassandra API so, the answer is A,E

Nayon
Jun 12, 2021

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

Frederi
Nov 19, 2019

As far as I understand, the Key Value interface should be Azure table, unless there is a legacy requirement for something else.

Juturi
Jun 3, 2020

B & E is correct as the application uses NoSQL database. We can't choose the table API as the requirement not stated that the application uses blob storage (blob storage is not a database).

fargoca
Mar 19, 2020

A and E, check the answer to question 17 later

Huepig
Mar 19, 2020

It’s D & E. Microsoft advises that Table API should only be used when migrating from Tables to CosmosDB. For any new deployment, use SQL API - this is the same when selecting MongoDB API. You would only select MongoDB API if a legacy system needs to interface to the CosmosDB database.

Huepig
Mar 19, 2020

Actually, after re-reading the question... it is B & E

Manue
Apr 19, 2020

What is the requirement to use MongoDB here? It is not neither key-value nor wide column.

Manue
Apr 19, 2020

What is the requirement to use MongoDB here? It is not neither key-value nor wide column.

wyxh
Apr 28, 2020

D & E , sql api is key value, for any new deployment, use SQL API , wide column is cassandra

ade2020
May 13, 2020

Does the data consist of simple key-value pairs? 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. https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/3-analyze-the-decision-criteria

ade2020
May 13, 2020

Does the data consist of simple key-value pairs? 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. https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/3-analyze-the-decision-criteria

Siva_s
May 7, 2020

A & E as per https://academy.datastax.com/planet-cassandra/what-is-nosql

EYIT
Sep 2, 2020

really bad and vague question. But i would vote for Table API as it typically supports key Value store. I know others would argue that the Table API should only be used when the data is stored in Azure Table Storage, but this condition is unclear in the question. MangoDB is not a typical key-value store, it should only be consider if the question mentioned that it is a legacy system built in MangoDB. Very badly worded question for sure.

krisspark
Jul 13, 2020

seems lot of debate on this question.. Answer is A & E ( Table & Cassandra).. The same is endorsed in Other Website.. Why not Mongo - It's doument but not Key-value pair storage or not wide-column.

narun
Oct 29, 2020

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.

pawhit
May 8, 2020

Think the question is unclear - is this a legacy question or not? If it isn't legacy then there is 1 answer - D as guidance is to use Core SQL even for wide-column. Because it requires 2 answers then it must be legacy so B and E.

TheCyanideLancer
May 31, 2020

A and E https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/2-identify-the-technology-options

Sree5
Sep 4, 2020

Key-Value -> Table API, Wide-Column -> Cassandra API

abhinavkj
Jul 16, 2020

key Value is Table where as Wide column is Casandra

lastname
Jul 23, 2020

A&E Table API is key value Cassandra is wide column

panya
Sep 22, 2020

It should be A & E

nacondras
Sep 25, 2020

The answer should be Table API for key value and Cassandra API for wide column

UKiran
Nov 19, 2020

Answer is Table APi and cassandra API

JCM
Sep 20, 2019

Should B not be Azure Cosmos DB?

Neuron
Oct 3, 2019

No, it is asking for an API. Cosmos is not an API... If a NoSQL solution uses Mongo or Cassandra the idea is that it's easy to migrate it onto Cosmos later.

goodzilla
Mar 5, 2020

With just two options to select Why not A & B ? (option B) As Mongo DB is a cross platform document-oriented DB as Cosmos with json-like documents with schema seems to me more applicable than Cassandra (high-availability)

EnricVives
Sep 3, 2020

The correct answer is B and E as seen in other websites

hart232
Sep 22, 2020

Key value pair - SQL API. "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."

lingjun
Nov 9, 2020

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)

lingjun
Nov 13, 2020

https://www.mongodb.com/key-value-database

lingjun
Nov 13, 2020

ignore it. I would go for Table

Aditya167
Nov 23, 2020

it should be A and E

syu31svc
Nov 23, 2020

It's A & E Cassandra is wide-table and Table is key

ViniJsr
Nov 23, 2020

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

chaoxes
Dec 6, 2020

Should be A (Table API) and E (Cassandra API). Table API is the best solution for key-value model.

rmn900
Dec 7, 2020

AE. Table uses key/value. Not MongoDB. B is wrong.

afonsomeireles
Jan 23, 2021

It's A (Table API for key-value pairs) and E (Cassandra API for wide-columns)

ssantos
Jan 26, 2021

Table API and Cassandra API for sure

SilNilanjan
Feb 24, 2021

A & E certainly

deepz8
Mar 16, 2021

Key-Value -> Table API Wide column -> Cassandra API

LG5
Mar 29, 2021

It's A and E.

massnonn
Nov 20, 2021

the correct answer is Table Api e Cassandra Api. so A - E