Data Processing Data Storage and Retrieval 2

Question 1

What is RAID in the context of data storage?

Accepted Answer

Redundant Array of Independent Disks — a method of combining multiple drives for redundancy or performance

Answer

Real-time Automated Indexing Daemon for fast data retrieval

Answer

Remote Access Integrated Database for distributed systems

Answer

Replicated Archive for Indexed Data storage

Question 2

What is the purpose of data archiving?

Accepted Answer

Moving infrequently accessed data to lower-cost storage for long-term retention

Answer

Deleting old data to free up disk space

Answer

Encrypting production data for compliance

Answer

Compressing active databases during business hours

Question 3

What is a B-tree index?

Accepted Answer

A balanced tree data structure used by databases to enable fast data lookups and range queries

Answer

A binary backup format for database tables

Answer

A branching diagram showing database relationships

Answer

A compressed storage format for text data

Question 4

What does 'data tiering' mean in storage management?

Accepted Answer

Automatically moving data between different storage classes based on access frequency and cost

Answer

Organizing database tables into logical groups by department

Answer

Encrypting data at multiple security levels

Answer

Creating multiple backups in different geographic locations

Question 5

What is a hash index in database storage?

Accepted Answer

An index that uses a hash function to map keys directly to storage locations for O(1) equality lookups

Answer

An index sorted alphabetically by hash values

Answer

A compressed index used only for text search

Answer

An index that stores only the last 10% of rows in a table

Question 6

What is eventual consistency in distributed data storage?

Accepted Answer

A model where all replicas will eventually converge to the same value given no new updates

Answer

A guarantee that all replicas are always identical at every moment

Answer

A storage strategy that prioritizes speed over durability

Answer

A backup policy that runs nightly to sync all nodes