Your question is Optimize High-Throughput Systems. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
How would you optimize query performance, memory usage, and disk I/O for high-throughput systems?
Treat this as a practical pipeline-engineering exercise. Explain how you would diagnose bottlenecks, select indexes and partitioning strategies, reduce unnecessary scans and data movement, manage memory pressure, and validate improvements using measurable observability signals.