/en-tutor-prep-s5-ict-big-data-analysis-pipeline-practice-2/
/en-tutor-prep-s5-ict-big-data-analysis-pipeline-practice-2/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

S5 ICT Big Data Analysis Pipeline Practice 2 (Advanced)

S5 ICT Big Data Analysis Pipeline Practice 2 (Advanced)

  • 2026-11-18

S5 ICT Big Data Analysis Pipeline Practice 2 (Advanced)

Ten items cover multi-node collection, storage sharding, data-lake growth, duplication rate, compression ratio, transfer rate and query speed-up.

Distributed collection and capacity planning List the known values and units, decide multiply or divide, then check that the magnitude is sensible.

01 Paper details (check answers afterwards)

Item Detail
Questions 10
Suggested time 25
Difficulty mix Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2
Chapter Chapter: S5 ICT: big data analysis pipeline
Level Advanced

02 Questions (10 items)

  1. FoundationThree collection nodes each produce 2 000 records per minute. How many records in 5 minutes?
  2. FoundationThose 30,000 records are 300 bytes each. What is the total in MB (1 decimal place)?
  3. Foundation500 GB is split evenly across 8 storage nodes. How much does each node hold?
  4. FoundationA data lake holds 40 TB and gains 250 GB a day. What is its size after 30 days in TB (1 TB = 1024 GB, 2 decimal places)?
  5. IntermediateAfter de-duplication 850 000 of 1 000 000 records remain. What is the duplication rate?
  6. IntermediateWith a 4 to 1 compression ratio, what does a 12 GB file become?
  7. ChallengeA pipeline moves 600 MB per minute. What is the rate in MB per second?
  8. ChallengeThe same query drops from 20 seconds to 4 seconds. By what percentage did the time fall?
  9. Error redoError check: a system handles 5 000 records per second with a 200 ms response per record. Which figure describes throughput?
  10. Error redoA 0.5 per cent audit sample is taken from 400 million transactions. How many records are sampled?

03 Answers and one-line notes

# Answer One-line note
1 30,000 records. Multiply nodes by records per minute, then by the minutes.
2 9,000,000 bytes, that is 8.6 MB. Multiply for the byte total, then divide by 1 048 576.
3 62.5 GB. Divide the capacity by the number of nodes.
4 47.32 TB. Convert the added volume to TB before adding the original capacity.
5 15 per cent. Divide the duplicate count by the original count and multiply by 100.
6 3 GB. Divide the original size by the second number of the ratio.
7 10 MB per second. Divide the per-minute rate by 60.
8 80 per cent. Divide the saving by the original time and multiply by 100.
9 5 000 records per second. Throughput is work done per unit time; 200 ms is the latency.
10 2,000,000 records. Half a per cent is five per thousand; multiply then keep the whole number.

04 What to do after marking

  • After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
  • Repeat the same item two days later; move to the next paper only when both attempts are correct.
  • Parents only need the answer and note columns; there is no need to explain every item.

Download the full ten-item paper as a PDF, answers and notes included.Tutor Registration →

Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →