MongoDB Exam C100DBA Topic 1 Question 74 Discussion

Actual exam question for MongoDB's C100DBA exam

Question #: 74
Topic #: 1

[All C100DBA Questions]

You have the following index on the toys collection:

{

"manufacturer" : 1,

"name" : 1,

"date" : -1

}

Which of the following is able to use the index for the query? Check all that apply.

Adb.toys.find( { name : 'Big Rig Truck', date : '2013-02-01', manufacturer : 'Tanko'

Bdb.toys.find( { manufacturer : 'Matteo', name : 'Barbara', date : '2014-07-02' } )

Cdb.toys.find( { date : '2015-03-01', manufacturer : 'Loggo', name : 'Brick Set' } )

Show Suggested Answer

Suggested Answer: A

by Moon at Aug 30, 2023, 11:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Hmm, I'm not sure if the index can be used for the query in option B. The order of the fields in the index doesn't match the order in the query.

upvoted 0 times

...

3 days ago

I'm not sure, but I think option B might also be able to use the index since it includes all the fields in the index.

upvoted 0 times

...

4 days ago

The index can definitely be used for the query in option A. The order of the index fields matches the order of the query fields.

upvoted 0 times

...

5 days ago

I agree with Nickolas, option A is the only one that can use the index effectively.

upvoted 0 times

...

6 days ago

I think option A can use the index because it matches the order of fields in the index.

upvoted 0 times

...