Free MongoDB C100DEV Exam Questions

Become MongoDB Certified with updated C100DEV exam questions and correct answers

Page: 1 / 83

Total 411 Questions | Updated On: Feb 19, 2026

Add To Cart

Question 1

How does MongoDB handle sorting on fields that contain missing values (i.e., values that are not present in all documents in the collection)?

A : The behavior of sorting on missing values depends on the version of MongoDB being used.

B : The sort fails and returns an error.

C : Missing values are sorted first.

D : Missing values are sorted last.

Answer: C

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

Suppose you have a products collection with an index:

{ product_category: 1 }

For which of the following queries can MongoDB look at only a subset of the index entries, rather than all of the index entries?

A : db.products.find( { product_category: /A$/ } )

B : db.products.find( { product_category: /A./ } )

C : db.products.find( { product_category: /S./ } )

D : db.products.find( { product_category: /^A./ } )

Answer: D

Question 4

You are a MongoDB Associate Developer and need to demonstrate how to load the Atlas Sample Dataset into your MongoDB Atlas cluster. Your manager has asked you to guide a junior developer through this process to ensure they can independently load the dataset. What steps should the junior developer follow to successfully load the Atlas Sample Dataset?

A : In MongoDB Atlas, navigate to the "Clusters" tab, click on the "Load Sample Dataset" button, and wait for the dataset to be fully loaded.

B : In MongoDB Compass, connect to your cluster, go to the "Import Data" tab, and import the sample dataset by uploading the sample-dataset.json file.

C : Use the MongoDB Atlas API to send a POST request to the /loadSampleDataset endpoint, specifying your cluster ID in the request body.

D : Open the MongoDB Shell, connect to your cluster, and run the command mongoimport --db sample --collection datasets --file sample-dataset.json.

Answer: A

Question 5

We have an accounts collection with the following document structure:

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239d"),

account_id: 864905,

limit: 10000,

products: [ 'Commodity', 'InvestmentStock' ]

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239e"),

account_id: 299072,

limit: 10000,

products: [ 'InvestmentFund', 'InvestmentStock' ]

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239f"),

account_id: 137994,

limit: 10000,

products: [ 'CurrencyService', 'InvestmentStock' ]

}

We need to use Aggregation Framework to find the distribution of products field. Sort the result set by decreasing total number of products.

Expected output:

[

{ _id: 'InvestmentStock', total: 1746 },

{ _id: 'CurrencyService', total: 742 },

{ _id: 'Brokerage', total: 741 },

{ _id: 'InvestmentFund', total: 728 },

{ _id: 'Commodity', total: 720 },

{ _id: 'Derivatives', total: 706 }

]

Which pipeline should you use?

A : [{ $group: { _id: "$products", total: { $sum: 1 } }}]

B : [{ $unwind: { path: "$products" }}, { $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

C : [{ $unwind: { path: "products" }}, { $group: { _id: "products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

D : [{ $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

Answer: B

Page: 1 / 83

Total 411 Questions | Updated On: Feb 19, 2026

Add To Cart