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

Exam AZ-203 All Questions

View all questions & answers for the AZ-203 exam
Go to Exam

Exam AZ-203 topic 3 question 14 discussion

Actual exam question from Microsoft's AZ-203
Question #: 14
Topic #: 3
[All AZ-203 Questions]

HOTSPOT -
You have an app that stores player scores for an online game. The app stores data in Azure tables using a class named PlayerScore as the table entity. The table is populated with 100,000 records.
You are reviewing the following section of code that is intended to retrieve 20 records where the player score exceeds 15,000. (Line numbers are included for reference only.)

You have the following code. (Line numbers are included for reference only.)

You store customer information in an Azure Cosmos database. The following data already exists in the database:

You develop the following code. (Line numbers are included for reference only.)

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: Explanation
Box 1: No -

Box 2: Yes -
The TableQuery.Take method defines the upper bound for the number of entities the query returns.
Example:
query.Take(10);

Box 3: Yes -

Box 4: Yes -
References:
https://www.vkinfotek.com/azureqa/how-do-i-query-azure-table-storage-using-tablequery-class.html
by gclopes at Feb. 29, 2020, 3:36 p.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
Daltonic75
Highly Voted 5 years, 2 months ago
https://www.itexams.com/static/img/exams/Microsoft-AZ-203-1.0/xmlfile-177_1.png
upvoted 28 times
chaudh
4 years, 10 months ago
https://vceguide.com/wp-content/uploads/2020/05/Microsoft-AZ-203-date-05-08-2020_Page_143_Image_0001.jpg
upvoted 19 times
...
SilverSea
5 years, 2 months ago
Daltonic75, I don't know who you are. But clearly, examtopics should pay you for every subscriptions they receive as you did 50% of their work. Thank you.
upvoted 68 times
bhushan_786
4 years, 5 months ago
The link provided by him is not relevant here :) It is meant for other question.
upvoted 6 times
...
altafpatel1984
3 years, 5 months ago
but this time he did wrong job ! posted different image.
upvoted 1 times
...
...
...
Ric0720
Highly Voted 4 years, 9 months ago
No,Yes,No,Yes
upvoted 15 times
...
Juanlu
Most Recent 4 years, 3 months ago
NO YES. YES. All record are retuned to the client. The máximum value are 1000. If so, tokenccontinuation returned and we can use: ExecuteQuerySegmentedAsync YES. By default PartitionKey and RowKey are already included by default in the select clause. https://www.examtopics.com/discussions/microsoft/view/16363-exam-az-203-topic-24-question-13-discussion/
upvoted 1 times
...
Juanlu
4 years, 3 months ago
In my opinion, all answer are correct as the solution mention, so: YES, NO, NO, NO !
upvoted 1 times
...
NPaul_92
4 years, 7 months ago
https://vceguide.com/where-the-player-score-exceeds-15000-line-numbers-are-included-for-reference-only/
upvoted 2 times
...
nikos2001
4 years, 10 months ago
Third box should be NO. The client will get not all records, but those fitting the query filter.
upvoted 12 times
godsbane
4 years, 10 months ago
Box 3 is No. If .Take() is not specified, a maximum of 1000 records are returned to the client. There is no way all records are returned to the client, what if we have 20 mil records? Reference: https://docs.microsoft.com/bs-latn-ba/java/api/com.microsoft.azure.storage.table.tablequery.take?view=azure-java-legacy
upvoted 7 times
...
...
Praveen24by7
4 years, 11 months ago
The code queries the Azure table and retrieves the TimePlayed property from the table - No The code will display a maximum of twenty records - Yes All records will be sent to the client. The client will display records for scores greater than or equal to 15,000. - Yes The scoreItem.Key property of the KeyValuePairs that ExecuteQuery returns will contain a value for PlayerID. - Yes
upvoted 4 times
pranay
4 years, 10 months ago
Third answer should be NO
upvoted 5 times
Chilred
4 years, 5 months ago
Then explain why
upvoted 1 times
...
...
...
saeza100
4 years, 11 months ago
Box4 should be "No" , we select just "Score" with "Query"
upvoted 1 times
pranay
4 years, 10 months ago
PlayerId is a rowKey so it will be returned anyhow. You don't need to mention rowKey and PartitionKey.
upvoted 1 times
...
Juanlu
4 years, 3 months ago
yes, but as I know, Partitionkey and Rowkey are also included by default, so de answer should be YES.
upvoted 1 times
...
...
lau13
4 years, 11 months ago
options [Yes|No]The code queries the Azure table and retrieves the TimePlayed property from the table [Yes|No]The code will display a maximum of twenty records [Yes|No]All records will be sent to the client. The client will display records for scores greater than or equal to 15,000. [Yes|No]The scoreItem.Key property of the KeyValuePairs that ExecuteQuery returns will contain a value for PlayerID.
upvoted 6 times
...
realbart
5 years, 1 month ago
Not all records, but only 20 records will not be sent to the client but written to the console
upvoted 4 times
...
sagnikmukh
5 years, 2 months ago
Box 3: should be false, please suggest
upvoted 8 times
VMCoder
5 years, 2 months ago
Why do you think so? I think it is correct.
upvoted 1 times
LEOPOLD
5 years, 1 month ago
Same conclusion. I thought it would be deferred execution and iteration over the query with execute it so you have a query with .take 20 in it and when iterating you dont get all records sent to the client. (I sure hope thats what happens. Imagine that you had 2000000000 records in that DB all sent to client :D)
upvoted 5 times
...
khrystyna
5 years, 1 month ago
It can be because of method order: Select - get all records to client Where - in memory filtering on client side Take - return just 20 records
upvoted 2 times
...
...
Ummara
4 years, 9 months ago
the partition key is the game id, and select is not on the partition key. In such a case all records are retrieved, called Table Scan, and therefore Client will filter records from the data fetched.
upvoted 2 times
...
Ummara
4 years, 9 months ago
A Table Scan does not include the PartitionKey and is very inefficient because it searches all of the partitions that make up your table in turn for any matching entities. It will perform a table scan regardless of whether or not your filter uses the RowKey. For example: $filter=LastName eq 'Jones' https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-for-query
upvoted 2 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