Certification question

MongoDB University Certification Exams
1

Hi,

I suppose an issue with this question, or, i don’t understand the answer:

question_8
question_81191×1236 122 KB

For me, it seems the request was covered by the index.

I make this test on my local using the following index:
{first_name: 1, birthday:1}
image

And the result is:

test_question_8
test_question_82202×435 47.3 KB
.

For my test, this is an example of documents of my DB:
schema_question_8

Someone can confirm me the issue or explain me the result?
Thank you :slight_smile:

2

Hi @Yann_05178,

At a quick glance it looks tricky, but if you look a bit closer you will notice that it’s returning/projecting user.description which is not part of the index and as a result it will not be covered.

:slight_smile:

3

I am not sure, the request is performed on the field “user” (which is in the index), then the sort on the date (second key of the index) then we project only the field “user”… So the description should not impact the request… :confused: Or i miss something…

4

image
image751×297 84.4 KB

So user is an object that contains a sub-document. If you specify user:1 in a projection, it will include all the fields. In order for the query to covered, you must specify login and/or date because those are the only two sub-fields that are part of the index, description is not. Makes sense? :slight_smile:

5

My bad… Yes i understand, thank you :slight_smile:

6

:slightly_smiling_face: :+1:

7

so, is that the right answer ?
“MongoDB will need to do a table/collection scan to find matching documents”

8

No. Have you read the thread in its entirety?

9

how it will use the index(scan) to return the “user.description” field, if this field is not in the index?

10

As per the answer, myIndex is used here:
image

11

so, the index will be used to filter “user.login”, not to return the fields of the array “user” that is it?

12

That’s right. It will be used to find the documents where user.login begins with “ir”, but it won’t be used for sorting or projecting.

13

thanks for you pattience, i didn’t know the mongodb could use index to do some parts of the process and others not, i will read more about.

14

Also read more on Covered Queries. And I would suggest that you register for the MondoDB courses, some of them cover indexes in some detail.

1 Like
15

thanks again, i will do that

16

Regarding this, why exactly isn’t the optimized sort query wrong. I expected it to be able to sort on the index?

17

You meant why “is”? It can’t utilise the index on the sort because the query predicate isn’t an equality condition.

1 Like
18

ohh, I’m dumb. You get so deep into keys and orders you forget the simple things. Got it now.
And yes I meant why is that answer wrong. (I obviously got that wrong). But I get it now. If there was equality on the user.login then the query would have been sort optimized I assume

19

That’s right!

But for the exam, bear in mind that there is another rule… this query will use the sort index:

find( {"user.login": /^ir.*/}, <project>).sort("user.login": 1)

20

Because of an overlapping prefix?