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.

Adb.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )

Bdb.test.find( { a: 5, b: 3 } ).sort( { a: 1} )

Cdb.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )

Ddb.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )

Show Suggested 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:

Submit Cancel

Sina

4 months ago

Just to clarify, only B is valid here.

upvoted 0 times

...

Yuette

4 months ago

I thought D would use in-memory too, but I guess not!

upvoted 0 times

...

Leeann

4 months ago

Wait, C should also work without in-memory sorting, right?

upvoted 0 times

...

Janna

4 months ago

Totally agree, B is the right choice!

upvoted 0 times

...

Vashti

5 months ago

A uses in-memory sorting, B doesn't.

upvoted 0 times

...

Margot

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...