A user stores movie data in a collection called movies.

MongoDB C100DBA Question Answer

A user stores movie data in a collection called movies. The collection contains thousands of documents.

A sample document looks like this:

{ " title " : " Titanic " , " year " : 1997, " rating " : 8.6 }

The user runs the following query to sort movies first by year, and then by rating:

db.movies.find().sort({ " year " : 1, " rating " : -1 })

Which index would improve the query ' s performance the MOST?

db.movies.createIndex({ " year " : 1, " title " : 1, " rating " : -1 })

db.movies.createIndex({ " year " : -1, " rating " : 1 })

db.movies.createIndex({ " rating " : 1, " year " : -1 })

db.movies.createIndex({ " rating " : -1, " year " : 1 })

C100DBA PDF/Engine

Get 70% Discount on All Products, Use Coupon: "coponace"