Your question is Diagnosing Production Performance Bottlenecks. 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).
Describe a situation where you identified a critical performance bottleneck in a production data system. How did you diagnose and resolve it?
Discuss the pipeline architecture, symptoms, measurements, and diagnostic tools you used. Explain how you isolated the bottleneck, evaluated alternatives, implemented the fix safely, and verified its impact without compromising data quality or reliability.