Data Processing Computer-Based Test On Data-Processing 3

Question 1

Which algorithm is commonly used to sort large datasets stored on disk (external sorting)?

Accepted Answer

Merge sort

Answer

Merge sort is well-suited for external sorting because it processes data in sequential passes, which minimizes disk I/O.

Question 2

In the context of databases, ACID properties ensure:

Accepted Answer

Reliable transaction processing

Answer

ACID (Atomicity, Consistency, Isolation, Durability) properties guarantee that database transactions are processed reliably.

Question 3

What is the primary purpose of data masking in a processing environment?

Accepted Answer

Protecting sensitive data by replacing it with realistic fictional values

Answer

Data masking substitutes sensitive information with realistic but fictitious data so non-production environments cannot expose real values.

Question 4

A hash table achieves average-case O(1) time complexity for lookups because:

Accepted Answer

It uses a hash function to map keys directly to storage locations

Answer

A hash function computes an index into an array, allowing near-instant access without scanning other elements.

Question 5

In stream processing, a 'tumbling window' differs from a 'sliding window' in that it:

Accepted Answer

Does not overlap — each window is a distinct, non-overlapping interval

Answer

Tumbling windows divide a data stream into fixed, non-overlapping time intervals, while sliding windows can share events between windows.

Data Processing Practice Test