Core data concepts

Review questions

Integrated summary: Core data concepts

Classify a dataset by inspecting each record's fields and their stability. A JSON file may contain optional keys; sharing a container does not impose one fixed schema. Images and free text can be stored and retrieved, but file count cannot reveal how often a term appears inside content before extraction and accuracy review. Choose storage from the unit of reading and change: an object suits an image opened by ID, while an operational database manages mutable order state under constraints. Link them by a checked identifier without making one service perform both jobs. Preventing a double sale is a concurrent operational decision; aggregating sales over months is a historical analytical question. When a report count differs, trace source, ingestion, transformation, model and visual counts. Investigate the first divergence. A visual filter matters when the model is complete, while a dropping transformation matters when the model is already short. A duplicate scan is not a new arrival; a cancelled booking should not silently enter a valid-booking denominator. The database role checks source records and access, the data engineer checks transformation rules, and the analyst checks metric definitions. End with an explicit evidence boundary: unextracted image contents and unverified arrivals cannot become reported facts.

File formats and lineage add a practical check to the choice: neither a CSV nor JSON suffix proves schema validity. Define record grain, field types and key uniqueness, then reconcile input and output counts. A replayed payment_id must not be summed twice before event identity is checked. The engineer records transformation version and rejected counts, while the analyst defines the measure denominator; operating a database alone cannot determine report meaning.

Review questions

Test your understanding with these questions. Marking and saved results are available with a free account.

  1. Question 1In a training scenario, a JSON feed has ten events: seven contain device_id and three do not. Which conclusion is supported?
  2. Question 2There are 30 scanned paper forms whose filenames contain only numbers. A manager asks how many scans mention a particular medicine. What can be reported before text extraction?
  3. Question 3A fictional centre has 40 CSV tickets with fixed ticket_id and category fields, ten JSON events of which seven contain device_id, and six untranscribed audio calls. The manager asks for category distribution, device-event count, and outage-call count. Which report respects the evidence?
  4. Question 4Branches send one sale per row with identical order_id, amount and date columns. Classify the amount representation. Which choice best fits?
  5. Question 5An app changes order status twice as events happen and opens proof images through an API. Which initial split fits the work?
  6. Question 6An order app saves the order first, then the receipt-image upload fails during a network interruption. Which conclusion about the resulting state is correct?
  7. Question 7A reconciliation finds 200 shipment records, 190 valid attachment links and 12 files with no linked record. What is the appropriate step before deleting the 12 files?
  8. Question 8A gate records 56 arrived valid bookings out of 70 valid bookings, plus one duplicate scan. What is valid-booking attendance?
  9. Question 9A daily report closed with 60 eligible reservations and 48 attendances; then a pre-appointment cancellation and one duplicate attendance arrive. What is the corrected rate?
  10. Question 10A gate worker sees ticket state at 09:00 while the attendance report refreshes at 06:00 the next morning. What rejects a repeated entry?
  11. Question 11Source, pipeline and model each hold 90 successful payments; a Power BI visual shows 72 because it filters web and excludes 18 mobile. Who leads the first discrepancy check?
  12. Question 12The source holds 200 successful purchases, the analytical copy holds 180, and no database write error appears. Who leads the first discrepancy check?
  13. Question 13A data engineer notices that status=returned is wrongly shown as completed in a measure. What is the correct action?
  14. Question 14Branches send 500 rows daily with three fixed fields for a row-oriented review. Which choice best fits?
  15. Question 15The same payment_id and amount arrived again after a network interruption. Which choice best fits?