C100DBA Practice Questions

Question 1

A startup is building a content management system where the document structure varies significantly between blog posts, product pages, and user profiles. Which fundamental MongoDB philosophy best supports this requirement?

Accepted Answer

Flexible schema design allows documents in the same collection to have different fields.. MongoDB’s flexible schema design allows developers to store heterogeneous data types within the same collection. Unlike rigid relational schemas that necessitate complex migrations or NULL-heavy tables for varying attributes, document-oriented storage enables an agile development lifecycle. This philosophy prioritizes developer productivity and adaptability, allowing application code to dictate structure rather than being constrained by predefined table schemas that require frequent and disruptive database-level modifications.

Answer

Normalization ensures data integrity for varying document structures.

Answer

Strict schema validation enforces identical fields across all documents.

Answer

Fixed-length record storage improves indexing speed for variable data.

Question 2

Why does MongoDB choose the BSON format over JSON for storage?

Accepted Answer

BSON allows for faster traversal and efficient type identification.. BSON (Binary JSON) extends JSON to provide additional data types and efficient encoding for machine processing. By including length prefixes and type information, the database can traverse documents quickly without needing to parse the entire structure. This binary efficiency is crucial for database performance, allowing the storage engine to perform faster lookups, sorting, and field-level operations that would be significantly slower if it had to interpret raw text-based JSON during every query execution.

Answer

BSON is human-readable and easier to debug than JSON.

Answer

BSON supports fewer data types than standard JSON.

Answer

BSON is mandatory for communication with the shell only.

Question 3

In a three-node replica set with default write concerns, what occurs when the primary node experiences a network partition and cannot communicate with the majority of the set?

Accepted Answer

The primary steps down to secondary status, and the set elects a new primary.. When a primary loses connectivity to the majority of the replica set, it steps down to secondary status to prevent split-brain scenarios. This process ensures data consistency by requiring a majority of nodes to acknowledge writes. The remaining nodes will initiate an election to choose a new primary, maintaining the availability and integrity of the cluster during the temporary partition event.

Answer

The primary continues accepting writes until the partition is resolved.

Answer

The primary immediately crashes and shuts down the mongod process.

Answer

The secondary nodes force a rollback on the primary node.

Question 4

An administrator notices that the MongoDB balancer is actively migrating chunks during peak business hours, causing noticeable application latency spikes. What is the standard administrative approach to mitigate this performance impact?

Accepted Answer

Configure a balancer window by updating the settings collection in the config database to restrict migrations to specific off-peak hours.. Configuring a balancer window restricts chunk migrations to off-peak hours, preventing background balancing traffic from contending with production application workloads. Mastering balancer scheduling controls allows DBAs to maintain cluster health and optimal data distribution without disrupting user experience during critical business hours.

Answer

Permanently terminate the mongos process responsible for orchestrating chunk migrations across the cluster nodes.

Answer

Execute the dropDatabase command on every shard to purge unbalanced chunks instantly and reset the cluster.

Answer

Disable journaling across all shard replica set members to accelerate background data migration speeds.

Question 5

Which THREE of the following are core tenets of the MongoDB philosophy regarding data modeling?

Accepted Answer

Store data that is accessed together in the same document.. MongoDB's data modeling philosophy emphasizes placing data that is accessed together into the same document (embedding). It promotes flexibility by allowing schemas to be dynamic rather than rigid. Furthermore, it encourages developers to design schemas based on the application's specific query patterns, ensuring that the database layout directly supports the most frequent operations, which leads to optimal performance in high-scale environments where relational joins would otherwise create bottlenecks.

Answer

Normalize data to the third normal form.

Answer

Always prioritize write consistency over read performance.

Question 6

Why does MongoDB use a 'document' as its fundamental unit of data?

Accepted Answer

It maps naturally to application objects in code.. The document is the natural way to represent complex objects in code. By keeping related information together in one logical unit, MongoDB aligns the database structure with the application's object model. This eliminates the 'impedance mismatch' often found in relational databases, where developers spend significant time mapping objects to tables. The document model improves performance by allowing the database to retrieve all required data in a single disk read.

Answer

It forces the use of fixed-width records for performance.

Answer

It ensures that no data can ever be duplicated.

Answer

It prevents the database from using indexes on fields.

Question 7

A company is migrating from a monolithic SQL database to MongoDB. They want to maintain high availability. Which feature is most critical to their success?

Accepted Answer

Automatic failover via Replica Sets.. High availability in MongoDB is primarily achieved through Replica Sets. A replica set consists of multiple nodes that store the same data, providing redundancy and automatic failover. If the primary node becomes unavailable, the replica set automatically elects a new primary, ensuring the application remains accessible. This architecture is fundamental to MongoDB's design philosophy of providing a resilient system that can withstand infrastructure failures without impacting the client application's availability.

Answer

Horizontal sharding of the data.

Answer

The use of the Aggregation Framework.

Answer

Strict enforcement of ACID transactions.

Question 8

Refer to the exhibit. The MongoDB process has crashed due to a storage engine error. What is the most immediate administrative action required to restore service?

Accepted Answer

Expand the disk volume and restart the mongod process.. The error 'No space left on device' indicates that the disk partition hosting the 'dbPath' directory is completely full. This prevents WiredTiger from writing data, metadata, or logs, causing an immediate shutdown to prevent data corruption. Administrators must free up space on the disk or extend the partition before restarting the service, as the database cannot recover or accept new writes without sufficient storage capacity to manage its internal files.

Answer

Run 'db.repairDatabase()' via the shell to free up space.

Answer

Clear the 'journal' directory files to recover space.

Answer

Modify the 'storage.wiredTiger.engineConfig.cacheSizeGB' setting in the config file.

Question 9

An application is performing many updates to a document. Which strategy is most effective to avoid fragmentation in the data files?

Accepted Answer

Add padding to the documents to accommodate future growth.. Document growth is a primary cause of fragmentation in MongoDB collections. When a document grows and no longer fits in its current location on disk, it must be moved to a new location. By pre-allocating space or using an embedding strategy that keeps documents within a predictable size range, administrators can reduce the frequency of document moves, thereby minimizing disk fragmentation and maintaining long-term database performance.

Answer

Use the 'compact' command during peak traffic hours.

Answer

Disable the WiredTiger cache periodically.

Answer

Perform a collection scan after every update.

Question 10

When adding a new node to an existing replica set, what is the primary factor that determines how quickly the new member will be able to begin participating in elections?

Accepted Answer

The amount of data in the dataset and network bandwidth.. The speed at which a new replica set member becomes 'secondary' and ready to participate depends on the amount of data it must synchronize from an existing member. Initial sync involves cloning data and applying the oplog. Understanding this process is vital for capacity planning, as adding a large member can put significant I/O and network pressure on the current primary or secondaries, potentially impacting performance for existing application traffic during the synchronization process.

Answer

The memory limit set in the configuration file.

Answer

The number of users defined in the admin database.

Answer

The version of the MongoDB shell used.

Question 11

Which design principle explains why MongoDB uses a document-oriented model instead of a rigid tabular schema?

Accepted Answer

Aligning data storage with object-oriented application models.. MongoDB utilizes a document model to align data structures with how applications represent objects, promoting developer productivity and flexibility. By allowing nested structures, developers avoid complex joins required in relational systems, which significantly improves read performance for related data. This philosophy enables schemas to evolve organically as application requirements change, supporting agile development cycles where modifying a table's structure across millions of rows would otherwise impose significant operational overhead or downtime.

Answer

Normalization of data to reduce storage footprints.

Answer

Strict enforcement of data types via ACID compliance.

Answer

Ensuring all related data is stored in separate collections.

Question 12

During routine cluster maintenance, an administrator needs to remove an underperforming shard from a production MongoDB sharded cluster safely. What is the mandatory first step the administrator must execute?

Accepted Answer

Run the removeShard command on the admin database via a mongos connection to initiate the automated chunk draining process.. Removing a shard safely begins with executing the removeShard command, which initiates the draining process. The cluster balancer automatically migrates all chunks residing on the target shard to other available shards in the cluster, ensuring no user data is lost before the node is decommissioned.

Answer

Execute the dropDatabase command on every secondary member of the shard replica set to clear local storage blocks instantly.

Answer

Manually shut down all mongod processes associated with the target shard before notifying the config server replica set.

Answer

Run the reshardCollection command to merge all orphaned documents into a single backup file on the primary config server.

Question 13

Which TWO of the following are essential for maintaining performance in a sharded cluster?

Accepted Answer

Selecting a shard key with high cardinality.. A well-chosen shard key is the most critical factor for even data distribution, while monitoring chunks ensures that data remains balanced across the cluster. If the shard key is poorly chosen, some shards may become bottlenecks (hotspots), while others remain underutilized. Proper chunk management prevents excessive migration and ensures that query routers (mongos) efficiently route requests to the appropriate shards, maintaining overall system stability and throughput.

Answer

Hardcoding the shard primary in the application connection string.

Answer

Disabling the balancer during all business hours.

Answer

Using the same shard key for every collection in the database.

Question 14

Which design principle should guide the decision between embedding and referencing?

Accepted Answer

Model data based on the application's read and write patterns.. The primary principle for data modeling in MongoDB is the 'access pattern.' You should model data to match how your application queries it. If data is almost always retrieved together, it should be embedded. If the data is accessed independently or is extremely large, it should be referenced. This ensures that the system remains performant by minimizing the number of disk reads and network round-trips required to serve requests.

Answer

Always embed to prevent any possibility of data duplication.

Answer

Always reference to keep the database size as small as possible.

Answer

Use embedding for all data to ensure ACID compliance.

Question 15

When designing an application, what is the best practice for handling connection pools?

Accepted Answer

Maintain a long-lived, singleton instance of the MongoClient.. Maintaining a single, long-lived connection pool instance in the application is the most efficient way to manage database connections. Repeatedly creating and destroying connections is extremely expensive, introducing unnecessary latency and resource overhead on both the application server and the database. Proper pool management is a core application administration task that ensures the database handles traffic gracefully without exhausting its maximum configured connection limit due to unnecessary connection churn from the client side.

Answer

Create a new connection for every query.

Answer

Close the connection after every single write operation.

Answer

Set the connection pool size to zero.

MongoDB Certified DBA Associate C100DBA practice test

Three ways to study

Study C100DBA by domain

Study C100DBA by topic

Philosophy and Features practice questions

Server Administration practice questions

Replication practice questions

Indexing and Performance practice questions

Application Administration practice questions

Sharding practice questions

CRUD Operations practice questions

C100DBA fundamentals practice questions

C100DBA scenario practice questions

C100DBA troubleshooting practice questions

MongoDB Certified DBA Associate practice questions