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 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.

Show Suggested Answer Hide Answer
Suggested Answer: A

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

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Lenna
27 days ago
Well, it's a good thing we have this handy index to help us find our toys. I can't imagine trying to sort through all those 'Big Rig Trucks' and 'Brick Sets' without it.
upvoted 0 times
...
Youlanda
1 months ago
I bet the MongoDB engineers were having a blast coming up with those toy company names like 'Tanko' and 'Loggo'!
upvoted 0 times
Keena
9 days ago
A) Yes, A and B can use the index for the query.
upvoted 0 times
...
Kathrine
21 days ago
B) No, B cannot use the index for the query.
upvoted 0 times
...
Annette
22 days ago
A) Yes, A and C can use the index for the query.
upvoted 0 times
...
...
Bronwyn
1 months ago
The index can be used for the query in option C. The order of the fields in the index matches the order in the query.
upvoted 0 times
...
Brandon
2 months 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
Lajuana
16 days ago
B) db.toys.find( { manufacturer : \'Matteo\', name : \'Barbara\', date : \'2014-07-02\' } )
upvoted 0 times
...
Yuki
18 days ago
A) db.toys.find( { name : \'Big Rig Truck\', date : \'2013-02-01\', manufacturer : \'Tanko\' )
upvoted 0 times
...
...
Golda
2 months 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
...
Marica
2 months 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
...
Alita
2 months ago
I agree with Nickolas, option A is the only one that can use the index effectively.
upvoted 0 times
...
Nickolas
2 months ago
I think option A can use the index because it matches the order of fields in the index.
upvoted 0 times
...

Save Cancel