In context of clustering, the term “distance” means:

• A) The relation of a record with corresponding record in child table
• B) None of the given options
• C) The difference between the primary keys of two records
• D) Similarity/dissimilarly of records

In context of data mining definition, the term “value” means:

• A) Importance of hidden patterns discovered
• B) The index location of the record
• C) Numerical or string measure assigned to an attribute
• D) The primary key of table

Waterfall model is appropriate when

• A) When resources are limited
• B) When the budget is low
• C) Requirements are clearly defined
• D) When the deadline is strict

Goal driven approach of data warehouse development was result of ______ work

• A) Bill Inmon
• B) Ralph Kimball
• C) Böhnlein and Ulbrich-vom
• D) Westerman

Users do not care, how advance the front end of your DWH is, what they care is that:

• A) Tables should be properly denormalized
• B) They should get information in timely manner and the way they want
• C) Proper partitioning technique should be used
• D) At least star or snow flake schema should be implemented

“What means What”. The phrase refers to:

• A) Transformed data
• B) Internal representations
• C) Meta data
• D) External data

In context of requirement definition phase of Kimball’s DWH development approach, ________ is positioned as a findings review and prioritization meeting.

• A) Requirement configuration
• B) Requirements wrap-up presentation
• C) Scope definition
• D) System analysis

A typical cycle of implementing the change in DWH comprises of the sequence:

• A) Production -> QA -> Development
• B) Production -> Development -> QA
• C) Development-> QA -> Production
• D) Development -> Production -> QA

Which of the following is/are example(s) of static attributes?

• A) Employee Date of Birth
• B) Employee Name
• C) Employee blood Group
• D) All of the given options

Which of the following is NOT one of the methodologies for Data Warehouse project development?

• A) Data Driven
• B) Goal Driven
• C) System Driven
• D) User Driven

In data mining, initially you _____ what you are looking for.

• A) May or may not know
• B) None of the given options
• C) Know
• D) Don’t know

Which of the following is NOT one of the three parallel tracks in Kimballs approach?

• A) Lifecycle Maintenance track
• B) Lifecycle Data track
• C) Lifecycle technology track
• D) Lifecycle Analytical Applications track

________ refers to the overall process of discovering useful knowledge from data and data mining refers to a particular step in this process.

• A) Statistics
• B) Clustering
• C) Information cleansing
• D) Knowledge discovery in database

In ________learning you don’t know the number of clusters and no idea about their attributes.

• A) Supervised learning
• B) Multi Dimension modeling
• C) None of the given options
• D) Unsupervised learning

A top down implementation approach is useful when

• A) Technology is mature and well understood
• B) Business objectives are unclear
• C) Problem to be solved are not well documented
• D) Organization can not implement latest technologies

_____ says that as far as company goals are concerned, the entire company pursues in the same direction

• A) Bohnlein
• B) Kimball
• C) Bill Inmon
• D) Westerman

Horizontally wide data means:

• A) Dataset has large no. of records
• B) Dataset has attribute skews
• C) Dataset has large no. of attributes
• D) Dataset has partitioning skews

Spiral model is ________

• A) All of the given options
• B) An iterative model
• C) Risk oriented model
• D) Sequence of waterfall model

In Four Cell Quadrant Technique, The quadrant's vertical axis refers to:

• A) The potential impact or value to the business
• B) Scope
• C) Feasibility
• D) Resources available

Which of the following is the most ignored step during data warehouse development

• A) Schema validation
• B) The requirement verification
• C) The vision definition
• D) Success criteria development