MongoDB Certified Database Administrator Preparation Details
The MongoDB Certified Database Administrator exam validates your ability to secure, monitor, tune, and recover MongoDB deployments. This study guide maps every domain and objective to official MongoDB documentation, so you can prepare efficiently. You can also explore more MongoDB certification study guides on the MongoDB category to keep building your skills.
MongoDB Certified Database Administrator Materials
Domain 1: MongoDB Architecture and Core Operations (15%)
Objective 1.1: Build an aggregation pipeline to transform and analyze data in MongoDB.
Build and analyze aggregation pipelines using $match, $unwind, $group, $project, $sort, and $limit stages
Understand how stage sequencing affects pipeline behavior and output
Aggregation Pipeline Optimization
Identify cloud architecture and best practices.
Security Features for Clusters
Objective 1.2: Explain data aggregation concepts and when to use them.
Understand what aggregation is and how stage sequencing affects query results
Aggregation Pipeline Optimization
Objective 1.3: Design effective queries to retrieve data accurately and efficiently.
Write queries using equality constraints on array fields, relational operators ($gt, $lt, $gte, $lte), and logical operators ($and, $or)
$gt (query predicate operator)
$lt (query predicate operator)
$gte (query predicate operator)
$lte (query predicate operator)
$and (query predicate operator)
$or (query predicate operator)
Objective 1.4: Describe document model fundamentals and how they support flexible schema design.
Define a document database and explain its advantages over relational models
Understand when to use embedding vs. referencing in a MongoDB document model
Embedded Data Versus References
Operational Factors and Data Models
Objective 1.5: Modify query results using projection, sorting, limiting, and other query options.
Refine query results using .sort(), .limit(), and .countDocuments()
cursor.sort() (mongosh method)
cursor.limit() (mongosh method)
db.collection.countDocuments() (mongosh method)
Use projection with the find() method to return only selected fields
Project Fields to Return from Query
db.collection.find() (mongosh method)
Objective 1.6: Perform CRUD operations to create, read, update, and delete MongoDB data.
Perform update operations using $set with updateOne() to modify document fields
db.collection.updateOne() (mongosh method)
Domain 2: Indexing and Query Optimization (13%)
Objective 2.1: Differentiate between Atlas and DB users for Atlas administration.
Identify the difference between roles and actions for Atlas and Database users
Configure Authentication and Authorization
Security Features for Clusters
Objective 2.2: Apply indexing best practices to improve query efficiency.
Identify different index types and their costs, and understand why index prefix alignment matters for query patterns
Operational Factors and Data Models
Define and apply the ESR guideline when designing indexes
The ESR (Equality, Sort, Range) Guideline
Use Indexes to Sort Query Results
Create Indexes to Support Your Queries
Create Selective Indexes to Answer Queries Efficiently
Objective 2.3: Measure index performance using MongoDB performance metrics and tools.
Use explain plans to confirm a query is using the expected index
cursor.explain() (mongosh method)
Objective 2.4: Enhance read and write operations through performance tuning strategies.
Create indexes in MongoDB to improve query performance for read and write operations
Index Builds on Populated Collections
Create, View, Drop, and Hide Indexes
Objective 2.5: Optimize indexes for performance based on workload and query patterns.
Identify how sort order, cardinality, value distribution
Use Indexes to Sort Query Results
Create Selective Indexes to Answer Queries Efficiently
The ESR (Equality, Sort, Range) Guideline
Monitor and Improve Slow Queries
Objective 2.6: Optimize query performance in MongoDB.
Recognize architectural components that impact performance: horizontal and vertical scalability, storage engine, document model, and query planner
Use explain() plans to analyze slow queries and apply optimization strategies including index creation, query modification, and data model changes
Create Indexes to Support Your Queries
Monitor and Improve Slow Queries
Domain 3: Performance Monitoring and Tuning (23%)
Objective 3.1: Identify monitoring tools for MongoDB and explain their use cases.
Use query insights to identify and investigate query performance issues
Monitor Collection-Level Query Latency
Monitor and Improve Slow Queries
Use the Performance Advisor to identify slow query patterns and apply recommended index changes
Monitor and Improve Slow Queries
Create, View, Drop, and Hide Indexes
Objective 3.2: Configure alerting mechanisms in MongoDB.
Configure alerts in to proactively detect and respond to performance or availability issues
Identify the key components of an effective MongoDB monitoring strategy
Recommendations for Atlas Monitoring and Alerts
Understand the monitoring best practices in MongoDB
Recommendations for Atlas Monitoring and Alerts
Objective 3.3: Use tuning techniques to improve MongoDB performance.
Understand the purpose and benefits of profiling as a performance analysis technique in MongoDB
Understand slow query analysis
Monitor and Improve Slow Queries
Domain 4: Cluster Reliability and Data Resilience (24%)
Objective 4.1: Identify and respond to cluster failures in MongoDB deployments.
Identify key cluster metrics and apply the Identify → Mitigate → Remediate methodology to resolve issues
Recommendations for Atlas Monitoring and Alerts
Proactively identify backup issues and select an appropriate backup schedule and recovery strategy
Back Up, Restore, and Archive Data
Restore from a Scheduled or On-Demand Snapshot
Objective 4.2: Manage failover and backups to support availability and recovery.
Explain operational safeguards and backup best practices
Back Up, Restore, and Archive Data
Identify backup compliance requirements and how they apply to deployments
Configure a Backup Compliance Policy
Back Up, Restore, and Archive Data
Objective 4.3: Explain MongoDB architecture for resilience and high availability.
Identify common risks to cloud applications and explain how replica sets provide resilience and failover
Explore multi-region, multi-cloud, and availability zone deployments for optimized durability and availability
Replica Sets Distributed Across Two or More Data Centers
Objective 4.4: Troubleshoot replication issues in replica set environments.
Describe and identify common causes of replication lag using tools and logs
Replica Set Data Synchronization
Remediate clusters experiencing recurring failovers
Rollbacks During Replica Set Failover
Domain 5: Sharding Strategies and Scalable Deployments (8%)
Objective 5.1: Design and apply appropriate sharding strategy for MongoDB workloads.
Explain the impact of different sharding strategies on data distribution and performance
Select an optimal shard key and apply criteria to implement a suitable strategy for a given application workload
Operational Restrictions in Sharded Clusters
Objective 5.2: Explain MongoDB sharding architecture and its core components.
Understand how data is distributed across shards in a MongoDB sharded cluster
Domain 6: Security, Networking, and Encryption (17%)
6.1 Differentiate between self-managed users and database users in MongoDB environments.
Explain authentication concepts and mechanisms for self managed deployments, including SCRAM, and distinguish authentication from authorization.
Authentication on Self-Managed Deployments
Role-Based Access Control in Self-Managed Deployments
6.2 Identify and implement MongoDB encryption-at-rest solutions for data security.
Identify when encryption at rest is needed and recognize how encryption at rest is implemented in self managed deployments at the storage layer using WiredTiger encrypted storage.
6.3 Implement TLS encryption for a self-managed MongoDB deployment.
Explain the purpose of TLS in self managed deployments and recognize that it must be explicitly configured to protect both client to server and inter node communication.
TLS/SSL (Transport Encryption)
Configure MongoDB Instances for TLS/SSL Encryption
Connect to a TLS-Enabled Replica Set
Internal/Membership Authentication
6.4 Manage database user roles and privileges in MongoDB using role-based access control.
Create custom roles for database users in MongoDB
Role-Based Access Control in Self-Managed Deployments
Manage Users and Roles on Self-Managed Deployments
Assign specific roles to database users to enforce least-privilege access
Manage Users and Roles on Self-Managed Deployments
Enable Access Control on Self-Managed Deployments
Wrapping Up MongoDB Certified Database Administrator
Use this MongoDB Certified Database Administrator study guide to work through all six domains, from architecture and indexing to sharding and encryption. Review each linked page, practice in a live cluster, and you will be ready for exam day. You can also explore more MongoDB certification study guides on the MongoDB category to keep building your skills. Have a question or tip? Leave a comment below.
Receive Updates on MongoDB Certified Database Administrator Exam
Want to be notified as soon as I post? Subscribe to the RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.
