Pergunta de entrevista da empresa Dell Technologies

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