Medpace interview question

SQL, SSIS and dimensional modelling concepts