Free MongoDB C100DEV Exam Questions

Question 1

You are developing a blogging platform using MongoDB as the database. Each blog post document has a tags array field that holds a list of strings. You are tasked to implement a search functionality that allows users to find blog posts based on the tags. Which of the following MongoDB features would you utilize to implement this functionality efficiently?

A : Capped Collections

B : Sharding

C : Text Indexes

D : Compound Indexes

E : GridFS

Answer: C

Question 2

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({ $gt: ["$imdb.votes", "$year"] } )

D : db.movies.find({ $expr: { $gt: ["$imdb.votes", "$year"] } } )

Answer: D

Question 3

You are designing a MongoDB collection to store information about books in a library. Each book document should contain the following fields:title: The title of the book (string).authors: An array of author names (array of strings).published_date: The publication date of the book (ISODate).categories: An array of categories or genres the book belongs to (array of strings).copies: An array containing details about each copy of the book, where each copy has an availability_status (string), location (string), and borrowed_date (ISODate) if the book is currently borrowed.Given this requirement, which of the following schemas correctly represents the document model for this use case? (Select two)

A :

B :

C :

D :

E :

Answer: A,E

Question 4

Consider a tasks collection that holds task records. The document structure is as follows:

{

"_id": ObjectId("64b64c58ed01c0a5e72dbf5f"),

"task": "Review PR",

"status": "pending",

"assignedTo": "alice"

}

Two operations are performed concurrently:

Operation A:

db.tasks.findAndModify({

query: { task: "Review PR", status: "pending" },

remove: true

});

Operation B:

db.tasks.findAndModify({

query: { task: "Review PR", status: "pending" },

update: { $set: { status: "completed" } },

new: true

});

Operation B starts slightly after Operation A but before Operation A completes. What will be the final state of the tasks collection after both operations have been executed?

A : The document will be removed from the collection.

B : The document's status will be updated to "completed".

C : A new document with the status "completed" will be inserted.

D : The document's status will remain "pending".

Answer: A

Question 5

Consider a MongoDB database containing a collection of documents representing product information for an e-commerce website. The documents have the following structure:

{

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

"product_name": "Smartphone",

"brand": "Apple",

"price": 800,

"categories": [ "Electronics", "Smartphones" ],

"reviews": [

{ "username": "user1", "rating": 4, "comment": "Great product!" },

{ "username": "user2", "rating": 5, "comment": "Excellent!" },

{ "username": "user3", "rating": 3, "comment": "Good but overpriced." }

]

}

Select the MongoDB aggregation pipeline that returns the average rating of all products grouped by brand. The result should include only brands with an average rating greater than or equal to 4. The output should have the following format:

A : [ { "$unwind": "$reviews" }, { "$group": { "_id": "$brand", "avg_rating": { "$avg": "$reviews.rating" } } }, { "$match": { "avg_rating": { "$gte": 4 } } }]

B : [ { "$group": { "_id": "$brand", "avg_rating": { "$avg": "$reviews.rating" } } }, { "$match": { "avg_rating": { "$gte": 4 } } }, { "$project": { "brand": "$_id", "avg_rating": "$avg_rating", "_id": 0 } }]

C : [ { "$unwind": "$reviews" }, { "$group": { "_id": "$brand", "avg_rating": { "$avg": "$reviews.rating" } } }, { "$project": { "brand": "$_id", "avg_rating": "$avg_rating", "_id": 0 } }]

D : [ { "$unwind": "$reviews" }, { "$group": { "_id": "$brand", "avg_rating": { "$avg": "$reviews.rating" } } }, { "$match": { "avg_rating": { "$gte": 4 } } }, { "$project": { "brand": "$_id", "avg_rating": "$avg_rating", "_id": 0 } }]

Answer: D