C100DBA Exam Dumps : MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4)

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

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

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

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

255 K

1 MB

16 MB

2 MB

Providing these parameters in any order does not impact the performance

$sort moves before $match

MongoDB does not do any movements by default and will use the order provided

$match moves before $sort