Whenever you're ready, walk me through how you'd approach this.
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.