Data Processing Data Processing MCQ 3

Question 1

Which indexing strategy is most effective when queries frequently filter on multiple columns together?

Accepted Answer

Composite index

Answer

A composite (multi-column) index covers multiple columns in a single index structure, speeding up queries that filter on those columns together.

Question 2

What does 'data lineage' track in a data processing system?

Accepted Answer

The origin, movement, and transformation history of data

Answer

Data lineage records the complete journey of data — where it came from, how it was transformed, and where it moved.

Question 3

A company processes 500 GB of log files every night. Which processing model is most appropriate?

Accepted Answer

Batch processing

Answer

Batch processing is ideal for large volumes of data accumulated over a period and processed at scheduled intervals, such as nightly log analysis.

Question 4

What is the role of a 'message broker' like Apache Kafka in data processing architectures?

Accepted Answer

It acts as an intermediary that decouples data producers and consumers, managing data streams

Answer

A message broker like Kafka decouples producers from consumers, buffering and routing data streams reliably between systems.

Question 5

Which format is most commonly used for data exchange in modern REST APIs due to its human-readable structure?

Accepted Answer

JSON

Answer

JSON (JavaScript Object Notation) is the dominant format for REST API data exchange because it is human-readable and natively supported in web environments.

Data Processing Practice Test

Data Processing Practice Test

Data Processing Data Processing MCQ 3