exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 13 question 1 discussion

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

HOTSPOT -
You need to build a solution to collect the telemetry data for Race Central.
What should you use? 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:
API: Table -
Azure Cosmos DB provides native support for wire protocol-compatible APIs for popular databases. These include MongoDB, Apache Cassandra, Gremlin, and
Azure Table storage.
Scenario: The telemetry data must migrate toward a solution that is native to Azure.

Consistency level: Strong -
Use the strongest consistency Strong to minimize convergence time.
Scenario: The data must be written to the Azure datacenter closest to each race and must converge in the least amount of time.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels

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
zulajariwala
Highly Voted 5 years ago
MongoDB: telemetry data is sent to MongoDB database Eventual: The data should be written to nearest data center and latency should be minimize so answer in eventual. I have check on other website and this are the correct answer for this..
upvoted 85 times
ThiruthuvaRajan
3 years, 12 months ago
Yes you're correct. Requirement is to create Azure cosmos db and SQL database. So mongo DB API is correct and second answer "Eventual" as well.
upvoted 1 times
...
...
STH
Highly Voted 5 years, 6 months ago
The telemetry data is sent to a MongoDB database : so we need MongoDB API
upvoted 42 times
z8zhong
5 years, 3 months ago
Mongo or SQL API both works
upvoted 2 times
Huepig
5 years, 2 months ago
No, it’s just MongoDB in this case - The existing applications is using MongoDB. To minimise the development time, use MongoDB API.
upvoted 12 times
Ard
4 years, 11 months ago
there is no requirement to minimize development
upvoted 4 times
...
...
...
Neelesh
4 years, 11 months ago
Based on the requirement "The telemetry data must migrate toward a solution that is native to Azure", the Table API seems more logical.
upvoted 5 times
Candiy
4 years, 6 months ago
It absolutely does not
upvoted 7 times
...
...
deepz8
4 years, 2 months ago
+1 for Mongo DB
upvoted 1 times
...
...
dev2dev
Most Recent 4 years, 4 months ago
MS recommends using SQL for new apps and other APIs for existing apps. So the answers IMO, Mongo and Strong.
upvoted 2 times
...
mohowzeh
4 years, 5 months ago
I think "Mongo DB" and "strong". MongoDB since the application already uses it. Strong, because the cars should be monitored _in real time_. Lower consistencies increase waiting periods, and IMHO the real-time business requirement has priority over any technical requirement about RU's.
upvoted 6 times
...
syu31svc
4 years, 6 months ago
API is MongoDB for sure For consistency, I would got for eventual since real-time tracking would mean lowest latency possible Just my reasoning
upvoted 5 times
...
alfespa17
4 years, 7 months ago
The second box should be "session". Please check the following link. You can't enable multi region writes with strong consistency. https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels#strong-consistency-and-multiple-write-regions
upvoted 2 times
someoneNoWhere
4 years, 6 months ago
Yes you can enable multiple write regions to any consistency level. However, the differences are in the impact in case of failover - recover time and recover point. For strong consistency in multiple write region, in case of a failover, you have a recovery time maximum of 240 minutos and the period of updates that you might afford to lose goes up to 1 week (RPO)... So the correct answer is still the Strong.
upvoted 1 times
someoneNoWhere
4 years, 6 months ago
correct answer is eventual. However, the rest I've written is correct.
upvoted 4 times
...
dumpsm42
4 years, 5 months ago
hi, no. telemetry data happens at real time and it represents several events sent at the same time to be processed so you must have a low level consistency here so that the throughput can be higher. eventual regards
upvoted 2 times
...
jeanpaulh
4 years, 3 months ago
Strong consistency level DOES NOT support multi-write enable. I just tried it in my Cosmos DB Account. You would get the following error: Update Default Consistency Accounts configured with default consistency level as 'Strong' cannot be enabled for multiple write locations(i.e. EnableMultipleWriteLocations=true). Consider relaxing default consistency level of the account to enable multiple write locations. ActivityId: ade4c368-bf45-43c0-ae45-095f71c0e051, Microsoft.Azure.Documents.Common/2.11.0
upvoted 2 times
...
...
...
hart232
4 years, 8 months ago
Requirements says "The data must be written to the Azure datacentre closest to each race and must converge in the least amount of time." So answer is Session as Eventual takes long time to converge and Strong will consume more RUs.
upvoted 4 times
...
sandGrain
4 years, 8 months ago
MongoDB & Eventual
upvoted 7 times
...
avix
4 years, 10 months ago
Answer should be MongoDB for the fist and eventual consistency for the second.
upvoted 11 times
...
Ard
4 years, 11 months ago
"native to azure" is vague ( vs native support). If Mongo isn't native, than the preferred choice for a new development should be CORE (sql)
upvoted 5 times
...
Luke97
5 years ago
Not sure about the 2nd box. Strong consistency is taking least amount of time to converge, however it take double RU/s than Session. And one of the requirement is "minimize the RU/s cost". Session is guaranteed to honor the consistent-prefix, monotonic reads, monotonic writes, read-your-writes, and write-follows-reads guarantees. And out-side of session (for a different region, single master account) would be Consistent Prefix, which is also guarantees that read never see out-of-order writes.
upvoted 6 times
hart232
4 years, 8 months ago
Strong consistency takes more RUs
upvoted 1 times
...
someoneNoWhere
4 years, 6 months ago
You have always other ways to minimize RU/s cost like elastic pools, azure query performance insights, automatic tuning, etc. But not the consistency of it in the least amount of time for other regions. Having said that, the correct option should be Strong.
upvoted 1 times
someoneNoWhere
4 years, 6 months ago
Sorry, can't remove the answer above. Eventual would in fact be the correct option.
upvoted 1 times
...
...
...
[Removed]
5 years, 1 month ago
The data should be written to nearest Azure Location. This implies the enable of multi-writes which disables the Strong consistency. Therefore, bounded staleness consistency is the highest (in terms of fast converge) which can be applied in this case.
upvoted 4 times
...
epgd
5 years, 4 months ago
And this API is native toAzure too. "Azure Cosmos DB provides native support for wire protocol-compatible APIs for popular databases. These include MongoDB, Apache Cassandra, Gremlin, and Azure Table storage."
upvoted 4 times
OnlyPraveen
4 years, 7 months ago
Yes same mentioned mutiple times here: https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-introduction
upvoted 1 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 ...