C100DBA Philosophy and Features — 25 Questions

Question 1

Which TWO of the following statements correctly describe the MongoDB document model?

Accepted Answer

Documents can contain nested arrays and sub-documents.. The MongoDB document model is designed for developer productivity and performance by mapping directly to object-oriented programming structures. Unlike rigid table structures, the document model allows for polymorphic data, enabling documents within the same collection to have different fields. This flexibility empowers developers to iterate quickly on features without performing expensive schema migrations, making it a cornerstone of the modern development lifecycle.

Answer

Documents must have an identical set of fields within a collection.

Answer

All documents are limited to a maximum size of 64MB.

Answer

Joins are impossible to perform in MongoDB queries.

Question 2

Refer to the exhibit. Which MongoDB feature is primarily responsible for managing this resource?

Accepted Answer

The WiredTiger Storage Engine.. The WiredTiger storage engine manages the cache for MongoDB. When the cache usage reaches high thresholds, the engine must balance the need for memory availability with the incoming load. WiredTiger uses an LRU (Least Recently Used) policy to evict data from memory. Understanding the storage engine's role in memory management is vital for DBA performance tuning, as efficient cache usage is the primary driver of low-latency operations in MongoDB.

Answer

The Aggregation Framework.

Answer

The Replica Set election protocol.

Answer

The Sharding balancer.

Question 3

Which TWO of the following characterize MongoDB's approach to horizontal scalability?

Accepted Answer

Sharding distributes data across multiple independent nodes.. MongoDB achieves horizontal scalability through sharding, which involves partitioning data across multiple servers. By distributing the dataset based on a shard key, the system ensures that read and write workloads are spread across a cluster. This architecture is vital for handling massive datasets and high-concurrency environments that exceed the capacity of a single physical machine, allowing administrators to add capacity linearly by introducing additional shards to the cluster.

Answer

Primary nodes automatically rebalance data without user intervention.

Answer

Horizontal scaling is achieved by adding more CPUs to a single node.

Answer

Applications must perform manual routing to locate specific shards.

Question 4

Why does MongoDB use a replica set for high availability rather than a traditional master-slave setup?

Accepted Answer

Replica sets provide automated, failover-resistant operation.. Traditional master-slave setups often suffer from manual failover, which causes downtime. MongoDB's replica set architecture automates the election process. When the primary fails, the cluster instantly promotes a new primary, maintaining service continuity. This automated, self-healing capability is essential for modern applications that require near-zero downtime, demonstrating MongoDB's commitment to reliability in distributed environments where nodes or network segments will inevitably experience failures at some point.

Answer

Master-slave setups are not supported by the protocol.

Answer

Master-slave limits the number of nodes in a set.

Question 5

A financial services firm is migrating a legacy trading system to MongoDB. The compliance team insists that every write to the trade collection must be acknowledged by a majority of replica set members before the client receives confirmation, and that the write must persist even if the primary steps down immediately after acknowledgment. Which combination of write concern and read concern should the application use to meet these requirements?

Accepted Answer

Write concern w:majority and read concern majority. For regulated trade data, the application must use write concern w:majority to ensure writes are acknowledged by a majority of replica set members and survive primary failover. Read concern majority ensures reads return only data that has been majority-committed and cannot be rolled back. Together they provide the durability and consistency required by compliance.

Answer

Write concern w:1 and read concern local

Answer

Write concern w:majority and read concern local

Answer

Write concern w:0 and read concern majority

Question 6

A database administrator is setting up a MongoDB replica set for a new application. The application requires that a write operation be acknowledged by at least three members of the replica set before the client considers it successful. The replica set has five voting members. Which write concern should the administrator configure?

Accepted Answer

w:3. Write concern w:3 explicitly requires acknowledgment from three members: the primary and two secondaries. This matches the application's requirement for at least three acknowledgments. While w:majority also yields three acknowledgments in a five-member set, w:3 is the direct numeric specification that the administrator should configure to meet the exact stated requirement.

Answer

w:2

Answer

w:majority

Answer

w:1

Question 7

A MongoDB cluster is experiencing performance degradation during peak hours. The operations team notices that many queries are scanning large portions of collections because the application uses ad-hoc queries with varying filter fields. The team wants to improve performance without modifying the application code. Which MongoDB feature should they implement to automatically optimize query performance based on workload patterns?

Accepted Answer

The Performance Advisor in MongoDB Atlas. The Performance Advisor in MongoDB Atlas analyzes query patterns and suggests indexes to improve performance. It continuously monitors slow queries and provides actionable recommendations. Since the team cannot modify application code, implementing the suggested indexes is the correct approach to optimize ad-hoc queries without code changes.

Answer

Index intersection

Answer

Automatic index creation

Answer

The Query Optimizer

Question 8

A database administrator is designing a MongoDB deployment that must support high availability and automatic failover. The administrator is evaluating MongoDB's replica set features. Which two of the following are characteristics of MongoDB replica sets? (Choose two.)

Accepted Answer

Replica sets support read operations from secondary members.. Replica sets automatically elect a new primary upon primary failure, providing automatic failover. They also support read operations from secondary members via read preference, allowing read scaling. These two features are core characteristics of MongoDB replica sets that support high availability and performance.

Answer

Replica sets use a shared-nothing architecture where each member stores a different subset of the data.

Answer

Replica sets can have members in different data centers for disaster recovery.

Answer

Replica sets require a minimum of three members to function.

Question 9

A high-traffic e-commerce application requires a schema that avoids multi-document transactions where possible to ensure maximum throughput. Which MongoDB philosophy aligns best with this requirement?

Accepted Answer

Embed related data in a single document to ensure atomic updates.. MongoDB promotes data modeling patterns that prioritize data access patterns. Embedding related data in a single document enables atomic operations on that document, eliminating the need for complex transactions. By co-locating data that is frequently accessed together, applications reduce latency and server overhead, which is critical for high-performance e-commerce platforms. This design philosophy leverages the document model to ensure consistency and speed within the scope of a single document update.

Answer

Normalize all data into separate collections to eliminate redundancy.

Answer

Implement a strict relational schema to enforce referential integrity.

Answer

Use the GridFS specification for all user-generated content.

Question 10

Refer to the exhibit. What is the primary benefit of the data structure shown?

Accepted Answer

It allows for indexing the array to support efficient queries.. The exhibit illustrates the use of an array field within a document. By embedding 'tags' directly into the product document, the application can index and query these items without requiring a separate collection or a join. This design effectively demonstrates how the document model supports efficient data retrieval for common filtering patterns, ensuring that the database scales horizontally while keeping related data units cohesive and performant.

Answer

It forces data normalization for better storage efficiency.

Answer

It enforces referential integrity between products and tags.

Answer

It requires a multi-document transaction to update the tags.

Question 11

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 12

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 13

Which THREE of the following are core pillars of the MongoDB architecture?

Accepted Answer

Horizontal scalability through sharding.. MongoDB's architecture is built on the principles of horizontal scalability, high availability, and developer-focused data modeling. These pillars allow MongoDB to handle massive scale and fluctuating workloads efficiently. By integrating sharding for capacity, replication for reliability, and flexible schemas for agility, the system addresses the common limitations of static relational databases, offering a comprehensive platform for modern, distributed cloud-native applications that require both speed and robustness in dynamic environments.

Answer

Strict, static schema enforcement at the storage layer.

Answer

Global dependency on a single centralized primary node.

Question 14

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 15

What is the consequence of MongoDB's 'write concern' in a distributed environment?

Accepted Answer

It allows developers to balance latency and durability.. Write concern determines the level of acknowledgment required from the replica set before a write operation is considered successful. A higher write concern ensures stronger data durability by requiring the write to reach a majority of nodes, thereby preventing data loss in the event of a primary failure. This highlights MongoDB's philosophy of allowing developers to choose the right balance between write latency and data safety based on specific application requirements.

Answer

It guarantees that all reads are always from the primary.

Answer

It automatically enables sharding across regions.

Answer

It forces every node to process every write request.

Question 16

Which of the following describes the 'schema-less' nature of MongoDB?

Accepted Answer

Documents in a collection can have varying fields.. Schema-less means that MongoDB does not require an explicit definition of data structures before inserting data. This flexibility allows different documents in the same collection to have entirely different sets of fields. It is a fundamental feature that empowers developers to experiment and evolve their applications in real-time without the overhead of disruptive migrations, which is a significant advantage over traditional relational databases that require rigid DDL statements.

Answer

The database cannot store data if it doesn't have a template.

Answer

The database does not support data types for fields.

Answer

Indexes can only be created on fields that exist in all documents.

Question 17

Which TWO of the following are benefits of the MongoDB 'document' model over the traditional 'relational' model?

Accepted Answer

Built-in support for complex, hierarchical data structures.. The document model excels in developer agility and data modeling flexibility. By grouping related data, it optimizes for common access patterns, which enhances read performance by reducing the need for joins. This approach aligns with modern programming paradigms where objects are the primary unit of development, allowing for faster iterations and easier maintenance compared to relational models that require complex schema changes and manual data normalization across multiple tables.

Answer

Requirement for strict normalization of all data.

Answer

Guaranteed consistency through mandatory schema migrations.

Answer

Automatic translation of SQL queries to BSON.

Question 18

How does the 'Replica Set' architecture influence client application design?

Accepted Answer

It enables read distribution across multiple nodes.. Replica sets require the driver to be aware of the topology to perform automatic discovery and routing. Since a replica set has a primary node for writes and multiple secondaries for reads, the application must manage read preferences and connection strings correctly. Understanding this architecture is crucial for writing resilient applications that can handle failover events without losing connection or experiencing data consistency issues during node promotions.

Answer

Applications must manually hardcode all secondary IP addresses.

Answer

It mandates that all reads must be 'strong' consistency.

Answer

It forces the application to implement custom failover logic.

Question 19

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 20

What is the purpose of the 'OpLog' in a MongoDB Replica Set?

Accepted Answer

It provides a mechanism for asynchronous data replication.. The OpLog (Operations Log) is a capped collection that records all modifications to the data in the database. It is the core component that allows secondary nodes to replicate data from the primary node. By replaying the operations found in the OpLog, secondaries maintain an identical state to the primary. Understanding the OpLog is essential for diagnosing replication lag and ensuring the system is effectively synchronized across all nodes in the cluster.

Answer

It stores user credentials for database authentication.

Answer

It is used for storing index definitions and metadata.

Answer

It acts as a permanent, immutable backup of all data.