1.Questions based on complex SQL queries and data warehousing and some ETL related question.
Sigiloso
Knowledge of rank and partitioning helped a lot while answering the questions. Good knowledge of Joins is mandatory. Brush up data warehousing concepts as well.