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

Exam DP-420 All Questions

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

Exam DP-420 topic 5 question 16 discussion

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

HOTSPOT -
You have an Azure Cosmos DB Core (SQL) API account named account1.
In account1, you run the following query in a container that contains 100GB of data.

You view the following metrics while performing the query.

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: No -
Each physical partition should have its own index, but since no index is used, the query is not cross-partition.

Box 2: No -
Index utilization is 0% and Index Look up time is also zero.

Box 3: Yes -
A partition key index will be created, and the query will perform across the partitions.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-query-container
by TRUESON at May 3, 2023, 8:12 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
[Removed]
Highly Voted 1 year, 2 months ago
YNY "This query's filter uses the system function UPPER, which isn't served from the index." https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/query-metrics-performance#scan-queries-commonly-slow-and-expensive
upvoted 7 times
[Removed]
1 year, 2 months ago
YNN < correction
upvoted 7 times
[Removed]
6 months, 2 weeks ago
This is the correct answer
upvoted 2 times
...
...
...
WimTS
Most Recent 3 weeks, 2 days ago
YNN When you apply the LOWER() function to c.categoryid, the query engine cannot determine the exact value of the partition key without evaluating the function. As a result, Cosmos DB cannot route the query to a specific partition and must perform a cross-partition query, which can be less efficient.
upvoted 1 times
...
matejka
1 month, 2 weeks ago
I would say YNY
upvoted 1 times
...
bcd_6
11 months, 4 weeks ago
how do we know if it's cross partition query or not?
upvoted 1 times
8fe085a
5 months ago
The third question ask waht happens when the container is recreated with the customerid as partition key, so it is not currently the partition key, therfore the query is cross partition.
upvoted 2 times
...
...
EvanG
1 year, 5 months ago
using a function like Lower on the left side of equality won't use the index in relational dbs. Not sure about Cosmosdb
upvoted 1 times
...
TRUESON
1 year, 6 months ago
To correctly answer the question one would have to know the partionkey https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-query-container
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago