You've learned about ETL workflows and how batch processing differs from stream processing. Now let's practice identifying which approach fits different real-world scenarios.
Engagement Message
Ready to become a processing pattern expert?
Type
Multiple Choice
Practice Question
A retail company wants to generate monthly sales reports for executive review. They need to analyze three months of transaction data, calculate trends, and produce formatted reports. Which processing approach is most suitable?
A. Stream processing for real-time insights B. Batch processing for comprehensive analysis C. Hybrid approach combining both methods D. Manual processing without automation
Suggested Answers
- A
- B - Correct
- C
- D
Type
Sort Into Boxes
Practice Question
Sort these use cases into the correct processing pattern:
Labels
- First Box Label: Batch ETL
- Second Box Label: Stream Processing
First Box Items
- Payroll calculation
- Annual reporting
- Data warehouse
Second Box Items
- Credit card fraud
- Live dashboard
- Chat notifications
Type
Swipe Left or Right
Practice Question
Match each ETL phase with its primary activities:
Labels
- Left Label: Extract Phase
- Right Label: Transform Phase
Left Label Items
- Reading CSV files from FTP servers
- Connecting to database APIs
- Importing data from cloud storage
- Collecting logs from web servers
Right Label Items
- Removing duplicate customer records
- Calculating sales totals by region
- Joining customer and order tables
- Converting date formats
Type
Multiple Choice
Practice Question
A streaming music service needs to update user recommendations as they listen to songs. They want to adjust playlists based on current listening patterns within seconds. What processing approach should they use?
A. Batch processing every hour to update recommendations B. Stream processing to update recommendations in real-time C. Daily batch processing to recalculate all recommendations D. Weekly batch processing to refresh recommendation models
Suggested Answers
- A
- B - Correct
- C
- D
Type
Fill In The Blanks
Markdown With Blanks
Fill in the blanks about processing latency requirements:
[[blank:Batch]] processing has high latency but handles large volumes efficiently, while [[blank:Stream]] processing has low latency but requires more complex infrastructure.
Suggested Answers
- Batch
- Stream
- Manual
- Hybrid
Type
Multiple Choice
Practice Question
Which scenario demonstrates the Transform phase of ETL most clearly?
A. Downloading customer data from a CRM system B. Calculating customer lifetime value from purchase history C. Storing processed data in a data warehouse D. Scheduling the pipeline to run every night
Suggested Answers
- A
- B - Correct
- C
- D
Type
Multiple Choice
Practice Question
A financial institution processes millions of transactions daily. They need immediate fraud detection but also weekly compliance reports. What's the best approach?
A. Use only batch processing for both requirements B. Use only stream processing for both requirements C. Use stream processing for fraud detection and batch processing for compliance reports D. Use manual processing for fraud detection and automated batch for compliance
Suggested Answers
- A
- B
- C - Correct
- D
