Exam AZ-303 topic 1 question 68 discussion

Actual exam question from Microsoft's AZ-303

Question #: 68
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Cosmos DB database that contains a container named Container1. The partition key for Container1 is set to /day. Container1 contains the items shown in the following table.

You need to programmatically query Azure Cosmos DB and retrieve Item1 and Item2 only.
Solution: You run the following query.

SELECT day -
WHERE value = "10"
You set the EnableCrossPartitionQuery property to False.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
Returns Item1 only as EnableCrossPartitionQuery property to False. If EnableCrossPartitionQuery property is set to true, it will return Item1 and Item3.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-where

by xaccan at Jan. 4, 2021, 5:28 p.m.

Comments

Submit Cancel

syu31svc

3 years, 9 months ago

Answer is No for sure

upvoted 3 times

...

AravindITGuy

3 years, 11 months ago

Took exam today passed this morning was on there 6/21/2021

upvoted 3 times

...

nfett

3 years, 11 months ago

answer is correct.

upvoted 4 times

...

pkr0895

4 years ago

EnableCrossPartitionQuery is automatically set based on the query. code: https://github.com/Azure/azure-cosmos-dotnet-v3/blob/e534de251bdadafd1adb960da83c15d463486a66/Microsoft.Azure.Cosmos/src/RequestOptions/QueryRequestOptions.cs#L173-L177 doc:https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-query-container

upvoted 2 times

...