Data Processing Data Processing MCQ 4

Question 1

What is 'data enrichment' in the context of data processing?

Accepted Answer

Enhancing existing data by appending additional relevant information from external sources

Answer

Data enrichment augments a dataset by adding context or supplementary data from external sources, increasing its analytical value.

Question 2

Which concept describes the ability of a data processing system to handle increasing workloads by adding more machines rather than upgrading existing ones?

Accepted Answer

Horizontal scaling

Answer

Horizontal scaling (scaling out) adds more nodes to a distributed system, while vertical scaling upgrades the capacity of existing machines.

Question 3

What is 'late-arriving data' a challenge in stream processing?

Accepted Answer

Events that arrive after the time window in which they should have been processed

Answer

Late-arriving data occurs when events reach the processing system after their event-time window has already closed, complicating aggregations.

Question 4

In columnar storage formats like Apache Parquet, what is the primary performance advantage over row-based storage?

Accepted Answer

Columnar formats allow faster reads of specific columns without scanning entire rows

Answer

Columnar storage reads only the queried columns from disk, drastically reducing I/O for analytical queries that access a few columns from wide tables.

Question 5

What is the primary purpose of a 'data catalog' in an enterprise data environment?

Accepted Answer

To provide a searchable inventory of available data assets with metadata and lineage information

Answer

A data catalog acts as a centralized registry where users can discover, understand, and govern available data assets across the organization.

Data Processing Practice Test

Data Processing Practice Test

Data Processing Data Processing MCQ 4