Question 29
Scenario 3: E-commerce Platform Log Analysis
You're analyzing Apache access logs from a major e-commerce platform. The logs contain customer browsing patterns, purchase behaviors, and system performance metrics during Black Friday sales.
Log Format Specification:
Analysis Requirements:
● Filter purchases (POST to /checkout/) during peak hours (12:00-15:59)
● Identify mobile vs desktop traffic patterns
● Track successful transactions (status codes 200-299)
● Analyze product category performance
Based on the above data, answer the given subquestions.
If the transaction count appears unexpectedly high, which systematic debugging approach would identify the root cause?
Assume data corruption and discard results
Validate each filter condition independently: time range → HTTP method → URL pattern → status code
Reduce the dataset size randomly
Check only the timestamp filter