Data Warehousing Interview Questions

Data Warehousing interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. In Star Schema Dimension tables are:

A. Short and Fat

B. Long and Thin

C. Long and Fat

D. Short and thin

Correct Answer is : Short and Fat

2. The data in Data Warehouse is generally

A. Clean Data

B. Dirty Data

C. Clean and Dirty Data

D. None of above

Correct Answer is : Clean Data

3. In which type of SCD(Slowly changing dimensions) do we preserve history of data:

A. Type One

B. Type Two

C. Type Three

D. None of above

Correct Answer is : Type Two

4. During ETL load we generally have

A. Unsorted data for Aggregator

B. Sorted data for Aggregator

C. Does not matter if we use Sorted or Unsorted data for Aggregation

Correct Answer is : Sorted data for Aggregator

5. Sequence of jobs to load data in to warehouse

A. First load data into fact tables then dimension tables, then Aggregates if any

B. First load data into dimension tables, then fact tables, then Aggregates if any

C. First Aggregates then load data into dimension tables, then fact tables

D. Does not matter if we load either of fact, dimensions, or aggregates

Correct Answer is : First load data into dimension tables, then fact tables, then Aggregates if any

Data Warehousing interview questions