MENU
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.
Suggested Answer: A, D
Get Premium C100DBA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
SI
Sina
11 months ago
Just to clarify, only B is valid here.
YU
Yuette
12 months ago
I thought D would use in-memory too, but I guess not!
LE
Leeann
12 months ago
Wait, C should also work without in-memory sorting, right?
JA
Janna
12 months ago
Totally agree, B is the right choice!
VA
Vashti
1 year ago
A uses in-memory sorting, B doesn't.
MA
Margot
1 year 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.
DO
Dorthy
1 year 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?
GA
Gayla
1 year ago
I remember we discussed how compound indexes can affect sorting, but I'm not sure which queries would avoid in-memory sorting.
FR
Frankie
1 year 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.
MA
Maile
1 year 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.
AL
Alise
1 year 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.
BA
Barney
1 year 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.