Free MongoDB C100DEV Exam Questions

Question 1

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 2

A MongoDB collection named logs is used to store event data for a web application. The collection originally had indexes on the timestamp, user_id, and event_type fields to facilitate fast queries on these fields. Due to a recent data archiving strategy, you decide to remove the index on event_type to save storage space. However, after doing so, some queries on the logs collection have slowed down considerably, especially those filtering by event_type. What is the most likely ramification of deleting the index on the event_type field?

A : Removing the index has no impact on the performance of queries filtering by event_type.

B : The database size will increase because the data is now unindexed.

C : All queries involving the event_type field will now use the _id index, resulting in faster performance.

D : Queries involving the event_type field will require a full collection scan, leading to slower performance.

Answer: D

Question 3

As a MongoDB Developer, you are tasked with optimizing a MongoDB database. Your collection has documents with the following structure:

{

"_id": ObjectId(),

"user_id": Number,

"user_data": {

"name": String,

"email": String,

"phone": String,

"address": {

"city": String,

"state": String,

"country": String

}

},

"transactions": [

{

"transaction_id": Number,

"amount": Number,

"date": Date

}

]

}

The application frequently queries for the total transaction amount for users based on the city. Which index should you create to optimize the performance of these queries?

A : db.collection.createIndex({"user_data.address.city": 1})

B : db.collection.createIndex({"user_data.address.city": 1, "transactions.amount": 1})

C : db.collection.createIndex({"user_id": 1})

D : db.collection.createIndex({"transactions.amount": 1})

E : db.collection.createIndex({"transactions": 1})

Answer: B

Question 4

There is a collection named products in MongoDB database. Your coworker wants to know how many products are in this collection (number of documents in the collection). Which query should you use? (Select two)

A : db.products.total()

B : db.products.countAll()

C : db.products.countDocuments()

D : db.products.aggregate()

E : db.products.find().count()

Answer: C,E

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