Data Processing Data Validation and Quality 1 — Questions and Answers
Question 1: Which data validation technique checks that a value falls within an acceptable range?
- Range check (Correct answer)
- Format check
- Presence check
- Consistency check
Correct answer: Range check
A range check verifies that a data value falls within a specified minimum and maximum boundary.
Question 2: What is data integrity in the context of data processing?
- Accuracy and consistency of data over its lifecycle (Correct answer)
- Speed of data retrieval
- Size of the database
- Number of records processed
Correct answer: Accuracy and consistency of data over its lifecycle
Data integrity refers to maintaining and assuring the accuracy, consistency, and reliability of data throughout its entire lifecycle.
Question 3: Which type of check verifies that required fields are not left empty?
- Presence check (Correct answer)
- Range check
- Type check
- Length check
Correct answer: Presence check
A presence check (also called a completeness check) ensures that mandatory fields contain a value before processing.
Question 4: What does a format check validate in data processing?
- That data matches an expected pattern or structure (Correct answer)
- That data is within numeric limits
- That data is unique across records
- That data has been backed up
Correct answer: That data matches an expected pattern or structure
A format check ensures that data conforms to a predefined pattern, such as a phone number or date format.
Question 5: Which term describes data that is incorrect, incomplete, or inconsistent?
- Dirty data (Correct answer)
- Clean data
- Normalized data
- Indexed data
Correct answer: Dirty data
Dirty data refers to any data that contains errors, duplicates, missing values, or inconsistencies that reduce its quality and reliability.
Question 6: What is the purpose of a checksum in data validation?
- To detect errors introduced during data transmission or storage (Correct answer)
- To sort records alphabetically
- To compress file sizes
- To encrypt sensitive data
Correct answer: To detect errors introduced during data transmission or storage
A checksum is a calculated value used to verify that data has not been corrupted or altered during transmission or storage.
Data Processing Data Validation and Quality 1
Which data validation technique checks that a value falls within an acceptable range?