Exam DP-420 topic 1 question 5 discussion

Actual exam question from Microsoft's DP-420

Question #: 5
Topic #: 1

HOTSPOT -
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.

The orderId property is used as the partition key.
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

Suggested Answer:

Box 1: Yes -
Records with different OrderIDs will match.

Box 2: Yes -
Records with different OrderIDs will match.

Box 3: No -
Only records with one specific OrderId will match

by lakime at April 25, 2022, 12:36 p.m.

Comments

Submit Cancel

muks1003

Highly Voted 2 years, 6 months ago

The given answers are correct, OrderId is the partition key and any query not involving the OrderId will be considered as Cross Partition (Or Fan-out) Query.

upvoted 20 times

...

[Removed]

Most Recent 9 months, 2 weeks ago

the given answer is correct Y-Y-N

upvoted 2 times

...

azuredemo2022three

1 year, 6 months ago

1. SELECT * FROM c WHERE c.orderDate = "2019-05-03" Yes, this query will run as a cross-partition query. Since the query does not include the partition key (orderId), it needs to scan all partitions in the container to find matching documents. 2. SELECT * FROM c WHERE c.customerId = "5425" No, this query will not run as a cross-partition query. The query includes the partition key (orderId) in the WHERE clause, allowing it to be routed to the specific partition containing documents for the given customerId. 3.SELECT * FROM c WHERE c.orderDate = "2019-05-03" and c.orderId = "5515d96e-5860-4fa0-a70c-c965e3ffeb49" No, this query will not run as a cross-partition query. The query includes the partition key (orderId) in the WHERE clause, allowing it to be routed to the specific partition containing the document with the matching orderId and orderDate. So, to summarize: Yes, it will run as a cross-partition query. No, it will not run as a cross-partition query. No, it will not run as a cross-partition query.

upvoted 1 times

azuredemo2022three

1 year, 6 months ago

My Mistake Answer is Yes, it will run as a cross-partition query. Yes, it will not run as a cross-partition query. No, it will not run as a cross-partition query.

upvoted 2 times

AndrySistiawan

1 year, 4 months ago

for number 2, why answer is Yes? if it will not run as a cross-partition query. t thins if "it will not run as a cross-partition query" answer is NO,

upvoted 1 times

...

Torent2005

2 years, 2 months ago

NNY Cross-pratition query means that your query hits only neccessary data from logical partition based on partition key (query has filter eg. c.orderId). If not scan whole data. IF "orderId" is partition key then first two queries are not cross-partition queries. https://learn.microsoft.com/en-us/azure/cosmos-db/sql/how-to-query-container

upvoted 2 times

codingdown

2 years ago

noooope at all. cross partition means it will scan more than 1 partition, easy as that

upvoted 4 times

...

lakime

2 years, 7 months ago

As orderid is partition key, And if we will assume that this orderid will appear in different dates and in different customers - then those answers are correct

upvoted 4 times

...