Data Processing Data Processing MCQ 2 — Questions and Answers
Question 1: Which data processing technique involves combining data from multiple sources into a unified dataset?
- Data partitioning
- Data integration (Correct answer)
- Data sampling
- Data normalization
Correct answer: Data integration
Data integration merges data from disparate sources into a single coherent dataset for analysis.
Question 2: In ETL pipelines, what does the 'T' step primarily involve?
- Transmitting data to a remote server
- Truncating old records
- Transforming data into the target format (Correct answer)
- Testing data integrity
Correct answer: Transforming data into the target format
The Transform step in ETL converts raw extracted data into the format required by the destination system.
Question 3: What is a 'data pipeline' in the context of data processing?
- A physical cable used to transfer data between servers
- A series of automated steps that move and transform data from source to destination (Correct answer)
- A backup mechanism for database records
- A compression algorithm for large files
Correct answer: A series of automated steps that move and transform data from source to destination
A data pipeline is an automated sequence of processes that ingests, processes, and delivers data to a target system.
Question 4: Which of the following best describes 'data deduplication'?
- Encrypting duplicate copies of sensitive data
- Identifying and removing redundant copies of data (Correct answer)
- Creating duplicate backups for fault tolerance
- Splitting datasets into equal partitions
Correct answer: Identifying and removing redundant copies of data
Data deduplication eliminates redundant copies of data to reduce storage usage and improve data quality.
Question 5: What is the purpose of data profiling in a data processing workflow?
- Encrypting data before storage
- Analyzing data to understand its structure, content, and quality (Correct answer)
- Compressing data to reduce file sizes
- Partitioning data across multiple nodes
Correct answer: Analyzing data to understand its structure, content, and quality
Data profiling examines datasets to assess quality, identify anomalies, and understand structural characteristics.
Question 6: In stream processing, which characteristic distinguishes it from batch processing?
- Stream processing only handles structured data
- Stream processing analyzes data continuously as it arrives in real time (Correct answer)
- Stream processing requires more storage than batch processing
- Stream processing is slower but more accurate
Correct answer: Stream processing analyzes data continuously as it arrives in real time
Stream processing handles data records continuously and in real time as they arrive, unlike batch processing which waits to accumulate data.
Question 7: What is 'data masking' used for in data processing?
- Hiding processing errors from end users
- Replacing sensitive data with realistic but fictitious values (Correct answer)
- Compressing data during network transmission
- Encrypting database indexes
Correct answer: Replacing sensitive data with realistic but fictitious values
Data masking replaces sensitive information with anonymized values to protect privacy while preserving data format and usability.
Data Processing Data Processing MCQ 2
Which data processing technique involves combining data from multiple sources into a unified dataset?