Discuss MongoDB C100DBA Exam Topic 1 Question 11

Consider that the posts collection contains an array called ratings which contains ratings given to the post by various users in the following format:

Which of the following query will return all the documents where the ratings array contains elements that in some combination satisfy the query conditions?

Adb.inventory.find( { ratings: { $elemMatch: { $gte: 3, $lte: 6 } } } )

Bdb.inventory.find( { ratings: { $elemMatch: { $gt: 3, $lt: 6 }

Cdb.inventory.find( { ratings: { ratings.$: { $gt: 5, $lt: 9 } } } )

Ddb.inventory.find( { ratings: { ratings: { $gt: 5, $lt: 9 } } } )

Suggested Answer: D

Get Premium C100DBA Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Mauricio 11 months ago

I’m surprised there’s no option for exact matches!

Kristeen 12 months ago

Wait, are we sure A is the only correct one?

Elfriede 12 months ago

C and D don’t seem right, they’re missing $elemMatch.

Paris 12 months ago

I think B is better, it’s more precise with the range.

Shayne 1 year ago

A looks good, it uses $elemMatch correctly.

Laurel 1 year ago

I’m confused about options C and D; they seem incorrect since they don’t use $elemMatch properly.

Latia 1 year ago

I remember we did a similar question where $elemMatch was key to finding specific ratings. That makes me lean towards option A again.

Lawana 1 year ago

I think option A looks familiar because we practiced using $elemMatch for conditions on arrays.

Tamar 1 year ago

I'm not entirely sure, but I feel like option B might be too restrictive with the $gt and $lt operators.

Barrett 1 year ago

I'm leaning towards Job Families as the answer. Since the question mentions "defining 50 different jobs," that suggests there may be some higher-level grouping or categorization needed to link them to the Projects jobs.

Arlyne 1 year ago

Hmm, I'm not sure about this one. I'm thinking it might be C - Configure restrictions inside the policy section if VMware Cloud Director, but I'm not 100% confident.

Krissy 1 year ago

I feel pretty confident about this one. The question is clearly testing our knowledge of best practices in corporate governance. I'll methodically evaluate each statement against the principles we've covered in class.

MongoDB C100DBA Exam - Topic 1 Question 11 Discussion