Free MongoDB C100DEV Exam Questions

Become MongoDB Certified with updated C100DEV exam questions and correct answers

Page: 1 / 83

Total 411 Questions | Updated On: Nov 24, 2025

Add To Cart

Question 1

Consider a MongoDB database managing e-commerce product data. The database has a collection named products with documents containing the fields product_id, category, price, and reviews. Each reviews field is an array of subdocuments with fields user_id, rating, and comment. You are tasked with optimizing a query that retrieves all products within a specific category that have an average rating higher than 4. The query is frequently used, and performance is critical. Which indexing strategy would best optimize this query?

A : Create a compound index on category and reviews.rating, with a partial filter expression that only includes documents where the average rating in reviews.rating is greater than 4.

B : Create a multi-key index on reviews.rating.

C : Create a compound index on category and reviews.rating.

D : Create a single index on the category field.

E : Create a compound index on category, reviews.rating, and price.

Answer: A

Question 2

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

{

name: 'Wize',

relationships: [

{

is_past: false,

title: 'Head of Product',

person: {

first_name: 'Ethan',

last_name: 'Smith',

permalink: 'ethan-smith'

}

{

is_past: true,

title: 'Director, Business Development',

person: {

first_name: 'Stephanie',

last_name: 'Quay',

permalink: 'stephanie-quay'

}

{

is_past: true,

title: 'Sr. Engineer',

person: {

first_name: 'Stefan',

last_name: 'Antonowicz',

permalink: 'stefan-antonowicz'

}

]

}

Which of the following queries should you use to extract all companies that have "Co-Founder" title in relationships field (Array)?

A : db.companies.find( { relationships: { $expr: { title: 'Co-Founder' } } } )

B : db.companies.find( { relationships: { $elemMatch: { title: 'Co-Founder' } } } )

C : db.companies.find( { relationships: { $match: { title: 'Co-Founder' } } } )

D : db.companies.find( { relationships: { $eq: { title: 'Co-Founder' } } } )

Answer: B

Question 3

How can you insert a new document into a MongoDB collection named customers?

A :

B :

C :

D :

Answer: D

Question 4

Suppose you have a restaurants collection with the following document structure:

{

_id: ObjectId("5eb3d668b31de5d588f42931"),

address: {

building: '6409',

coord: [ -74.00528899999999, 40.628886 ],

street: '11 Avenue',

zipcode: '11219'

borough: 'Brooklyn',

cuisine: 'American',

grades: [

{

date: ISODate("2014-07-18T00:00:00.000Z"),

grade: 'A',

score: 12

{

date: ISODate("2013-07-30T00:00:00.000Z"),

grade: 'A',

score: 12

{

date: ISODate("2013-02-13T00:00:00.000Z"),

grade: 'A',

score: 11

{ date: ISODate("2012-08-16T00:00:00.000Z"),

grade: 'A',

score: 2 },

{

date: ISODate("2011-08-17T00:00:00.000Z"),

grade: 'A',

score: 11

}

name: 'Regina Caterers',

restaurant_id: '40356649'

}

You don't have any indexes so far. What will the query plan look like for the following query?

db.restaurants.find( { "cuisine": "American" } )

A : IXSCAN

B : SORT

C : FETCH

D : COLLSCAN

Answer: D

Question 5

In a MongoDB database, you have a collection named orders that contains information about various product orders placed by customers. Each document in the collection has the following structure:

{

"customerID": "",

"orderID": "",

"product": "",

"quantity": ,

"price": ,

"date": "",

"status": ""

}

You are required to write an aggregation query that retrieves all orders placed by customers where the quantity of ordered items is greater than 100 and the status of the order is "delivered". Which of the following $match stages would you use to achieve this? Select the best option.

A : { "$match": { "quantity": { "$gt": 100 }, "status": "delivered" } }

B : { "$match": { "quantity": { "$lt": 100 }, "status": "delivered" } }

C : { "$match": { "quantity": { "$gt": 100 }, "status": { "$eq": "delivered" } } }

D : { "$match": { "quantity": { "$gte": 100 }, "status": "delivered" } }

Answer: A

Page: 1 / 83

Total 411 Questions | Updated On: Nov 24, 2025

Add To Cart