Domanda di colloquio di Dell Technologies

How would you optimize a SQL query for performance? How do you ensure data quality in a data pipeline?