Whenever you're ready, walk me through how you'd approach this.
Describe a time you had to troubleshoot a performance bottleneck in a production data environment. Focus on how you identified the bottleneck, prioritized possible causes, collaborated with affected stakeholders, and decided on a solution. Explain the trade-offs you considered, how you validated the fix, and what you did to prevent the issue from recurring. Use a specific example and structure your response with Situation, Task, Action, and Result.