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?
Submit