Free MongoDB C100DEV Exam Questions

Question 1

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

Question 2

You are designing a MongoDB schema for an e-commerce platform. The system has three collections: Products, Categories, and Reviews.Products Collection: Contains information about each product, including its name, price, and categoryId referencing the Categories collection.Categories Collection: Contains the category name and description.Reviews Collection: Contains user reviews for products, including the productId referencing the Products collection, userId, rating, and reviewText.Which of the following is the best approach to model the relationships between Products, Categories, and Reviews in MongoDB?

A : Reference Categories in the Products collection using categoryId and reference Products in the Reviews collection using productId.

B : Embed Categories directly within the Products collection.

C : Embed Reviews directly within the Products collection.

D : Reference Reviews in both the Products and Categories collections.

Answer: A

Question 3

Suppose you insert the following documents into a companies collection:

db.companies.insertMany([

{"name": "Facebook"},

{"name": "X"}

])

Select all true statements about this command. (Select three)

A : This command will insert one document into the collection.

B : The command will only insert the first document and skip the second because the _id field is not explicitly provided.

C : This command will insert two documents into the collection.

D : MongoDB will automatically create an _id field for each document and it will be unique.

E : The _id field is not specified in any of these documents.

Answer: C,D,E

Question 4

You have a MongoDB collection named employees that contains documents with fields name, department, and salary. You want to update the salary of all employees in the "Marketing" department to $75,000. The original collection looks like this:

[

{ "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 },

{ "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 },

{ "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 62000 },

{ "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }

]

You run the following MongoDB update operation:

db.employees.updateMany(

{ "department": "Marketing" },

{ $set: { "salary": 75000 } }

)

What will the collection look like after this update operation?

A : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

B : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 62000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 62000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

C : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 75000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

D : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 75000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

Answer: C

Question 5

Which of the following statements correctly describes the relationship between BSON and JSON in MongoDB?

A : BSON and JSON are exactly the same data format, and the terms can be used interchangeably.

B : MongoDB uses JSON for data storage, and BSON is only used for querying data.

C : BSON is a binary representation of JSON-like documents, with additional data types not found in JSON.

D : BSON is a subset of JSON and only includes a portion of JSON's data types.

Answer: C