Free MongoDB C100DEV Exam Questions

Question 1

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 2

Consider the following situation: You are a MongoDB Developer and are currently working on an application that requires complex reporting on large amounts of data. The application stores its data in MongoDB, which has grown significantly. To maintain efficiency and manageability, you decide to use MongoDB views. You want to create a view "UsersView" that includes only username, email, and createdAt fields from the Users collection. Which of the following commands would you use?

A : db.createView("UsersView", "Users", [{$project: {username: 1, email: 1, createdAt: 1}}])

B : db.Users.createView("UsersView", {$project: {username: 1, email: 1, createdAt: 1}})

C : db.Users.createView("UsersView", "Users", [{$project: {username: 1, email: 1, createdAt: 1}}])

D : db.Users.createView("UsersView", [{$project: {username: 1, email: 1, createdAt: 1}}])

Answer: A

Question 3

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

Question 4

Consider the following scenario: You have a MongoDB collection named users that stores user information. Each document in the collection has the following structure:

{

"_id": ObjectId("609fe4b5728ad805aef1a88d"),

"name": "John Doe",

"age": 30,

"email": "johndoe@example.com",

"address": {

"street": "123 Main St",

"city": "New York",

"state": "NY",

"zipcode": "10001"

}

You need to retrieve all the documents from the users collection and convert them to an array format. Which of the following MongoDB queries should you use for this task?

A : db.users.find().convertToArray()

B : db.users.find().toArray()

C : db.users.toArray()

D : db.users.aggregate({ $toArray: "users" })

Answer: B

Question 5

You manage a MongoDB collection called inventory that stores documents for a store's inventory. Each document has the fields item, category, and quantity. You want to ensure that an item is always present in the collection, even if it needs to be inserted. Specifically, if the item "notebook" in the "Stationery" category does not exist, it should be inserted with a quantity of 50. If it does exist, its quantity should be updated to 50. You plan to use the following command:

db.inventory.updateOne(

{ "item": "notebook", "category": "Stationery" },

{ $set: { "quantity": 50 } },

{ upsert: true }

)

What will happen after executing this command if there is no "notebook" item in the "Stationery" category in the inventory collection?

A : A new document will be inserted with only quantity: 50, as other fields (item and category) are not mentioned in the $set operator.

B : Nothing will happen because the $set operator only updates existing documents and cannot insert new ones.

C : A new document will be inserted with quantity: 50, but the item field will be set to null.

D : A new document will be inserted with item: "notebook", category: "Stationery", and quantity: 50.

Answer: D