The phase-3 i.e. “Rollout and Maintenance” phase in “12-steps data warehouse implementation approach” of Shaku Atre comprises of _______ activity.

• A) None of the given options
• B) Deployment & System Management
• C) On Line Analytical Processing
• D) Construct Metadata Repository

In context of analytical applications track, the application development activity can begin after:

• A) A subset of historical data has been loaded
• B) Database design is complete
• C) All of the given options
• D) The data access tools and metadata are installed

Which of the following activity executes parallel with all other activities in Kimball’s DWH development approach?

• A) Deployment
• B) Project Planning
• C) Requirement elicitation
• D) Project management

As opposed to the outcome of classification, estimation deals with __________ valued outcome.

• A) Isolated
• B) Continuous
• C) Discrete
• D) Distinct

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

• A) Discovering information is a simple task
• B) Discovering information is a complex task
• C) We can not discover information
• D) We simply find things rather than discovery

Bill Inmon argues that requirements are well understood only after

• A) Data warehouse is populated
• B) They extracted and verified
• C) All the schemas are defined
• D) They are documented

Which of the following activity/activities is/are part of project planning phase in Kimballs DWH development approach?

• A) Establish the preliminary scope and justification
• B) Assess organization's readiness for a data warehouse initiative
• C) All of the given options
• D) Obtain resources

In context of the most fundamental data warehouse life cycle model, which of the following is NOT one of the data warehouse design activities?

• A) End-user interviews and re-interviews
• B) Source system cataloguing
• C) System vision development
• D) Definition of key performance indicators

Mining multi dimensional databases allow users to:

• A) Analyze the data
• B) Summarize the data
• C) All of the given options
• D) Categorize the data

As per Kimball, ______ is the main operational process

• A) Schema design
• B) Requirement extraction
• C) Business process
• D) Goal design

As per Bill Inmon, a data warehouse, in contrast with classical applications is:

• A) Resource driven
• B) Time sensitive
• C) Data driven
• D) Requirement driven

The first step of the “12-steps data warehouse implementation approach” of Shaku Atre is:

• A) Data acquisition and cleansing
• B) Planning system resources
• C) Finding system scope
• D) Finding user needs

Vertically wide data means:

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

Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach?

• A) Technical Education
• B) Program Support
• C) Education
• D) Interface Deployment

Waterfall is a/an ______ model

• A) Iterative
• B) Object Oriented
• C) Rapid development
• D) Simple linear sequential

The _______ phase of fundamental data warehouse life cycle model includes data warehouse daily maintenance activities

• A) Enhancement
• B) Deployment
• C) Maintenance
• D) Operation

An effective user education program includes, among others, the following guideline(s):

• A) All of the given options
• B) Understand the audience, don’t overwhelm
• C) Train after delivery of data and analytic applications
• D) Postpone education, if DWH not ready

________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.

• A) Aggregation
• B) Partitioning
• C) Segmentation
• D) Clustering

Which of the following is NOT one of the possible pitfalls in DWH Life Cycle & Development?

• A) Not having multiple servers
• B) None of the given options
• C) Low priority for OLAP Cube Construction
• D) Improper documentation

Technical architecture design supports the communication about technical requirements:
I) Within the team
II) Upward to management
III) Outward to vendors

• A) (I) only
• B) (III) Only
• C) (II) Only
• D) (I), (II) and (III)