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 1 Question 74 Discussion

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.
A) db.toys.find( { name : 'Big Rig Truck', date : '2013-02-01', manufacturer : 'Tanko'
B) db.toys.find( { manufacturer : 'Matteo', name : 'Barbara', date : '2014-07-02' } )
C) db.toys.find( { date : '2015-03-01', manufacturer : 'Loggo', name : 'Brick Set' } )

MongoDB C100DBA Exam - 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:

0/2000 characters
Submit Cancel
Emogene
8 months ago
Not sure about C, seems off to me.
upvoted 0 times
...
Ceola
8 months ago
Totally agree, A is the only one that works!
upvoted 0 times
...
Darrin
8 months ago
Wait, does C really use the index?
upvoted 0 times
...
Tequila
8 months ago
B won't use the index, wrong order.
upvoted 0 times
...
Ardella
9 months ago
A can use the index!
upvoted 0 times
...
Britt
9 months ago
I’m confused about how the descending order affects the queries. I think option C might not work because of that, but I need to double-check.
upvoted 0 times
...
Denny
9 months ago
I feel like I’ve seen similar questions before. I’m leaning towards option B being valid since it has the right fields, but I’m not completely confident.
upvoted 0 times
...
Sherron
9 months ago
I remember a practice question where the order of fields in the query mattered. I think option A might not use the index because of the date.
upvoted 0 times
...
Valentin
9 months ago
I think the index can be used if the fields match the order, but I'm not sure about the descending date part.
upvoted 0 times
...
Tammara
9 months ago
Based on the index, I think queries A and C can use it, but I'm not certain about query B.
upvoted 0 times
...
Jose
9 months ago
I'm a bit confused about how the index order affects which queries can use it. I'll need to review that before answering.
upvoted 0 times
...
Carry
9 months ago
The index has fields in the order "manufacturer", "name", and "date", so I believe all three queries can use the index.
upvoted 0 times
...
Brock
9 months ago
This looks straightforward, I think I can use the index to solve this query.
upvoted 0 times
...
Ligia
9 months ago
Hmm, I'm not sure which of these queries can use the index. I'll need to think through the index structure carefully.
upvoted 0 times
...
Kenny
9 months ago
I think the answer is A. The question specifically mentions replacing the Supervisor Cluster API endpoint certificate, and the certificate-manager CLI utility seems like the right tool for that.
upvoted 0 times
...
Yun
9 months ago
I've got this! The correct answers are A and C - switching from net value-based to net weight-based freights, and manually overwriting a price condition in a document.
upvoted 0 times
...
Tien
10 months ago
Hmm, I'm a bit unsure about this one. The passage talks about laws and regulations, but I'm not sure which document it's most likely from. I'll have to think it through carefully.
upvoted 0 times
...
Lenna
1 year 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 year ago
I bet the MongoDB engineers were having a blast coming up with those toy company names like 'Tanko' and 'Loggo'!
upvoted 0 times
Kerrie
1 year ago
C) Yes, C can use the index for the query.
upvoted 0 times
...
Felix
1 year ago
B) No, only A can use the index for the query.
upvoted 0 times
...
Audra
1 year ago
C) Correct, A and C are able to use the index for the query.
upvoted 0 times
...
Keena
1 year ago
A) Yes, A and B can use the index for the query.
upvoted 0 times
...
Kathrine
1 year ago
B) No, B cannot use the index for the query.
upvoted 0 times
...
Annette
1 year ago
A) Yes, A and C can use the index for the query.
upvoted 0 times
...
...
Bronwyn
1 year 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
1 year 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
1 year ago
B) db.toys.find( { manufacturer : \'Matteo\', name : \'Barbara\', date : \'2014-07-02\' } )
upvoted 0 times
...
Yuki
1 year ago
A) db.toys.find( { name : \'Big Rig Truck\', date : \'2013-02-01\', manufacturer : \'Tanko\' )
upvoted 0 times
...
...
Golda
1 year 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
1 year 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
1 year ago
I agree with Nickolas, option A is the only one that can use the index effectively.
upvoted 0 times
...
Nickolas
1 year ago
I think option A can use the index because it matches the order of fields in the index.
upvoted 0 times
...

Save Cancel