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 columns and formulas
B.As rows and joins
C.As nodes and edges
D.As key-value pairs
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.Looking up a key
B.Grouping several columns
C.Traversing an edge
D.Joining two tables
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 columns
B.By documents
C.By objects
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.Document
B.Table
C.Cell
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.Collection
B.Vertex
C.Relation
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.Rows and columns
B.Files and folders
C.Keys and values
D.Nodes and edges
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.Creating relational joins
B.Converting BSON to XML
C.Providing data redundancy
D.Designing user interfaces
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.Removing indexes from documents
B.Combining collections into tables
C.Encrypting data before storage
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 paid visualization service
B.A relational database extension
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 Compass
B.MongoDB Server
C.MongoDB Shell
D.MongoDB Driver
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 desktop operating system
B.A document conversion format
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 guarantees stronger consistency than every SQL database
B.It supports flexible schemas for evolving records
C.It automatically normalizes data into related tables
D.It requires every record to share identical columns
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.Vertical scaling through faster processors
B.Horizontal scaling through data partitioning
C.Serialization through stored procedures
D.Normalization through foreign-key constraints
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 document database without transaction controls
C.A key-value database with independent item writes
D.A relational SQL database with ACID transactions
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.Normalize every attribute into a separate table
B.Store each profile as one embedded document
C.Represent every attribute as a graph vertex
D.Store each field on an unrelated database server
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 moves the document into another collection
C.MongoDB adds the field with null to every document
D.MongoDB rejects it until the collection is recreated
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 _key field
B.The _index field
C.The _pk field
D.The _id 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 partition tolerance
B.Consistency and unrestricted availability
C.Availability and single-node durability
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.Availability and partition tolerance over immediate consistency
B.Consistency and partition tolerance over request availability
C.Consistency and availability without partition tolerance
D.Durability and isolation over horizontal scalability
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 graph database
B.A column-oriented database
C.A relational database
D.A key-value 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 must always be numeric scalar values
B.Records must be joined before fields are searched
C.Keys cannot contain letters or special characters
D.Values are primarily accessed through their keys
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 follows graph edges between salary values
B.It stores every employee as one binary document
C.It duplicates every row across all available nodes
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.Updating one shopping cart by a known token
B.Traversing several levels of social relationships
C.Aggregating selected metrics across billions of events
D.Loading complete records for individual user sessions
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.Create a graph vertex for every item property
B.Embed the line items inside the order document
C.Place each item attribute in a separate collection
D.Store each line item under an unrelated random key
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.Represent book fields as fixed relational columns
B.Store all books as one serialized string value
C.Embed every book inside the publisher document
D.Store books separately and reference the publisher
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 retrieves every entity using only one fixed key
B.It guarantees that all entities use an identical schema
C.It efficiently traverses relationships between connected entities
D.It stores each property in a separate compressed column
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?
C.The application must rebuild all indexes manually
D.An eligible secondary can be elected as primary
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 mongos query router
B.The MongoDB Compass client
C.The mongod storage journal
D.The replica-set arbiter
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.find({ active: true })
B.db.users.updateMany({ active: true })
C.db.users.deleteMany({ active: true })
D.db.users.insertOne({ 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 aggregation pipeline history
C.The network access IP allowlist
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.Use a flexible schema with horizontally scalable writes
D.Require distributed transactions for every event
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 relational database is a strong default because integrity is central
B.A key-value database is ideal because transactions are unnecessary
C.A graph database is mandatory because orders form relationships
D.A document database is always superior because joins are avoided
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 prevents indexes on fields absent from some documents
B.Documents may vary, but application-level validation may still be added
C.MongoDB automatically converts every field into a relational column
D.Every document must contain the same fields and data types
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.Availability over consistency
C.Consistency over availability
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.Strong consistency and availability cannot both be guaranteed during a partition
B.Clustering automatically eliminates the CAP trade-off
C.Availability guarantees require abandoning consistency at all times
D.Partition tolerance is irrelevant when replicas are used
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.Column storage grouped by analytical dimensions
B.Document storage requiring predicates on nested fields
C.Key-value storage with session identifiers as keys
D.Graph storage with users as vertices
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 removes the need for partitioning and query planning
C.It can read only required columns and compress similar values
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.Scanning selected attributes across billions of events
B.Computing daily aggregates over historical measurements
C.Compressing repetitive categorical dimensions for reports
D.Updating individual customer profiles on every request
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.Continue embedding because fewer documents are always better
B.Reference or bucket readings to control document growth
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.Column storage partitioned only by transaction date
B.Key-value storage with one record per account
C.Document storage with all entities embedded in one record
D.Graph storage with typed vertices and relationships
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
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 config server replica set
B.The mongos query router
C.The primary member of each shard
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.Every secondary must have identical application connection strings
B.A majority of voting members must be able to form a quorum
C.The disconnected primary must approve its replacement
D.All clients must first reconnect through Compass
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.Check the configured data path, permissions, and startup logs
B.Delete the database files and reinstall the shell
C.Change every collection to use a unique index
D.Create a Compass connection before starting the server
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.The shell requires Compass to create a server process
B.The database must first be deployed to MongoDB Atlas
C.MongoDB collections cannot be accessed from localhost
D.The shell is a client and does not start mongod automatically
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.Translate the filter and update into mongosh commands
B.Rely on Compass history without exporting any commands
C.Copy the collection into a spreadsheet before deployment
D.Record only the visible documents returned by Compass
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?
Introduction to MongoDB Shell and Compass
Hard
A.Compass stores dates as strings while mongosh rejects all dates
B.MongoDB supports dates only through graphical clients
C.The shell command used a string instead of a BSON Date value
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 number of fields in each MongoDB document
B.The application server's IP access list and network path
C.The local shell's command history
D.The Compass theme selected by the developer
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 →