exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 1 question 20 discussion

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

HOTSPOT -
You are designing a new application that uses Azure Cosmos DB. The application will support a variety of data patterns including log records and social media relationships.
You need to recommend which Cosmos DB API to use for each data pattern. The solution must minimize resource utilization.
Which API should you recommend for each data pattern? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Log records: SQL -

Social media mentions: Gremlin -
You can store the actual graph of followers using Azure Cosmos DB Gremlin API to create vertexes for each user and edges that maintain the "A-follows-B" relationships. With the Gremlin API, you can get the followers of a certain user and create more complex queries to suggest people in common. If you add to the graph the Content Categories that people like or enjoy, you can start weaving experiences that include smart content discovery, suggesting content that those people you follow like, or finding people that you might have much in common with.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/social-media-apps

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
chaoxes
Highly Voted 4 years, 5 months ago
Log records: SQL (because logs are row oriented) Social Media: Gremlin (because it uses relationships)
upvoted 27 times
...
cadio30
Most Recent 4 years ago
propose solution is correct. Cassandra API is mostly used to handle high volume and real time data while the requirement is related to log records, SQL API is sufficient in this terms. Gremlin API is appropriate when we are talking about connection between entities. Reference: https://acloudguru.com/blog/engineering/azure-cosmos-db-apis-use-cases-and-trade-offs
upvoted 4 times
...
klasius
5 years, 3 months ago
why SQL over Cassandra for log records?
upvoted 3 times
z8zhong
5 years, 2 months ago
log data are row-oriented so SQL handle them better, Cassandra are mainly for column-oriented data
upvoted 46 times
...
kempstonjoystick
5 years, 2 months ago
It also states in the documentation that Cassandra is only recommend to migrate existing Cassandra databases to CosmosDB. In all other cases, the SQL Api is recommended. https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/3-analyze-the-decision-criteria
upvoted 40 times
...
...
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
Loading ...