Free MongoDB C100DEV Exam Questions

Question 1

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 2

Consider a collection named students with the following document:

{

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

"name" : "Alice",

"age" : 21,

"courses" : [

{

"name" : "Math",

"grade" : 89

},

{

"name" : "Science",

"grade" : 92

}

]

}

What is the query to update the grade of the "Math" course for the student with "_id" equal to ObjectId("5f0a7e80d8c9c7b5a48c49e1") to 95?

A : db.students.updateOne( { "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

B : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1") }, { $set: { "courses.$.grade": 95 } })

C : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

D : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "grade": 95 } })

Answer: C

Question 3

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 4

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 5

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