Partition tolerance means the system continues operating even when communication between network nodes is disrupted.
Incorrect! Try again.
9How does a key-value database primarily store data?
Key-value databases
Easy
A.As key-value pairs
B.As columns and formulas
C.As nodes and edges
D.As rows and joins
Correct Answer: As key-value pairs
Explanation:
A key-value database associates each unique key with a corresponding value.
Incorrect! Try again.
10Which operation is fundamental to retrieving data from a key-value database?
Key-value databases
Easy
A.Joining two tables
B.Looking up a key
C.Grouping several columns
D.Traversing an edge
Correct Answer: Looking up a key
Explanation:
Values in a key-value database are commonly retrieved by looking up their associated keys.
Incorrect! Try again.
11How does a column-oriented database primarily organize data?
Column-oriented databases
Easy
A.By objects
B.By documents
C.By columns
D.By graphs
Correct Answer: By columns
Explanation:
A column-oriented database stores and processes data primarily by columns rather than complete rows.
Incorrect! Try again.
12Which workload commonly benefits from column-oriented storage?
Column-oriented databases
Easy
A.Image editing
B.File compression
C.Graph traversal
D.Analytical queries
Correct Answer: Analytical queries
Explanation:
Column-oriented storage is well suited to analytical queries that process selected columns across many records.
Incorrect! Try again.
13What is the basic data unit in a document database?
Document databases
Easy
A.Cell
B.Document
C.Table
D.Edge
Correct Answer: Document
Explanation:
A document database stores each record as a document containing fields and values.
Incorrect! Try again.
14What is a group of MongoDB documents called?
Document databases
Easy
A.Relation
B.Collection
C.Vertex
D.Worksheet
Correct Answer: Collection
Explanation:
MongoDB organizes related documents into a collection.
Incorrect! Try again.
15Which elements are central to a graph database?
Graph databases
Easy
A.Nodes and edges
B.Files and folders
C.Keys and values
D.Rows and columns
Correct Answer: Nodes and edges
Explanation:
Graph databases represent entities as nodes and relationships between them as edges.
Incorrect! Try again.
16What is the main purpose of a MongoDB replica set?
MongoDB Architecture
Easy
A.Converting BSON to XML
B.Providing data redundancy
C.Designing user interfaces
D.Creating relational joins
Correct Answer: Providing data redundancy
Explanation:
A replica set maintains multiple copies of data to support redundancy and high availability.
Incorrect! Try again.
17What is sharding in MongoDB?
MongoDB Architecture
Easy
A.Combining collections into tables
B.Encrypting data before storage
C.Removing indexes from documents
D.Distributing data across servers
Correct Answer: Distributing data across servers
Explanation:
Sharding distributes data across multiple servers to support large datasets and higher workloads.
Incorrect! Try again.
18What is MongoDB Community Edition?
Installing MongoDB Community Edition
Easy
A.A relational database extension
B.A paid visualization service
C.A cloud-only backup tool
D.A free MongoDB distribution
Correct Answer: A free MongoDB distribution
Explanation:
MongoDB Community Edition is the free, self-managed distribution of MongoDB.
Incorrect! Try again.
19Which MongoDB tool provides a graphical interface for exploring data?
Introduction to MongoDB Shell and Compass
Easy
A.MongoDB Driver
B.MongoDB Server
C.MongoDB Compass
D.MongoDB Shell
Correct Answer: MongoDB Compass
Explanation:
MongoDB Compass provides a graphical interface for viewing, querying, and managing MongoDB data.
Incorrect! Try again.
20What is MongoDB Atlas?
MongoDB Atlas Cloud Overview
Easy
A.A document conversion format
B.A desktop operating system
C.A managed cloud database service
D.A local command-line interface
Correct Answer: A managed cloud database service
Explanation:
MongoDB Atlas is a managed cloud service for deploying and operating MongoDB databases.
Incorrect! Try again.
21An online platform stores user profiles whose attributes vary significantly between users and change frequently. Why might a NoSQL database be suitable for this workload?
Introduction to NoSQL Databases
Medium
A.It requires every record to share identical columns
B.It guarantees stronger consistency than every SQL database
C.It supports flexible schemas for evolving records
D.It automatically normalizes data into related tables
Correct Answer: It supports flexible schemas for evolving records
Explanation:
Many NoSQL databases allow records to have different fields, making them suitable for rapidly evolving and heterogeneous data.
Incorrect! Try again.
22A web service must distribute a rapidly growing dataset across several commodity servers. Which NoSQL capability most directly supports this requirement?
Introduction to NoSQL Databases
Medium
A.Normalization through foreign-key constraints
B.Horizontal scaling through data partitioning
C.Serialization through stored procedures
D.Vertical scaling through faster processors
Correct Answer: Horizontal scaling through data partitioning
Explanation:
NoSQL systems commonly partition data across multiple servers, allowing capacity and throughput to grow by adding nodes.
Incorrect! Try again.
23A banking system processes transfers that must update several related accounts atomically and enforce strict relational constraints. Which database approach is generally the most natural fit?
Comparison: SQL vs. NoSQL
Medium
A.A graph database with eventually consistent edges
B.A relational SQL database with ACID transactions
C.A document database without transaction controls
D.A key-value database with independent item writes
Correct Answer: A relational SQL database with ACID transactions
Explanation:
Relational databases are a natural choice when multi-table transactions, strict consistency, and referential constraints are central requirements.
Incorrect! Try again.
24An application repeatedly reads complete customer profiles, including addresses and preferences, but rarely queries those components independently. Which design is most appropriate?
Comparison: SQL vs. NoSQL
Medium
A.Represent every attribute as a graph vertex
B.Store each field on an unrelated database server
C.Normalize every attribute into a separate table
D.Store each profile as one embedded document
Correct Answer: Store each profile as one embedded document
Explanation:
Embedding related data that is usually accessed together can reduce joins and allow the application to retrieve a profile in one operation.
Incorrect! Try again.
25A MongoDB collection contains product documents with different optional specifications. What happens when a new document includes a field that earlier documents do not have?
Overview of MongoDB
Medium
A.MongoDB can store it without altering every document
B.MongoDB rejects it until the collection is recreated
C.MongoDB adds the field with null to every document
D.MongoDB moves the document into another collection
Correct Answer: MongoDB can store it without altering every document
Explanation:
MongoDB collections use a flexible document model, so documents in the same collection may contain different fields.
Incorrect! Try again.
26In a MongoDB document, which field serves as the required unique identifier within a collection?
Overview of MongoDB
Medium
A.The _id field
B.The _pk field
C.The _key field
D.The _index field
Correct Answer: The _id field
Explanation:
Every MongoDB document requires an _id value that uniquely identifies it within its collection.
Incorrect! Try again.
27During a network partition, a distributed database rejects some requests rather than return potentially inconsistent data. Which CAP properties is it prioritizing?
CAP Theorem and its trade-offs
Medium
A.Availability and single-node durability
B.Availability and partition tolerance
C.Consistency and unrestricted availability
D.Consistency and partition tolerance
Correct Answer: Consistency and partition tolerance
Explanation:
A CP system preserves consistent results during a partition but may sacrifice availability by rejecting or delaying requests.
Incorrect! Try again.
28A distributed shopping-cart service continues accepting updates on both sides of a network partition and reconciles conflicts later. Which CAP trade-off does this behavior represent?
CAP Theorem and its trade-offs
Medium
A.Consistency and partition tolerance over request availability
B.Availability and partition tolerance over immediate consistency
C.Durability and isolation over horizontal scalability
D.Consistency and availability without partition tolerance
Correct Answer: Availability and partition tolerance over immediate consistency
Explanation:
Continuing to accept requests during a partition prioritizes availability and partition tolerance, while allowing temporary inconsistency.
Incorrect! Try again.
29A gaming service must retrieve a player's session using a unique session token, with no need to query fields inside the session value. Which database model best matches this access pattern?
Key-value databases
Medium
A.A relational database
B.A key-value database
C.A graph database
D.A column-oriented database
Correct Answer: A key-value database
Explanation:
Key-value databases are optimized for direct retrieval when a unique key, such as a session token, is known.
Incorrect! Try again.
30Why is a key-value database usually inefficient for finding all stored values whose internal city field equals Pune?
Key-value databases
Medium
A.Values are primarily accessed through their keys
B.Keys cannot contain letters or special characters
C.Records must be joined before fields are searched
D.Values must always be numeric scalar values
Correct Answer: Values are primarily accessed through their keys
Explanation:
Basic key-value stores optimize lookup by key and may not index or understand fields contained inside opaque values.
Incorrect! Try again.
31An analytics query calculates the average salary from a table containing hundreds of columns but millions of rows. Why can column-oriented storage improve this query?
Column-oriented databases
Medium
A.It duplicates every row across all available nodes
B.It follows graph edges between salary values
C.It stores every employee as one binary document
D.It reads mainly the salary column from storage
Correct Answer: It reads mainly the salary column from storage
Explanation:
Column-oriented storage can scan only the columns required by an analytical query, reducing unnecessary data reads.
Incorrect! Try again.
32Which workload is generally the best match for a column-oriented database?
Column-oriented databases
Medium
A.Aggregating selected metrics across billions of events
B.Updating one shopping cart by a known token
C.Loading complete records for individual user sessions
D.Traversing several levels of social relationships
Correct Answer: Aggregating selected metrics across billions of events
Explanation:
Column-oriented databases are well suited to large analytical scans and aggregations involving a subset of columns.
Incorrect! Try again.
33An order and its line items are normally created, retrieved, and deleted together. In a document database, which model is typically most appropriate?
Document databases
Medium
A.Embed the line items inside the order document
B.Place each item attribute in a separate collection
C.Store each line item under an unrelated random key
D.Create a graph vertex for every item property
Correct Answer: Embed the line items inside the order document
Explanation:
Data with the same lifecycle and access pattern is often embedded so the aggregate can be handled as a single document.
Incorrect! Try again.
34A publisher document refers to thousands of books, and each book is frequently queried and updated independently. Which document-modeling choice is most suitable?
Document databases
Medium
A.Store books separately and reference the publisher
B.Represent book fields as fixed relational columns
C.Embed every book inside the publisher document
D.Store all books as one serialized string value
Correct Answer: Store books separately and reference the publisher
Explanation:
Separate documents are preferable for large, independently accessed entities and avoid an unbounded embedded array.
Incorrect! Try again.
35A fraud-detection system must identify accounts connected through up to four layers of shared devices and transactions. Why is a graph database appropriate?
Graph databases
Medium
A.It stores each property in a separate compressed column
B.It efficiently traverses relationships between connected entities
C.It guarantees that all entities use an identical schema
D.It retrieves every entity using only one fixed key
Correct Answer: It efficiently traverses relationships between connected entities
Explanation:
Graph databases model entities as nodes and relationships as edges, supporting efficient multi-hop traversal.
Incorrect! Try again.
36In a MongoDB replica set, the current primary becomes unavailable. What is the expected response when a majority of voting members can still communicate?
MongoDB Architecture
Medium
A.The config server becomes the permanent primary
B.The application must rebuild all indexes manually
Correct Answer: An eligible secondary can be elected as primary
Explanation:
Replica sets provide failover by electing an eligible secondary as the new primary when a voting majority is available.
Incorrect! Try again.
37In a sharded MongoDB deployment, which component routes a client query to the appropriate shard or shards?
MongoDB Architecture
Medium
A.The MongoDB Compass client
B.The replica-set arbiter
C.The mongod storage journal
D.The mongos query router
Correct Answer: The mongos query router
Explanation:
A mongos process uses cluster metadata to route operations between applications and the relevant shards.
Incorrect! Try again.
38After installing MongoDB Community Edition, a developer can launch mongosh, but the connection to mongodb://localhost:27017 fails. Which check is most appropriate first?
Installing MongoDB Community Edition
Medium
A.Enable sharding on the local database instance
B.Verify that the MongoDB server service is running
C.Recreate every database collection in Compass
D.Create an Atlas organization for the installation
Correct Answer: Verify that the MongoDB server service is running
Explanation:
mongosh is a client, so a local connection requires the MongoDB server process or service to be running and listening on the target port.
Incorrect! Try again.
39A developer wants a repeatable command-line operation that returns active users from the users collection. Which mongosh command is appropriate?
Introduction to MongoDB Shell and Compass
Medium
A.db.users.updateMany({ active: true })
B.db.users.insertOne({ active: true })
C.db.users.find({ active: true })
D.db.users.deleteMany({ active: true })
Correct Answer: db.users.find({ active: true })
Explanation:
The find() method retrieves documents matching the specified filter without modifying the collection.
Incorrect! Try again.
40An Atlas cluster is running, but a developer's local application cannot connect even though the username and password are correct. Which Atlas configuration should be checked first?
MongoDB Atlas Cloud Overview
Medium
A.The Compass color theme setting
B.The network access IP allowlist
C.The aggregation pipeline history
D.The collection document validator
Correct Answer: The network access IP allowlist
Explanation:
MongoDB Atlas permits client connections only from approved network addresses, so the client's IP must be included in the access list.
Incorrect! Try again.
41A rapidly growing application stores user activity events with fields that vary by event type. The application must ingest events from many regions and continue accepting writes during temporary network partitions. Which design most directly reflects a NoSQL motivation?
Introduction to NoSQL Databases
Hard
A.Keep all events on one vertically scaled server
B.Normalize every event into fixed relational tables
C.Require distributed transactions for every event
D.Use a flexible schema with horizontally scalable writes
Correct Answer: Use a flexible schema with horizontally scalable writes
Explanation:
NoSQL systems commonly support flexible data models and horizontal scaling, making them suitable for high-volume, geographically distributed workloads with evolving fields.
Incorrect! Try again.
42An order-processing system requires multi-row constraints, complex joins, and strict serializable transactions across inventory, payment, and shipment records. Which conclusion is most defensible?
Comparison: SQL vs. NoSQL
Hard
A.A graph database is mandatory because orders form relationships
B.A document database is always superior because joins are avoided
C.A key-value database is ideal because transactions are unnecessary
D.A relational database is a strong default because integrity is central
Correct Answer: A relational database is a strong default because integrity is central
Explanation:
Relational databases provide mature support for joins, foreign keys, and strong multi-row transaction guarantees, which directly match the stated requirements.
Incorrect! Try again.
43A MongoDB collection contains customer documents whose optional fields differ by customer type. Which statement best describes the practical implication of this model?
Overview of MongoDB
Hard
A.MongoDB automatically converts every field into a relational column
B.Documents may vary, but application-level validation may still be added
C.Every document must contain the same fields and data types
D.MongoDB prevents indexes on fields absent from some documents
Correct Answer: Documents may vary, but application-level validation may still be added
Explanation:
MongoDB supports flexible document structures. Collections can still use JSON Schema validation and indexes to enforce selected consistency and query requirements.
Incorrect! Try again.
44During a network partition, a distributed database continues returning responses from both sides, but some responses may not reflect the latest write. Which CAP trade-off is being chosen?
CAP Theorem and its trade-offs
Hard
A.Consistency and availability without partition tolerance
B.Consistency over availability
C.Availability over consistency
D.Partition tolerance over availability
Correct Answer: Availability over consistency
Explanation:
When a partition exists, serving responses from both sides preserves availability but can return stale or conflicting data, sacrificing consistency.
Incorrect! Try again.
45A team claims that a database is both highly available and strongly consistent because it is deployed on a cluster. What is the most accurate critique?
CAP Theorem and its trade-offs
Hard
A.Clustering automatically eliminates the CAP trade-off
B.Availability guarantees require abandoning consistency at all times
C.Partition tolerance is irrelevant when replicas are used
D.Strong consistency and availability cannot both be guaranteed during a partition
Correct Answer: Strong consistency and availability cannot both be guaranteed during a partition
Explanation:
CAP concerns behavior during network partitions. A system must choose whether to reject or delay some operations for consistency or continue serving potentially stale results.
Incorrect! Try again.
46A session service retrieves values only by exact session identifier and requires extremely low-latency reads at massive scale. Which data model is the most natural fit?
Key-value databases
Hard
A.Document storage requiring predicates on nested fields
B.Key-value storage with session identifiers as keys
C.Graph storage with users as vertices
D.Column storage grouped by analytical dimensions
Correct Answer: Key-value storage with session identifiers as keys
Explanation:
Key-value databases optimize direct lookup by a unique key and avoid the indexing and query overhead required for arbitrary predicates.
Incorrect! Try again.
47A key-value database is performing poorly because clients frequently need all products matching category, price range, and availability. What is the primary modeling issue?
Correct Answer: The access pattern needs secondary query capabilities
Explanation:
Key-value systems are optimized for key-based access. Frequent filtering on value attributes may require secondary indexes, denormalized keys, or a different database model.
Incorrect! Try again.
48An analytics workload scans several billion records but usually reads only three of hundreds of attributes and aggregates them by time range. Why is a column-oriented design advantageous?
Column-oriented databases
Hard
A.It stores related attributes together for row reconstruction
B.It can read only required columns and compress similar values
C.It removes the need for partitioning and query planning
D.It guarantees serializable transactions across all aggregates
Correct Answer: It can read only required columns and compress similar values
Explanation:
Column-oriented systems reduce I/O by scanning selected columns and often achieve strong compression because values in a column share similar types and distributions.
Incorrect! Try again.
49Which workload is least appropriate for a column-oriented database optimized for analytical scans?
Column-oriented databases
Hard
A.Compressing repetitive categorical dimensions for reports
B.Computing daily aggregates over historical measurements
C.Updating individual customer profiles on every request
D.Scanning selected attributes across billions of events
Correct Answer: Updating individual customer profiles on every request
Explanation:
Frequent point updates across many attributes are generally better suited to row-oriented or document-oriented operational stores than analytical column stores.
Incorrect! Try again.
50A blog application always displays an article together with its author summary and recent comments. The embedded data remains bounded and is updated with the article. Which modeling choice is most appropriate?
Document databases
Hard
A.Use one global document containing all articles and comments
B.Represent each comment as a graph edge without document storage
C.Embed the bounded related data in the article document
D.Store every field in separate documents and join at read time
Correct Answer: Embed the bounded related data in the article document
Explanation:
Embedding keeps frequently co-read, bounded data together and can reduce round trips. Unbounded arrays would require a different design.
Incorrect! Try again.
51A MongoDB document would contain an ever-growing array of millions of sensor readings, while users query readings independently by sensor and time. What is the strongest design correction?
Document databases
Hard
A.Reference or bucket readings to control document growth
B.Continue embedding because fewer documents are always better
C.Duplicate the entire sensor history in each device document
D.Store all readings in one array and index every element
Correct Answer: Reference or bucket readings to control document growth
Explanation:
Unbounded arrays can create oversized documents and inefficient updates. Referencing readings or using bounded time buckets supports independent querying and controlled growth.
Incorrect! Try again.
52A fraud system must repeatedly discover short paths among accounts, devices, cards, and transactions, where relationship types and traversal depth matter. Which model is most suitable?
Graph databases
Hard
A.Document storage with all entities embedded in one record
B.Graph storage with typed vertices and relationships
C.Column storage partitioned only by transaction date
D.Key-value storage with one record per account
Correct Answer: Graph storage with typed vertices and relationships
Explanation:
Graph databases represent relationships explicitly and optimize traversals, making multi-hop fraud and connection analysis more natural than repeated joins or application-side lookups.
Incorrect! Try again.
53A graph database is not automatically the best choice merely because an application contains relationships. Which factor most strongly supports choosing a graph model?
Graph databases
Hard
A.The data can be retrieved only by one immutable identifier
B.Records have independent fields with no relationship-based queries
C.The workload consists mainly of columnar historical aggregation
Graph databases provide their greatest advantage when relationships are first-class data and queries depend on traversing paths of varying length or structure.
Incorrect! Try again.
54In a MongoDB deployment, which component is primarily responsible for routing client operations to the appropriate shards in a sharded cluster?
MongoDB Architecture
Hard
A.The primary member of each shard
B.The config server replica set
C.The mongos query router
D.The MongoDB Compass client
Correct Answer: The mongos query router
Explanation:
mongos receives client requests, consults cluster metadata, routes operations to relevant shards, and merges results when necessary.
Incorrect! Try again.
55A replica set has one primary and two secondaries. The primary becomes unreachable, and the secondaries can communicate with each other. What condition is most important for automatic election of a new primary?
MongoDB Architecture
Hard
A.A majority of voting members must be able to form a quorum
B.All clients must first reconnect through Compass
C.The disconnected primary must approve its replacement
D.Every secondary must have identical application connection strings
Correct Answer: A majority of voting members must be able to form a quorum
Explanation:
Replica-set elections require a majority of voting members. With two reachable members out of three, the remaining nodes can elect a primary.
Incorrect! Try again.
56After installing MongoDB Community Edition, the server process exits immediately when started manually. Which diagnostic action is most appropriate first?
Installing MongoDB Community Edition
Hard
A.Change every collection to use a unique index
B.Create a Compass connection before starting the server
C.Delete the database files and reinstall the shell
D.Check the configured data path, permissions, and startup logs
Correct Answer: Check the configured data path, permissions, and startup logs
Explanation:
mongod commonly exits when its data directory is missing, inaccessible, or misconfigured. Logs and startup output identify the precise configuration or permission failure.
Incorrect! Try again.
57A developer can run the MongoDB shell but receives a connection-refused error when connecting to localhost. Which explanation is most likely?
Installing MongoDB Community Edition
Hard
A.MongoDB collections cannot be accessed from localhost
B.The shell requires Compass to create a server process
C.The shell is a client and does not start mongod automatically
D.The database must first be deployed to MongoDB Atlas
Correct Answer: The shell is a client and does not start mongod automatically
Explanation:
The shell connects to a running MongoDB server. A connection-refused error usually means mongod is stopped or listening on a different host or port.
Incorrect! Try again.
58A developer wants to reproduce a complex Compass filter in an automated deployment script. Which approach best preserves repeatability?
Introduction to MongoDB Shell and Compass
Hard
A.Copy the collection into a spreadsheet before deployment
B.Rely on Compass history without exporting any commands
C.Record only the visible documents returned by Compass
D.Translate the filter and update into mongosh commands
Correct Answer: Translate the filter and update into mongosh commands
Explanation:
mongosh commands can be version-controlled, reviewed, parameterized, and rerun. Compass is useful for exploration, but scripts provide repeatable automation.
Incorrect! Try again.
59A query works in Compass but fails in mongosh because a field contains a date. What is the most likely issue?
B.MongoDB supports dates only through graphical clients
C.The shell command used a string instead of a BSON Date value
D.Compass stores dates as strings while mongosh rejects all dates
Correct Answer: The shell command used a string instead of a BSON Date value
Explanation:
MongoDB distinguishes BSON Date values from strings. In mongosh, dates should be represented with constructors such as ISODate or JavaScript Date when appropriate.
Incorrect! Try again.
60An Atlas cluster is reachable from a developer laptop but not from an application server in the cloud. Which Atlas configuration should be investigated first?
MongoDB Atlas Cloud Overview
Hard
A.The Compass theme selected by the developer
B.The local shell's command history
C.The number of fields in each MongoDB document
D.The application server's IP access list and network path
Correct Answer: The application server's IP access list and network path
Explanation:
Atlas access depends on network authorization and connectivity. The application's source IP, firewall rules, VPC peering or private endpoint settings, and DNS should be checked.
Incorrect! Try again.
Did this save you a night before the exam?
LPU Notes is free, and it stays free. Ads cover part of the server bill.
The rest comes out of a student's own pocket: the domain, the storage,
and keeping the site up through the weeks everyone needs it at once.
The payment button didn't load. An ad blocker or a filtered network is the usual reason.
to try again.
Nothing here is ever locked, and nothing unlocks. Chip in only if it was worth it.
What it pays for →