Given a movies collection where each document has the following structure: { _id: ObjectId("573a1390f29313caabcd60e4"), genres: [ 'Short', 'Comedy', 'Drama' ], title: 'The Immigrant', year: 1917, imdb: { rating: 7.8, votes: 4680, id: 8133 }, countries: [ 'USA' ] } This time we are using the Aggregation Framework to search our database. Which of the following queries will find all movies with a rating greater than 8?

• A.db.movies.aggregate([ { $match: { imdb.rating: { $gt: 8 } } } ])
• B.db.movies.aggregate([ { $match: { "imdb.rating": { $gte: 8 } } } ])
• C.db.movies.aggregate([ { $match: { "imdb.rating": { $gt: 8 } } } ])

Comment: *

Name: *

Email: *

Verification: *

Which of the following rules (when ordering) should be followed when building query indexes?

• A.equality, range, sort
• B.equality, sort, range
• C.range, sort, equality

Comment: *

Name: *

Email: *

Verification: *

What is the best practice in using the $match operator?

• A.The later in the pipeline, the better.
• B.The earlier in the pipeline, the better. Not only because we will be using expression filters which reduce the number of documents to be processed, but also because we can use indexes.
• C.It doesn't matter when we apply $match stage.

Comment: *

Name: *

Email: *

Verification: *

Given a flights collection that is sharded on the following shard key: { "airline_id" : 1, "departure_airport" : 1 } Which of the following queries results in a targeted query?

• A.db.flights.find( { airline_id: 2946863, departure_airport: "JFK" } )
• B.db.flights.find( { departure_airport: "JFK" } )
• C.db.flights.find( { departure_airport: "JFK", airline_id: 2946863 } )
• D.db.flights.find( { airline_id: 2946863 } )

Comment: *

Name: *

Email: *

Verification: *

Given a movies collection where each document has the following structure: { _id: ObjectId('573a1390f29313caabcd60e4'), genres: [ 'Short', 'Comedy', 'Drama' ], title: 'The Immigrant', year: 1917, imdb: { rating: 7.8, votes: 4680, id: 8133 }, countries: [ 'USA' ] } Which of the following queries will find all the movies that have more votes than the year in which they were released?

• A.db.movies.find({ $expr: { $gt: ["imdb.votes", "year"] } } )
• B.db.movies.find({ $expr: { $lt: ["$imdb.votes", "$year"] } } )
• C.db.movies.find({ $expr: { $gt: ["$imdb.votes", "$year"] } } )

Comment: *

Name: *

Email: *

Verification: *