C100DEV Exam Dumps | We have a movies collection with the following document structure: { _id: ObjectId("573a1390f29313caabcd6223"),

<< Prev Question Next Question >>

Question 6/87

We have a movies collection with the following document structure: { _id: ObjectId("573a1390f29313caabcd6223"), genres: [ 'Comedy', 'Drama', 'Family' ], title: 'The Poor Little Rich Girl', released: ISODate("1917-03-05T00:00:00.000Z"), year: 1917, imdb: { rating: 6.9, votes: 884, id: 8443 } }, { _id: ObjectId("573a13e3f29313caabdc08a4"), genres: [ 'Horror', 'Thriller' ], title: 'Mary Loss of Soul', year: 2014, imdb: { rating: '', votes: '', id: 2904798 } } We need to use Aggregation Framework to calculate the following aggregates: -> average imdb rating -> minimum imdb rating -> maximum imdb rating Expected output: [ { _id: null, avg_rating: 6.6934040649367255, min_rating: 1.6, max_rating: 9.6 } ] Please note that some documents have "" (empty string) for the field "imdb.rating". Exclude these documents before aggregation. Which pipeline should you use?

A. [{ $match: { "imdb.rating": { $ne: "" } } }, { $group: { _id: null, avg_rating: { $avg: "imdb.rating" }, min_rating: { $min: "imdb.rating" }, max_rating: { $max: "imdb.rating" } } }]

B. [{ $match: { "imdb.rating": { $ne: "" } } }, { $group: { _id: null, avg_rating: { $avg: "$imdb.rating" }, min_rating: { $min: "$imdb.rating" }, max_rating: { $max: "$imdb.rating" } } }]

C. [{ $group: { _id: null, avg_rating: { $avg: "$imdb.rating" }, min_rating: { $min: "$imdb.rating" }, max_rating: { $max: "$imdb.rating" } } }]

D. [{ $match: { "imdb.rating": { $ne: "" } } }, { $group: { _id: null, avg_rating: { avg: "$imdb.rating" }, min_rating: { min: "$imdb.rating" }, max_rating: { max: "$imdb.rating" } } }]

Question 6/87

LEAVE A REPLY

Download PDF File