Data Warehousing and Data mining Interview Questions with answers
DMDW viva Questions
1. Which of the following forms the logical subset of the complete data warehouse?
(d)Operational Data Store
2.Which of the following is not included in Modeling Applications?
(b)Behavior scoring models
(d)Data mining Models
(e)Metadata driven models.
3.Which of the following is a dimension that means the same thing with every possible fact table to
which it can be joined?
4.Which of the following is not the managing issue in the modeling process?
(a)Content of primary units column
(b)Document each candidate data source
(c)Do regions report to zones
(d)Walk through business scenarios
(e)Ensure that the transaction edit flat is used for analysis.
5.Which of the following criteria is not used for selecting the data sources?
(d)Longevity of the feed
6.Which of the following does not relate to the data modeling tool?
(a)Link to the dimension table designs
(b)Business user Documentation
(c)Helps assure consistency in naming
(d)Length of the logical column.
(e)Generates physical object DDL.
7.Which of the following is true on building a Matrix for Data warehouse bus architecture?
(a)Data marts as columns and dimensions as rows
(b)Dimensions as rows and facts as columns
(c)Data marts as rows and dimensions as columns
(d)Data marts as rows and facts as columns
(e)Facts as rows and data marts as columns.
8.Which of the following should not be considered for each dimension attribute?
(b)Rapid changing dimension policy
9.Which of following form the set of data created to support a specific short lived business situation?
(a)Personal Data Marts
(d)Disposable Data Marts
(e)Data mining models.
10.Which of the following does not form future access services?
(c)Push toward centralized services
(e)Web based customer access.
11.What is the special kind of clustering that identifies events or transactions that occur
12.Of the following team members, who do not form audience for Data warehousing?
(c)Business Intelligence experts
13.The precalculated summary values are called as
14.OLAP stands for
(a)Online Analytical Processing
(b)Online Attribute Processing
(c)Online Assertion Processing
(d)Online Association Processing
(e)Online Allocation Processing.
15.Which of the following employ data mining techniques to analyze the intent of a user query,
provided additional generalized or associated information relevant to the query?
(a)Iceberg Query Method
(c)Intelligent Query answering
16.Of the following clustering algorithm what is the method which initially creates a hierarchical
decomposition of the given set of data objects?
17.Which one of the following can be performed using the attribute-oriented induction in a manner
similar to concept characterization?
(c)OLAP based approach
18.Which one of the following is an efficient association rule mining algorithm that explores the levelwise
19.What allows users to focus the search for rules by providing metarules and additional mining
(a)Correlation rule mining
(b)Multilevel Association rule mining
(c)Single level Association rule mining
(d)Constraint based rule mining
(e)Association rule mining.
20.Which of the following can be used in describing central tendency and data description from the
descriptive statistics point of view?
21.Which of the following is the collection of data objects that are similar to one another within the
22.In which of the following binning strategy, each bin has approximately the same number of tuples
assigned to it?
(e)Frequent predicate set.
23.Which of the following binning strategy has the interval size of each bin the same?
24.Which of the following association shows relationships between discrete objects?
25.What algorithms attempt to improve accuracy by removing tree branches reflecting noise in the
26.Which of the following process includes data cleaning, data integration, data selection, data
transformation, data mining, pattern evolution, and knowledge presentation?
27.What is the target physical machine on which the data warehouse is organized and stored for
direct querying by end users, report writers, and other applications?
(e)Data staging server.
28.Which of the following cannot form a category of queries?
(c)Simple behavioral queries
(d)Derived Behavioral queries
29.Which of the following is not related to dimension table attributes?
30.Type 1: Overwriting the dimension record, thereby loosing the history, Type 2: Create a new
additional dimension record using a new value of the surrogate key and Type 3: Create an old field
in the dimension record to store the immediate previous attribute value. Belong to:
(a)Slow changing Dimensions
(b)Rapidly changing Dimensions
ANSWERS Click here..
- M.Tech (cse)
- jntu btech R09 syllabus books
- Handbook of Electrical Power System Dynamics Modeling, Stability, and Control
- Mobile Computing (MC) 50 Questions with Answers
- Data strucutures with java lab programs
- Data Mining And Data WareHousing NOtes ALL 8 UNITS (DMDW)
- Bank jobs at Prathama Bank
- MEFA TEXT BOOK
- Basic Electrical Engineering by u.a.Bakshi
- R13 1st B.Tech NETWORK ANALYSIS Syllabus