Alpaca Interview Question

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