MENU
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.
Suggested Answer: A
Get Premium C100DBA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
EM
Emogene
11 months ago
Not sure about C, seems off to me.
CE
Ceola
11 months ago
Totally agree, A is the only one that works!
DA
Darrin
11 months ago
Wait, does C really use the index?
TE
Tequila
11 months ago
B won't use the index, wrong order.
AR
Ardella
12 months ago
A can use the index!
BR
Britt
12 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.
DE
Denny
12 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.
SH
Sherron
1 year 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.
VA
Valentin
1 year ago
I think the index can be used if the fields match the order, but I'm not sure about the descending date part.
TA
Tammara
1 year ago
Based on the index, I think queries A and C can use it, but I'm not certain about query B.
JO
Jose
1 year 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.
CA
Carry
1 year ago
The index has fields in the order "manufacturer", "name", and "date", so I believe all three queries can use the index.
BR
Brock
1 year ago
This looks straightforward, I think I can use the index to solve this query.
LI
Ligia
1 year ago
Hmm, I'm not sure which of these queries can use the index. I'll need to think through the index structure carefully.
KE
Kenny
1 year 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.
YU
Yun
1 year 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.
TI
Tien
1 year 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.
LE
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.
YO
Youlanda
1 year ago
I bet the MongoDB engineers were having a blast coming up with those toy company names like 'Tanko' and 'Loggo'!
KE
Kerrie
1 year ago
C) Yes, C can use the index for the query.
FE
Felix
1 year ago
B) No, only A can use the index for the query.
AU
Audra
1 year ago
C) Correct, A and C are able to use the index for the query.
KE
Keena
1 year ago
A) Yes, A and B can use the index for the query.
KA
Kathrine
1 year ago
B) No, B cannot use the index for the query.
AN
Annette
1 year ago
A) Yes, A and C can use the index for the query.
BR
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.
BR
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.
LA
Lajuana
1 year ago
B) db.toys.find( { manufacturer : \'Matteo\', name : \'Barbara\', date : \'2014-07-02\' } )
YU
Yuki
1 year ago
A) db.toys.find( { name : \'Big Rig Truck\', date : \'2013-02-01\', manufacturer : \'Tanko\' )
GO
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.
MA
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.
AL
Alita
2 years ago
I agree with Nickolas, option A is the only one that can use the index effectively.
NI
Nickolas
2 years ago
I think option A can use the index because it matches the order of fields in the index.