Working with Arrays in the Aggregation Pipeline: Test your skills

You are building an aggregate statement that will group data based on an array field. The statement will also provide a count of the number of documents in each group, with the data sorted in descending order based on the count. Which approach should you take when building the statement?

You are building an aggregate statement that uses the $merge operator to write the pipeline output to a new collection. Where in the pipeline should you position the $merge stage?

You are building an aggregate statement in the Aggregation Editor. You plan to use the $match operator to filter documents based on the values in the interests array field. You want to return all documents that include both the Software and Database array elements. Which expression should you use for the $match operator?

You are building an aggregate statement in the Aggregation Editor. You plan to use the $unwind operator to deconstruct the interests array. Which operator expression should you use?

You are building an aggregate statement in the Aggregation Editor. You plan to use the $sortByCount operator to group values in the interests field and count the number of documents in each group. Which operator expression should you use?

You are building an aggregate statement in the Aggregation Editor. You want to save the pipeline’s output to the reference collection in the marketing database. Which aggregate operator should you use?