C100DBA CRUD Operations Practice Question
What is the primary function of the 'projection' parameter in the find() method?
⚠ Common exam trap
Candidates frequently confuse the projection parameter with the query filter parameter, attempting to use projection to limit the number of documents returned instead of just the fields within those documents.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
To specify which fields to return in the documents.
Projections allow you to limit the data returned by a query, which is a best practice for reducing network traffic and memory consumption on both the client and the server. By requesting only the fields required for the current task, you optimize application performance and security. This is a foundational concept in database interaction that helps maintain efficient data flow in large-scale applications.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
To filter which documents are returned.
Why it's wrong here
The filtering of documents is handled by the query document (the first argument to find). The projection is the second argument and specifically controls which fields are present in the returned documents, not which documents are selected from the collection based on their content.
- ✓
To specify which fields to return in the documents.
Why this is correct
The projection defines the shape of the returned document by including or excluding specific fields. It is a critical performance tool because transferring unnecessary data from the database to the application increases latency and memory usage, especially when dealing with large collections or documents with many fields.
- ✗
To sort the returned documents.
Why it's wrong here
Sorting is handled by the sort() cursor modifier, not the projection parameter. Projections are strictly for field selection within a document, whereas sorting dictates the order in which the set of documents is returned based on field values, which are distinct operations in the query pipeline.
- ✗
To limit the number of documents returned.
Why it's wrong here
Limiting the number of documents is performed by the limit() cursor modifier. Projection concerns itself exclusively with the internal structure of the documents being retrieved, not the total count or quantity of the documents themselves. Using them interchangeably would show a misunderstanding of the MongoDB API.
About these practice questions
Courseiva writes every C100DBA question from scratch — 222 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official MongoDB exam blueprint
This C100DBA practice question is part of Courseiva's free MongoDB certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the C100DBA exam.