Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

MongoDB C100DBA Exam - Topic 7 Question 131 Discussion

Consider the following document from the products collection:What does the following query using $elemMatch return? db.products.find( { product_code: "345678" }, { variations: { $elemMatch: { size: ^L^ } } } )
B) Returns the document but with only one element in the variations array (corresponding to size L)
A) Returns the complete document but retrieves only the size field from the array
C) Returns the complete document since MongoDB does not support partial array retrieval
D) Returns the complete document but retrieves only the size field from the array and also with only one element in the variations array (corresponding to size L)

MongoDB C100DBA Exam - Topic 7 Question 131 Discussion

Actual exam question for MongoDB's C100DBA exam
Question #: 131
Topic #: 7
[All C100DBA Questions]

Consider the following document from the products collection:

What does the following query using $elemMatch return? db.products.find( { product_code: "345678" }, { variations: { $elemMatch: { size: ^L^ } } } )

Show Suggested Answer Hide Answer
Suggested Answer: B

by Diane at Jun 29, 2026, 08:48 PM

Limited Time Offer

25%

Off

Get Premium C100DBA Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Walton
3 days ago
It matches size L, so only that variation shows up.
upvoted 0 times
...
Jackie
8 days ago
Why B?
upvoted 0 times
...
Walton
14 days ago
I think it's B.
upvoted 0 times
...
Denae
19 days ago
A is misleading, it doesn't just retrieve the size field.
upvoted 0 times
...
Carry
24 days ago
C is incorrect, it can return specific elements!
upvoted 0 times
...
Terrilyn
29 days ago
Wait, does MongoDB really not support partial array retrieval?
upvoted 0 times
...
Bobbye
1 month ago
Definitely B! Makes the most sense.
upvoted 0 times
...
Rebbeca
1 month ago
I think it returns the document with just one variation for size L.
upvoted 0 times
...
Audrie
1 month ago
I feel like option D might be the right choice since it mentions retrieving the size field and only one element, which seems to align with how $elemMatch works.
upvoted 0 times
...
Becky
2 months ago
I’m a bit confused about whether MongoDB allows partial retrieval of arrays. I thought it did, but I could be wrong.
upvoted 0 times
...
Claribel
2 months ago
I remember practicing a similar question where $elemMatch was used, and it returned only the matching elements from the array. So, I’m leaning towards option B.
upvoted 0 times
...
Dorathy
2 months ago
I think the query is supposed to return the document with just the matching variation, but I'm not entirely sure if it includes the whole document or just part of it.
upvoted 0 times
...

Save Cancel