Data Warehouse Interview Questions | Glassdoor

Data Warehouse Interview Questions

68

Data warehouse interview questions shared by candidates

Top Interview Questions

Sort: Relevance Popular Date

What's 5/2 in MySQL ?

4 Answers

2.5 is wrong according to MySpace

may they expect it to be 2.5000 ?

5/2 = 2 it will assume integer division

Open ended questions and deliberately vague to draw out your questions.

1 Answer

partitioning types

1 Answer

Multiple data architecture questions including data model for a retail/order fulfilling system.

1 Answer

How do you expand an existing Microsoft infrastructure to support going forward a 20TB+ Data Warehouse.

1 Answer

Write the sql for finding the two most populous cities per state in the two tables city and state.

1 Answer

Are you familiar with the Kimball methodology for data warehousing?

1 Answer

what is the template for initial ETL package I would create

1 Answer

Went through a series of choice A or B style questions...for example, paper or plastic? Some were applicable, others were just silly.

1 Answer

What is dimension and fact ?

1 Answer
110 of 68 Interview Questions