C100DBA Hard Questions — 25 Difficult Questions

Question 1

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 2

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 3

Refer to the exhibit. What will be the result of this query?

Accepted Answer

Returns documents with only the 'name' field and no '_id' field.. The query returns all documents where the status field is 'active'. The projection { name: 1, _id: 0 } explicitly includes the 'name' field and explicitly excludes the '_id' field, which is included by default. This is a common pattern for generating clean reports or API responses where internal database identifiers should be hidden from the client or where unnecessary data transfer is undesirable for application performance.

Answer

Returns documents with only the 'status' and 'name' fields.

Answer

Returns an error because 'name' and '_id' cannot be mixed.

Answer

Returns the entire document including all fields.

Question 4

A high-throughput collection in a MongoDB cluster experiences degraded write performance due to a heavily fragmented compound index. Which TWO administrative actions safely resolve index fragmentation without downtime? (Choose TWO)

Accepted Answer

Perform a rolling maintenance procedure by stepping down secondaries, rebuilding their indexes, and finally stepping down the primary.. Managing index fragmentation in production environments requires careful operational planning to avoid locking primary nodes or starving application traffic. Rebuilding indexes online or performing rolling primary-to-secondary maintenance ensures high availability while reclaiming wasted disk space and restoring optimal B-tree traversal speeds.

Answer

Execute the compact command on every individual collection containing fragmented indexes during peak operational hours.

Answer

Drop the fragmented index and recreate it using the background option in MongoDB versions prior to 4.2.

Answer

Rebuild indexes using the createIndexes command with unique naming strategies to replace the old structures.

Question 5

Which THREE of the following are valid ways to modify an array field in a document?

Accepted Answer

$push adds an element to an array, potentially creating duplicates.. Modifying arrays is a common task in MongoDB. Operators like $push, $addToSet, and $pull provide specific logic for adding or removing items. $push allows duplicates, $addToSet ensures uniqueness, and $pull removes elements. Mastering these operators is essential for handling nested data structures and managing user-generated content or tagging systems effectively within a document-oriented database schema.

Answer

$merge combines two different collection documents into one array.

Answer

$updateArray is the default operator for all array modifications.

Question 6

Refer to the exhibit. A query filters on field 'a'. Which index will the optimizer choose?

Accepted Answer

It will choose based on the optimizer's cost analysis.. MongoDB's query optimizer evaluates available indexes based on cost. When both {a: 1, b: 1} and {a: 1} are available, both can satisfy a query filtering on 'a'. However, the optimizer typically prefers the index that is most specific or smaller if the costs are identical. In many cases, the single-field index {a: 1} is preferred as it is smaller and more efficient for a single-field filter.

Answer

It will always use {a: 1, b: 1}.

Answer

It will always use {a: 1}.

Answer

It will perform a collection scan.

Question 7

Which THREE operations would require a write lock on the entire collection in older MongoDB versions (pre-WiredTiger) or affect performance significantly?

Accepted Answer

db.collection.drop(). Before the introduction of the WiredTiger storage engine, MongoDB utilized collection-level locking. Operations like dropping a collection, creating indexes, or performing heavy batch updates could block all other operations. While modern storage engines provide document-level concurrency, understanding these legacy behaviors is still important for database administrators managing older clusters or troubleshooting performance bottlenecks that might arise from global or collection-level locking contention patterns.

Answer

db.collection.findOne({_id: 1})

Answer

db.collection.find().limit(10)

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

Which THREE of the following actions are standard steps when decommissioning a MongoDB node from a replica set?

Accepted Answer

Execute 'rs.remove()' from the primary node.. Decommissioning a node requires careful coordination to prevent cluster instability. Failing to update the configuration or clean up the node can lead to dangling references or unnecessary connection attempts by other members. Following a strict sequence ensures that the remaining replica set maintains its quorum and that the removed node does not interfere with the health or the security profile of the active production cluster.

Answer

Immediately delete the /var/lib/mongodb directory.

Answer

Force a primary election before removal.

Question 10

What happens when a $sort operation cannot be satisfied by an index?

Accepted Answer

The query fails if the sorted data exceeds 100 MB.. If a query result set exceeds the 100 MB limit for an in-memory sort, MongoDB will throw an error and terminate the query. When sorting is required but no index can provide the order, MongoDB must perform a blocking sort in memory. This is a common performance trap that often leads to high memory consumption and application errors if the collection grows significantly larger than expected.

Answer

The database automatically creates a temporary index.

Answer

It defaults to a disk-based sort automatically.

Answer

The sort is performed by the client driver.

Question 11

What is the effect of setting 'writeConcern' to '{ w: "majority" }' on an application's write operations?

Accepted Answer

The write will persist even if the primary node crashes after acknowledgement.. Setting write concern to 'majority' ensures that the data is acknowledged by a majority of the replica set members before the client receives a success response. This guarantees that the write will not be rolled back during an election, which is critical for maintaining data integrity and preventing 'dirty reads' in distributed systems. It is the best practice for applications requiring strong consistency and durability in a production replica set.

Answer

The write operation will be faster than with 'w: 1'.

Answer

It forces the data to be written directly to the disk cache.

Answer

It automatically enables read-your-writes consistency for all reads.

Question 12

Refer to the exhibit. Why might this geospatial query be underperforming?

Accepted Answer

The $maxDistance is too large, causing too many documents to be evaluated.. Geospatial queries require specific indexing and data structures. If the index isn't used, the query might default to a less efficient operator. Furthermore, geospatial queries are computationally expensive. Without proper bounds or if the data set is very dense, the $near operator can trigger excessive calculations, leading to high latency. Ensuring the query matches the index precision and the $maxDistance parameter is optimized is essential for performance.

Answer

2dsphere indexes do not support $near queries.

Answer

Geospatial indexes require a compound index on all fields.

Answer

The coordinates are stored in the wrong order (latitude/longitude).

Question 13

A developer is optimizing queries for an e-commerce application. Which TWO of the following strategies are best for reducing the impact of large result sets on the application server memory?

Accepted Answer

Implement cursor-based pagination using .limit() and .skip().. Handling large data volumes effectively requires shifting the memory burden away from the application server. Using cursors allows for incremental fetching of data, while projection limits the amount of raw data transferred over the network. Both strategies combined minimize the heap usage on the application server, preventing OutOfMemory errors and ensuring the application remains responsive under load, which is critical for scaling MongoDB-backed applications efficiently.

Answer

Use the .toArray() method on every query result to ensure data is accessible.

Answer

Increase the batch size to the maximum allowed by the driver.

Answer

Store the result set in a global variable for reuse by other threads.

Question 14

Refer to the exhibit. If node 0 (the current primary) goes offline, which node will be elected as the new primary?

Accepted Answer

Node 1. Replica set elections are influenced by the priority value. Nodes with higher priority are preferred candidates. When the current primary fails, the node with the highest priority among the available nodes will win the election. If multiple nodes have the same highest priority, the one with the most recent oplog data wins, ensuring that the most capable and up-to-date node takes over.

Answer

Node 2

Answer

Both Node 1 and Node 2 will share the primary role.

Answer

The cluster will remain without a primary until Node 0 is repaired.

Question 15

Which TWO actions should a database administrator perform before executing the shardCollection command on an existing populated MongoDB collection? Choose 2 answers.

Accepted Answer

Create an index on the collection that supports the chosen shard key prefix.. Sharding an existing populated collection requires creating the supporting index first to provide the routing foundation, and ensuring the database is explicitly enabled for sharding. Performing these prerequisites avoids runtime failures and ensures the cluster balancer can immediately initialize and distribute the initial data chunks across the configured shards without throwing administrative exceptions.

Answer

Temporarily stop all incoming application write operations across all mongod instances to prevent race conditions during chunk allocation.

Answer

Run the compact command on every underlying data file to defrag storage before shard boundary calculations execute.

Answer

Convert all ObjectId fields inside the target collection into standard string representations to satisfy BSON sharding constraints.

Question 16

Which THREE statements are true regarding the behavior and mechanics of the MongoDB cluster balancer? Choose 3 answers.

Accepted Answer

The balancer runs in the background and is coordinated by the primary node of the config server replica set.. The MongoDB balancer runs as a background process coordinated by the primary config server, moving chunks between shards when migration thresholds are met. Knowing balancer mechanics helps DBAs troubleshoot uneven data distributions, plan maintenance windows, and manage cluster resources effectively without causing unexpected performance degradation.

Answer

The balancer requires every individual shard in the cluster to be configured as a standalone mongod instance for optimal migration speed.

Answer

Disabling the balancer permanently deletes all existing chunk distribution boundaries and collapses the collection into a single unsharded file.

Question 17

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 18

Which capability of MongoDB's document model most significantly distinguishes it from key-value stores?

Accepted Answer

The ability to index and query nested document fields.. While key-value stores are limited to looking up data by a single key, MongoDB allows for deep inspection and querying of the document content. MongoDB indexes fields within the document, enables complex aggregation pipelines, and supports ad-hoc queries on any field. This versatility transforms the database from a simple lookup engine into a powerful analytical and transactional system, allowing it to handle diverse workloads that require rich data exploration and complex filtering.

Answer

The ability to store binary data as BSON.

Answer

The use of a primary key for document retrieval.

Answer

The support for horizontal scaling across clusters.

Question 19

Refer to the exhibit. An administrator attempts to execute the shardCollection command but receives the displayed error message. What is the root cause of this failure?

Accepted Answer

The collection lacks a supporting index whose key pattern matches or starts with the fields specified in the shard key definition.. MongoDB requires an explicit index whose prefix matches the designated shard key before sharding a collection. The error indicates that no such index exists on the collection, preventing the query router from establishing the necessary routing boundaries. Creating the correct index prior to running shardCollection resolves this issue.

Answer

The target database has not been enabled for sharding using the enableSharding administrative command.

Answer

The specified shard key contains an unsupported array field that violates BSON multi-key index constraints.

Answer

The config server replica set is currently undergoing an election and cannot process metadata write operations.

Question 20

A sharded cluster experiences poor query performance because a targeted query targeting a specific shard key still results in a scatter-gather operation across all shards. What is the root cause?

Accepted Answer

The query predicate completely omitted the shard key or its valid prefix fields.. To target a specific shard directly, a query must include the exact shard key or a valid prefix of the shard key in its filter predicate. Omitting the shard key forces the mongos router to query every shard in the cluster to assemble the final result set.

Answer

The chunk migration threshold was set too low, causing frequent balancing cycles across shards.

Answer

The collection was created as unhashed, preventing the mongos router from hashing query inputs.

Answer

The balancer process was paused, leaving uneven document distribution across cluster shards.