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 12 Discussion

Below is a sample document in a given collection test.{ a : 5, b : 3, c: 2, d : 1 >Given a compound index { a: 1, b:l, c:l, d:l}, Which of the below query will not use in-memory sorting? Selectall valid.
A) db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } ) and D) db.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )
B) db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
C) db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )

MongoDB C100DBA Exam - Topic 1 Question 12 Discussion

Actual exam question for MongoDB's C100DBA exam
Question #: 12
Topic #: 1
[All C100DBA Questions]

Below is a sample document in a given collection test.

{ a : 5, b : 3, c: 2, d : 1 >

Given a compound index { a: 1, b:l, c:l, d:l}, Which of the below query will not use in-memory sorting? Select

all valid.

Show Suggested Answer Hide Answer
Suggested Answer: A, D

by Teddy at May 05, 2022, 05:59 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
Sina
8 months ago
Just to clarify, only B is valid here.
upvoted 0 times
...
Yuette
9 months ago
I thought D would use in-memory too, but I guess not!
upvoted 0 times
...
Leeann
9 months ago
Wait, C should also work without in-memory sorting, right?
upvoted 0 times
...
Janna
9 months ago
Totally agree, B is the right choice!
upvoted 0 times
...
Vashti
9 months ago
A uses in-memory sorting, B doesn't.
upvoted 0 times
...
Margot
9 months ago
I think option D might require in-memory sorting since it only sorts by 'c' after filtering by 'a' and 'b'. I need to double-check that though.
upvoted 0 times
...
Dorthy
9 months ago
I think queries that sort on the indexed fields in the same order as the index should avoid in-memory sorting. So maybe B is a good choice?
upvoted 0 times
...
Gayla
9 months ago
I remember we discussed how compound indexes can affect sorting, but I'm not sure which queries would avoid in-memory sorting.
upvoted 0 times
...
Frankie
9 months ago
I feel like we practiced a similar question, and I recall that if the sort matches the index, it won't need in-memory sorting. But I'm confused about option C.
upvoted 0 times
...
Maile
9 months ago
Ugh, I'm not sure about this one. I don't have much experience with storage hardware, so I'll have to guess based on the options provided.
upvoted 0 times
...
Alise
9 months ago
Hmm, this looks like a tricky one. I'll need to think carefully about the deployment types that are specifically mentioned for Cisco Jabber 12.6 on a Windows PC.
upvoted 0 times
...
Barney
9 months ago
Okay, I've got this. Static positioning places an element at specific coordinates relative to the page or its container, so "No change is needed" is the correct answer.
upvoted 0 times
...

Save Cancel