Save 15% on 2 packs BUY2 · 20% on 3+ BUY3

Skip to content
MongoDB C100DBA Exam Practice Questions, practice question pack
I was struggling with some of the trickier AI concepts. Certstash's detailed explanations really cleared things up for me, where the official docs didn't.
Rachael FisherAIF-C01
Pass, or your money backFail the exam after using this pack and we refund it, or swap it for any other pack. How the guarantee works

MongoDB C100DBA Exam Practice Questions

Every question comes with the correct answer and a clear explanation.

  • 99% pass rate
  • 152 questions
  • 2 PDFs

US$39Pay in your own currency at checkout

Delivered to your email within 24 hours.

  • Free updates for lifeEvery new version of this pack, emailed to you free.
  • Secure checkoutPayPal or card. Pay once, no subscription.
  • Questions-only copyA second PDF without the answers, for timed practice runs.

What’s insideFAQ

Try before you buy

Five of the 152 questions in this pack

Question 1

An Atlas Sample Dataset of restaurants is loaded into a database deployment. How is Data Explorer used to find all restaurants whose name is "The Rose Palace" in the Restaurants database?

Not this one. Try another answer.

Why A is wrong

The Aggregation view with $match and $limit 1 would return only one restaurant, not all of them.

Right, B is the answer.

Why B is right

In Atlas Data Explorer you pick the collection, open the Find view, type the filter document and click Find. The filter is an ordinary query document with a colon, so the aggregation view and a $limit are not needed.

Not this one. Try another answer.

Why C is wrong

Data Explorer can run queries as well as insert, edit and delete documents.

Not this one. Try another answer.

Why D is wrong

The filter must be a query document with a colon; a double equals sign is not valid filter syntax.

Question 2

Given the following query: db.coll.find({}).sort({"income": 1, "tax": -1}) Which two indexes will improve the performance of this query the most? (Choose two.)

Not this one. Try another answer.

Why A is wrong

Both fields descending is neither the same pattern nor its exact reverse, so the sort cannot use it.

Right, B is one of the answers.

Why B is right

A sort on income ascending and tax descending can use an index with exactly that key pattern, or the exact reverse, which is income descending and tax ascending. Those are the two indexes that support the sort without an in-memory sort.

Right, C is one of the answers.

Why C is right

A sort on income ascending and tax descending can use an index with exactly that key pattern, or the exact reverse, which is income descending and tax ascending. Those are the two indexes that support the sort without an in-memory sort.

Not this one. Try another answer.

Why D is wrong

Both fields ascending is neither the same pattern nor its exact reverse, so the sort cannot use it.

Question 3

Given the following sample documents: {_id:1, company: "Farm Inc.", active: true}, {_id:2, company: "Garden Inc.", active: false} A developer wants to create a search query to search for a company. There is a business requirement to accommodate misspellings. An Atlas Search index has already been created for this query. What query satisfies these requirements?

Not this one. Try another answer.

Why A is wrong

Without fuzzy the text operator looks for an exact term, so the misspelling finds nothing.

Not this one. Try another answer.

Why B is wrong

There is no misspelled option in the text operator.

Right, C is the answer.

Why C is right

The fuzzy option inside the text operator lets Atlas Search match terms that are close to the query, so Gardin finds Garden. An empty fuzzy document turns it on with default settings.

Not this one. Try another answer.

Why D is wrong

This is not a valid $search stage; it lacks the operator and path structure.

Question 4

Given the following documents in a collection: {_id:1, a: "one", b: "two"} {_id:2, a: "two", b: "three"} {_id:3, a: "one", b: "four", c: "three"} Using the following update command: db.coll.replaceOne({a: "one"}, {d: "two", b: "five"}) What would the contents of the collection be after successfully running this command?

Right, A is the answer.

Why A is right

replaceOne replaces the whole first matching document with the replacement document, keeping only its _id. The first document with a equal to one therefore becomes {_id:1, d: two, b: five}, and the other documents are untouched.

Not this one. Try another answer.

Why B is wrong

This is a partial update, which is what updateOne with $set does, not replaceOne.

Not this one. Try another answer.

Why C is wrong

replaceOne drops the old fields, so a: one does not stay.

Not this one. Try another answer.

Why D is wrong

replaceOne changes only the first match, so document 3 stays as it was.

Question 5

Given the following match expression: {"c": {$eq: "Green"}, "a": {$gt: 3}} { _id: 1, p: 0.75, c: 'Green', a: [1,3,5,7]}, { _id: 2, p: 0.80, c: 'Orange, a: [1,3]}, { _id: 3, p: 0.13, c: ['Green', 'Orange'], a: [3]}, { _id: 4, p: 0.00, c: 'Green', a: [5,7]}, { _id: 5, p: 0.04, c: 'Green', a: 3}, { _id: 6, p: 0.97, c: 'Red, a:5} What document will be returned from this expression?

Not this one. Try another answer.

Why A is wrong

Document 2 has c as Orange, so it cannot match.

Not this one. Try another answer.

Why B is wrong

This leaves out document 1, which also matches.

Not this one. Try another answer.

Why C is wrong

This includes documents that fail one condition, such as document 3 where a is only 3, document 5 where a is 3 and document 6 where c is Red.

Right, D is the answer.

Why D is right

The expression needs c equal to Green and some value of a greater than 3. Documents 1 and 4 satisfy both: c is Green and their arrays contain 5 and 7. Document 3 has a Green in c but its a array is only 3, and document 5 has a equal to 3.

How much of the MongoDB C100DBA bank is free?

152 questions in the bank

  • Free sample: 5 questions5 real questions, every answer explained, in one PDF.Download PDF
  • Full pack, US$39All 152 questions. Plus the questions-only PDF, free updates for life, refund if you fail.Get the full pack

C100DBA exam questions with answers: all 152 for MongoDB C100DBA.

  • 152 questions mapped to the Associate Database Administrator exam study guide
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Email delivery: sent to your email within 24 hours
  • Free updates for life
  • Pass or your money back

This pack is US$39, paid once.

C100DBA exam questions: the short answers

How long is the MongoDB exam?
MongoDB lists 90 minutes. The exam is multiple choice and taken online.

How often can I sit it?
MongoDB holds exam periods monthly, and the schedule is on MongoDB University.

What makes the C100DBA exam hard

Reading queries matters more than recalling definitions. The free sample asks you to predict the result of replaceOne, to pick the indexes that support a compound sort, to choose a match expression result and to write an Atlas Search query that tolerates misspellings.

Practise the exact behaviour of each operator: replaceOne swaps the whole document apart from its _id, a sort on two fields needs an index in the same or exactly reversed direction, and a fuzzy option makes Atlas Search accept near matches.

About the exam

The MongoDB Associate Database Administrator exam (C100DBA) is MongoDB's certification for people who run and look after MongoDB databases. It is a multiple-choice exam taken online and lasts 90 minutes.

Before you buy

What you get for US$39

  • All 152 questions, each with the correct answer and why the other options are wrong
  • 2 PDFs: the full pack, plus a questions-only copy for timed practice
  • Delivered to your email within 24 hours
  • Updated once a month, with free updates for life, emailed to the address you used at checkout

How a question works

Example: tap an answer, it is marked right or wrong, and the reason for that answer appears under the options.

What do I get?

Every pack comes as 2 PDFs: one with every answer explained, and a questions-only copy for timed practice. Both are delivered to your email within 24 hours, and every pack includes free updates for life.

How often are the questions updated?

Question sets are updated once a month.

Will I receive updates after purchasing?

Yes. All PDF purchases include lifetime updates. Updated versions are emailed automatically to the email address used during checkout.

What if an answer looks wrong?

We correct mistakes as we find them, and the monthly update sends those fixes to you. No question bank this size is ever completely flawless, so if something still looks off to you, check it against the vendor's own documentation and send it to support@certstash.com. We reply to every message, and the fix ships in the next update, free, for life.

Are your materials enough to pass the exam?

Most candidates use them as their main practice source. If you study with them and still fail, we refund you in full.

What happens if I fail my exam?

You get your money back. Sit the exam 7 to 30 days after buying, then email support@certstash.com within 7 days of the exam with your order number and a copy of your official score report showing the fail. Full terms are in the refund policy.

Do you have discount codes?

Yes, when you buy more than one exam pack. For 2 packs, use code BUY2 for 15% off. For 3 or more packs, use code BUY3 for 20% off. Enter the code in the discount box at checkout.

What payment methods do you accept?

Visa, Mastercard and other cards, Apple Pay, Google Pay and PayPal.

Do you offer shipping?

No. All products are digital downloads. There is no physical shipping.

I did not receive my order after payment.

Contact support@certstash.com with your order number and payment confirmation details.