CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation
A finance team at an Indian NBFC enters customer ages into a loan-origination form. The form rejects any entry below 18 or above 75. Which data validation technique is being applied?
The technique is a range check. It verifies that a numeric value falls between set lower and upper limits, here 18 and 75 years, and rejects anything outside. Format checks test patterns, duplicate checks test repetition, and referential checks test links to master records.
- ARange checkCorrect
- BDuplicate check
- CFormat check
- DReferential integrity check
Explanation
A range check tests whether a numeric value lies between a defined minimum and maximum. Here ages outside 18-75 are rejected, so it is a range check. A format check would instead test the pattern of the entry, such as the number of characters.
Did you get it right without looking?
One question tells you little. A timed set on Data Processing, Organisation, Cleaning and Validation shows your real accuracy, how long you take and where you lose marks.
More Data Processing, Organisation, Cleaning and Validation questions
- A company keeps its sales invoices in a table where Invoice No. is unique for each row. A separate Customer table has Customer ID as its uni…
- A finance team receives sales data in which the 'Region' column holds 'North', 'north' and 'NORTH ' (with a trailing space) for the same reg…
- In the context of data processing, the term 'data preparation' mainly refers to which activity?
- A finance team at an Indian retail company finds that the customer-master file lists 'Ravi Sharma, Mumbai' twice with identical PAN, phone n…
- Which of the following data sets is an example of structured data suited to storage in a relational database?
- A finance team stores each customer as one row, with columns for Customer ID, Name, Credit Limit and Region. In the language of data organis…