Skip to content

CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation

Which of the following data sets is an example of structured data suited to storage in a relational database?

General ledger entries with fixed columns for date, account code, debit and credit are structured data because they follow a predefined row-and-column format. Scanned images, audio recordings and free-text social media comments lack a fixed schema and are unstructured.

  1. AScanned images of supplier invoices
  2. BAudio recordings of investor conference calls
  3. CGeneral ledger entries with fixed columns for date, account code, debit and creditCorrect
  4. DFree-text comments posted by customers on social media

Explanation

Structured data follows a predefined format of rows and columns with defined data types, as in ledger entries. Images, audio and free text have no fixed tabular schema and are unstructured data.

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.

Practise Data Processing, Organisation, Cleaning and ValidationFree diagnostic mock

More Data Processing, Organisation, Cleaning and Validation questions