Free MongoDB C100DEV Exam Questions

Question 1

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 2

When sharding a MongoDB collection, what is the main factor that determines the distribution of data across shards?

A : The location of the client issuing the query

B : The number of documents in the collection

C : The size of each document

D : The value of a shard key

Answer: D

Question 3

In your database there is a collection named trips with the following document structure:

{

'_id': ObjectId("572bb8222b288919b68abf6d"),

'trip_duration': 858,

'start_station id': 532,

'end_station_id': 401,

'bike_id': 17057,

'start_station_loc': { type: 'Point', coordinates: [ -73.960876, 40.710451 ] },

'end_station_loc': { type: 'Point', coordinates: [ -73.98997825, 40.72019576 ] },

'start_time': ISODate("2016-01-01T00:09:31.000Z"),

'stop_time': ISODate("2016-01-01T00:23:49.000Z")

}

How can you extract all trips from this collection ended at stations that are to the west of the -73.5 longitude coordinate?

A : db.trips.find( { 'end_station_loc.coordinates.0': { $gt: -73.5 } } )

B : db.trips.find( { 'coordinates': { $lt: -73.5 } } )

C : db.trips.find( { 'end_station_loc.coordinates.0': { $lt: -73.5 } } )

D : db.trips.find( { 'end_station_loc.coordinates.1': { $lt: -73.5 } } )

Answer: C

Question 4

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

Question 5

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