exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 1 question 11 discussion

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

HOTSPOT -
You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users' posts.
You need to store the data shown in the following table.

The application has the following characteristics:
✑ Users can submit an unlimited number of posts.
✑ The average number of posts submitted by a user will be more than 1,000.
✑ Posts can have an unlimited number of comments from different users.
✑ The average number of comments per post will be 100, but many posts will exceed 1,000 comments.
✑ Users will be limited to having a maximum of 20 interests.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
Non-relational data increases write costs, but can decrease read costs.

Box 2: Yes -
Non-relational data increases write costs, but can decrease read costs.

Box 3: No -
Non-relational data increases write costs, but can decrease read costs.

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
avijitd
Highly Voted 2 years, 11 months ago
correct
upvoted 11 times
...
praticewizards
Most Recent 2 days, 7 hours ago
correct: Y Y N
upvoted 1 times
...
hnkira
7 months, 1 week ago
should be YYY, as the size of the document increases cost might increase, 1RU is the cost to read a document of 1KB, though with 20 interests stored as an array in the document we might not add more than 1KB but there is no constraint mentioned about the interst property (is it an object, text, what size is the limit)
upvoted 1 times
...
codingdown
2 years, 6 months ago
i don't see why the write cost should increase, the read cost does
upvoted 2 times
susejzepol
2 years, 6 months ago
i think could be because the operation need to do and upsert instead of an insert.
upvoted 3 times
...
...
muks1003
3 years ago
Correct Answer Yes, Yes, No
upvoted 3 times
...
shachar_ash
3 years ago
Correct
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 ...