WorksheetsNoSQL Database Quiz
Total questions: 15
Worksheet time: 11mins
ACID properties are primarily associated with which type of database transactions?
NoSQL databases
Graph databases
Document databases
Relational databases
BASE properties are often preferred over ACID properties in scenarios prioritizing:
High availability and eventual consistency
Complex joins
Strict consistency
Strong integrity
What is the primary purpose of database sharding?
To improve data integrity
To enforce ACID properties
To reduce data redundancy
To achieve horizontal scalability
Brewer's CAP theorem states that a distributed system cannot simultaneously guarantee which three properties?
Consistency, Atomicity, Partition Tolerance
Consistency, Atomicity, Durability
Consistency, Availability, Durability
Consistency, Availability, Partition Tolerance
Which of the following is a key characteristic of 'Big Data'?
Low velocity, low volume, low variety
High volume, velocity, variety
Static data only
Primarily small, structured datasets
Which layer of the Big Data stack is NoSQL primarily associated with?
Data Storage and Processing
Application Layer
Data Analysis and Visualization
Data Ingestion
The shift from vertical scaling to horizontal scaling in databases is often driven by the need to handle:
Stronger ACID guarantees
Smaller datasets
Reduced query complexity
Massive data growth and high traffic
What is the primary benefit of 'moving queries to data, not data to the query' in a distributed NoSQL system?
Decreased network latency and increased efficiency
Stronger ACID guarantees
Simplified data modeling
Reduced need for replication
Replication in NoSQL databases is primarily used to achieve:
Reduced storage space
Scalability for reads and high availability
Centralized data management
Strict serializable isolation
When a query is distributed across multiple data nodes in a NoSQL system, what is generally happening?
Only the primary node executes the query.
The entire dataset is moved to a single node for processing.
Each node processes a portion of the query on its local data.
All data is replicated to every node for faster access.
An aggregate in the context of NoSQL data modeling typically refers to:
A single table with multiple foreign keys.
A collection of related data that is often accessed and updated together.
A complex SQL query result.
A distributed transaction involving multiple nodes.
What is the fundamental concept behind a key-value database?
Data is accessed by a unique key that maps to a corresponding value.
Data is represented as nodes and edges in a graph.
Data is stored in tables with rows and columns.
Data is organized as documents with flexible schemas.
What is the fundamental unit of data storage in a document-oriented database?
A graph node
A row
A document
A table
Which of the following is a key advantage of document-oriented databases?
Support for complex, multi-table joins.
Strict ACID compliance for all transactions.
Rigid schema enforcement.
Flexible schema, allowing for varied document structures.
What is a 'Capped Collection' in MongoDB primarily used for?
Storing high-volume, frequently updated data (e.g., logs, events) in a fixed-size collection that overwrites oldest entries.
Storing data that is read-only.
Storing fixed-size documents.
Ensuring strong consistency across all replicas.
