Data Warehouse :: Data Warehouse Developer Job Interview Questions and Answers

Data Warehouse Developer related Frequently Asked Questions by expert members with professional career as Data Warehouse Developer. These list of interview questions and answers will help you strengthen your technical skills, prepare for the new job interview and quickly revise your concepts

1 Explain me why is chameleon method used in data warehousing?
2 Tell us what is Hybrid SCD?
3 Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing?
4 Can you list the Schema that a data warehouse system can implements?
5 Tell us what is Virtual Warehouse?
6 Tell us what does the Query Manager responsible for?
7 Tell us out of star schema and snowflake schema, whose dimension table is normalized?
8 Explain me what kind of costs are involved in Data Marting?
9 Explain me what is the purpose of cluster analysis in Data Warehousing?
10 Tell us what is snapshot with reference to data warehouse?
11 Explain me what is junk dimension?
12 Please explain what is VLDB?
13 Tell us what do OLAP and OLTP stand for?
14 Can you define dimension?
15 Tell us what is Summary Information?
16 Tell me do you know what is Normalization?
17 Explain what are the reasons for partitioning?
18 What is the types of OLAP server?
19 Can you tell us what is data mart?
20 Tell me the process that are involved in Data Warehousing?
21 Please explain what is conformed fact?
22 Tell us what are the different types of SCD's used in data warehousing?
23 Tell us what is level of Granularity of a fact table?
24 Do you know what is Virtual Data Warehousing?
25 Tell us what language is the base of DMQL?
26 Tell us how many dimensions are selected in Slice operation?
27 Do you know what is a warehouse manager?
28 Tell us how many fact tables are there in a star schema?
29 What is the functions performed by OLAP?
30 Explain me which language is used for defining Schema Definition?
31 Can you tell me which one is faster, Multidimensional OLAP or Relational OLAP?
32 Tell us what is the benefit of normalization?
33 Can you explain me how does a Data Cube help?
34 Explain me how many dimensions are selected in dice operation?
35 Tell us what do you mean by Data Extraction?
36 Do you know what is Data Warehousing?
37 Explain me which one is faster, Multidimensional OLAP or Relational OLAP?
38 Explain me what is ODS?
39 Tell us what is the difference between agglomerative and divisive Hierarchical Clustering?
40 Explain me what is active data warehousing?
41 Explain me why do we override the execute method is struts?
42 Tell us what is the very basic difference between data warehouse and operational databases?
43 What is the functions of a load manager?
44 Can you define metadata?
45 Do you know what is XMLA?
46 Tell us what does subject-oriented data warehouse signify?
47 Explain me what is the difference between view and materialized view?
48 Do you know what does Metadata Respiratory contain?
49 Explain me the functions of a warehouse manager?
50 Explain me the functions of data warehouse tools and utilities?
51 Tell us how do you load the time dimension?
52 Do you know what is load manager?
53 Can you list any five applications of data warehouse?
54 What is the phases involved in the data warehouse delivery process?
55 Can you define data warehouse?

Download Data Warehouse Developer Interview Questions And Answers PDF