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)
- FoundationThree collection nodes each produce 2 000 records per minute. How many records in 5 minutes?
- FoundationThose 30,000 records are 300 bytes each. What is the total in MB (1 decimal place)?
- Foundation500 GB is split evenly across 8 storage nodes. How much does each node hold?
- 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)?
- IntermediateAfter de-duplication 850 000 of 1 000 000 records remain. What is the duplication rate?
- IntermediateWith a 4 to 1 compression ratio, what does a 12 GB file become?
- ChallengeA pipeline moves 600 MB per minute. What is the rate in MB per second?
- ChallengeThe same query drops from 20 seconds to 4 seconds. By what percentage did the time fall?
- Error redoError check: a system handles 5 000 records per second with a 200 ms response per record. Which figure describes throughput?
- 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.



