Free MongoDB C100DEV Exam Questions

Question 1

You are working on a MongoDB database for a library system. The system tracks book information in a Books collection. A typical document in this collection looks like this:

Original Document:

{

"_id": ObjectId("book_id"),

"title": "The Art of Computer Programming",

"author": "Donald Knuth",

"genres": ["Computer Science", "Algorithms"],

"published_year": 1968,

"copies_available": 3

}

You are asked to update the document by replacing it with the following document:

Updated Document:

{

"title": "The Art of Computer Programming",

"published_year": 1973

}

After this update, what will the final document in the database look like?

A : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "published_year": 1973}

B : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "author": "Donald Knuth", "genres": ["Computer Science", "Algorithms"], "published_year": 1973, "copies_available": 3}

C : { "title": "The Art of Computer Programming", "published_year": 1973, "author": "Donald Knuth"}

D : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "published_year": 1973, "genres": ["Computer Science"]}

Answer: A

Question 2

We have an accounts collection with the following document structure:

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239d"),

account_id: 864905,

limit: 10000,

products: [ 'Commodity', 'InvestmentStock' ]

},

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239e"),

account_id: 299072,

limit: 10000,

products: [ 'InvestmentFund', 'InvestmentStock' ]

},

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239f"),

account_id: 137994,

limit: 10000,

products: [ 'CurrencyService', 'InvestmentStock' ]

}

We need to use Aggregation Framework to find the distribution of products field. Sort the result set by decreasing total number of products.

Expected output:

[

{ _id: 'InvestmentStock', total: 1746 },

{ _id: 'CurrencyService', total: 742 },

{ _id: 'Brokerage', total: 741 },

{ _id: 'InvestmentFund', total: 728 },

{ _id: 'Commodity', total: 720 },

{ _id: 'Derivatives', total: 706 }

]

Which pipeline should you use?

A : [{ $group: { _id: "$products", total: { $sum: 1 } }}]

B : [{ $unwind: { path: "$products" }}, { $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

C : [{ $unwind: { path: "products" }}, { $group: { _id: "products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

D : [{ $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

Answer: B

Question 3

How does MongoDB handle sorting on fields that contain missing values (i.e., values that are not present in all documents in the collection)?

A : The behavior of sorting on missing values depends on the version of MongoDB being used.

B : The sort fails and returns an error.

C : Missing values are sorted first.

D : Missing values are sorted last.

Answer: C

Question 4

Which of the following statements are true regarding the MongoDB Aggregation Framework and pipelines? (Select two)

A : Aggregation pipelines can include stages like $match, $group, $project, and $sort.

B : Aggregation pipelines allow you to modify the structure of the original collection.

C : Aggregation pipelines support SQL-like joins between multiple collections.

D : The $limit stage is used to skip a specified number of documents in the aggregation pipeline.

E : The $unwind stage is used to deconstruct an array field from the input documents, creating a new document for each element of the array.

Answer: A,E

Question 5

Consider a collection named students with the following document:

{

"_id" : ObjectId("5f0a7e80d8c9c7b5a48c49e1"),

"name" : "Alice",

"age" : 21,

"courses" : [

{

"name" : "Math",

"grade" : 89

},

{

"name" : "Science",

"grade" : 92

}

]

}

What is the query to update the grade of the "Math" course for the student with "_id" equal to ObjectId("5f0a7e80d8c9c7b5a48c49e1") to 95?

A : db.students.updateOne( { "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

B : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1") }, { $set: { "courses.$.grade": 95 } })

C : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

D : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "grade": 95 } })

Answer: C