Skip to content

MongoDB Associate Developer - Study Strategy

Study Approach

Phase 1: CRUD Foundations (1-2 weeks)

  1. Core Operations
  2. Master insert, find, update, and delete operations
  3. Learn all query operators ($eq, $gt, $in, $and, $or, $regex, etc.)
  4. Practice update operators ($set, $inc, $push, $pull, $addToSet)

  5. Understand cursor methods (sort, limit, skip, count)

  6. Hands-on Practice

  7. Set up MongoDB Atlas free tier or local MongoDB
  8. Import sample datasets and practice queries
  9. Use MongoDB Compass for visual query building
  10. Practice with MongoDB Shell (mongosh)

Phase 2: Indexes and Data Modeling (2-3 weeks)

  1. Indexing
  2. Create and analyze different index types
  3. Practice using explain() to analyze query performance
  4. Learn the ESR rule for compound index design

  5. Understand covered queries and index selectivity

  6. Data Modeling

  7. Study embedding vs referencing trade-offs
  8. Learn schema design patterns (polymorphic, bucket, outlier, attribute)
  9. Practice modeling different relationship types
  10. Understand document size limits and working set size

Phase 3: Aggregation and Atlas (2-3 weeks)

  1. Aggregation Pipeline
  2. Build pipelines with $match, $group, $project, $sort
  3. Practice $lookup for cross-collection joins
  4. Learn $unwind for array deconstruction
  5. Implement $facet for multi-faceted results

  6. Understand pipeline optimization rules

  7. Atlas Tools

  8. Create Atlas Search indexes and run search queries
  9. Build charts with Atlas Charts
  10. Use Atlas Data API for REST-based access
  11. Configure database triggers

Phase 4: Exam Preparation (1 week)

  1. Practice Questions
  2. Take practice exams
  3. Review incorrect answers with documentation

  4. Focus on CRUD (30%) and Aggregation (25%) - these are 55% of the exam

  5. Final Review

  6. Review operator reference tables
  7. Review aggregation stage syntax
  8. Review index types and their use cases

Study Resources

Official MongoDB Resources

Practice and Hands-on

Exam Tactics

Question Strategy

  1. CRUD Questions (30%) - Know exact syntax for operations and operators
  2. Aggregation Questions (25%) - Know pipeline stage order and output shape
  3. Data Modeling Questions (20%) - Understand trade-offs for embedding vs referencing
  4. Index Questions (15%) - Know index types and when to use each
  5. Atlas Questions (10%) - Know Atlas tools capabilities

Time Management

  • ~1.2 minutes per question average
  • Flag and move - Do not spend more than 2 minutes on any question
  • Reserve 10 minutes for reviewing flagged questions
  • CRUD and Aggregation first - These are the majority of the exam

Key Areas to Master

  • Query and update operator syntax
  • Aggregation pipeline stage ordering and output
  • Compound index design using the ESR rule
  • Embedding vs referencing decision criteria
  • $lookup syntax and behavior
  • Atlas Search $search stage

Common Pitfalls

  1. $push vs $addToSet - $addToSet only adds if value not already present
  2. updateOne vs replaceOne - updateOne uses operators, replaceOne replaces entire document
  3. Aggregation $match placement - Place early in pipeline for index usage
  4. Compound index field order matters - ESR: Equality, Sort, Range
  5. $lookup requires $unwind for one-to-many - Without $unwind, results are arrays
  6. 16 MB document limit - Affects embedding strategy for large arrays
  7. TTL indexes only work on date fields - Must be a Date type or array of Dates
  8. $elemMatch vs dot notation - $elemMatch ensures conditions match same element