Pregunta de entrevista de Alpaca

How do you optimize the data warehouse for efficiency? How do you handle missing value?