Valid C100DEV Dumps shared by ExamDiscuss.com for Helping Passing C100DEV Exam! ExamDiscuss.com now offer the newest C100DEV exam dumps, the ExamDiscuss.com C100DEV exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com C100DEV dumps with Test Engine here:
You have the following index in a movies collection: { "title": 1, "imdb.rating": -1, "imdb.votes": -1, "type": 1 } Can the following query use the given index for both filtering and sorting? db.movies.find( { "title": "James Bond", "imdb.rating": { "$gt": 8} } ).sort( { "imdb.rating": 1 } )
Correct Answer: A
Yes, although this query does not use equality in the "imdb.rating" field of the index prefix, it does use the same field for sorting. https://docs.mongodb.com/manual/indexes/