CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation
In the context of data processing, the term 'data preparation' mainly refers to which activity?
Data preparation means checking, cleaning and formatting raw data before it is entered into the system for processing. It removes errors and inconsistencies early, whereas reporting is output, archiving is storage and calculation is processing.
- APresenting final reports to management
- BChecking, cleaning and formatting raw data before it is entered for processingCorrect
- CArchiving processed data in a secure database
- DCalculating totals from the processed data
Explanation
Preparation comes before input and involves editing, validating and organising raw data so it is accurate and usable. Reporting is output, archiving is storage, and calculating totals is processing.
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 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…
- A bank branch updates customer account balances only at the end of the day by running all the day's accumulated cheque and deposit entries t…
- A firm's database holds Sales (Order ID, Product ID, Product Name, Product Price, Quantity). Product Name and Product Price repeat on every …
- An analyst fills missing values in a column of monthly expenses (Rs thousand) using the mean of the available values: 20, 30, 40, 50 and two…