Free MongoDB C100DEV Exam Questions

Question 1

Suppose you have a reviews collection with the following index:

{ stars: 1, votes: 1 }

Which of the following queries would be a covered query?

A : db.reviews.find( { votes: { $gte: 100 } }, { _id: 0, votes: 1, stars: 1 })

B : db.reviews.find( { votes: { $gte: 100 } }, { _id: 0, votes: 1 })

C : db.reviews.find( { votes: { $gte: 100 }, stars: 4.5 }, { _id: 0 })

D : db.reviews.find( { stars: { $gt: 4.5 } }, { _id: 0, votes: 1 })

Answer: D

Question 2

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 3

We have the following indexes:

{ name: 1, founded_year: 1 }

{ tag_list: 1, is_active: 1 }

And the following documents:

{

_id: ObjectId("52cdef7c4bab8bd675297daa"),

name: "Sparter",

founded_year: 2007,

tag_list: ["gaming", "game", "wow"],

is_active: true

},

{

_id: ObjectId("52cdef7c4bab8bd675297da3"),

name: "Yahoo!",

founded_year: 1994,

tag_list: ["search", "webmail"],

is_active: true

}

Select the true statement.

A : There would be a total of 2 index keys created across all of these documents and indexes.

B : There would be a total of 7 index keys created across all of these documents and indexes.

C : There would be a total of 4 index keys created across all of these documents and indexes.

D : The number of index keys cannot be determined from the given data.

Answer: B

Question 4

Suppose you're designing a MongoDB database for an online ticket booking system where millions of users can concurrently book tickets for various events. To maintain data consistency, you need to ensure that only one user can book a specific seat for an event at a time. Which MongoDB feature would you use to ensure data consistency in this high-concurrency situation?

A : Multi-document transactions

B : Change Streams

C : Capped Collections

D : Sharding

Answer: A

Question 5

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

{

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

"order_number": "ORD-001",

"order_date": ISODate("2022-01-01T00:00:00.000Z"),

"customer": {

"name": "John Doe",

"email": "johndoe@example.com"

},

"items": [

{ "product_name": "Smartphone", "quantity": 2, "price": 800 },

{ "product_name": "Laptop", "quantity": 1, "price": 1500 }

],

"shipping_address": {

"street": "123 Main St",

"city": "New York",

"state": "NY",

"zipcode": "10001"

},

"total_amount": 3000

}

Select an aggregation pipeline that returns the total sales amount by state and month, for orders placed in the year 2022. The result should have the following format:

A : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$group": { "_id": { "state": "$shipping_address.state", "month": { "$month": "$order_date" } }, "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

B : [ { "$group": { "_id": { "state": "$shipping_address.state", "month": { "$month": "$order_date" } }, "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

C : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$group": { "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

D : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

Answer: A