Whenever you're ready, walk me through how you'd approach this.
What strategies do you use for optimizing query performance in large-scale data warehouses?