Question d’entretien chez Dell Technologies

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