CS614 Quiz 4 by VU Topper RM

“What means What”. The phrase refers to:

A. Meta data Page 338

B. External data C. Transformed data D. Internal representations

In Four Cell Quadrant Technique, The quadrant's vertical axis refers to: A. Scope B. Feasibility C. Resources available

D. The potential impact or value to the business Page 297

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

1. Data driven
2. System driven Page 283
3. Resource driven
4. Requirement driven

Correct answer: System driven Page 283

Which of the following is the most ignored step during data warehouse development A. Schema validation B. The vision definition C. The requirement verification

D. Success criteria development

Waterfall model is appropriate when A. When the budget is low B. When the deadline is strict C. When resources are limited

D. Requirements are clearly defined Page 284

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. Proper partitioning technique should be used C. At least star or snow flake schema should be implemented

D. They should get information in timely manner and the way they want

A top down implementation approach is useful when A. Business objectives are unclear

B. Technology is mature and well understood Page 283

C. Problem to be solved are not well documented D. Organization can not implement latest technologies

Identify the TRUE statement: A. Both clustering and classification are supervised learning B. Both clustering and classification are unsupervised learning C. Clustering is unsupervised learning and classification is supervised learning Page 270 D. Clustering is supervised learning and classification is unsupervised learning

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

B. Operation Page 288

C. Deployment D. Maintenance

Horizontally wide data means: A. Dataset has attribute skews B. Dataset has partitioning skews C. Dataset has large no. of records

D. Dataset has large no. of attributes Page 330

Which of the following is/are included in the list of Top-7 key steps for smooth DWH implementation?

1. All of the given options Page 318
2. Be a diplomat NOT a technologist
3. Assign significant resources for ETL
4. Consider handing-off project management

Correct answer: All of the given options Page 318

Implementation of a data warehouse requires ________ activities A. Highly integrated B. Loosely integrated C. Tightly decoupled

D. None of the given Page 289

Goal driven approach of data warehouse development was result of ______ work A. Bill Inmon B. Westerman C. Ralph Kimball

D. Böhnlein and Ulbrich-vom Page 285

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

A. Database Design is complete Page 307

B. A subset of historical data has been loaded C. The data access tools and metadata are installed D. All of the given options

In ______ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users A. Design B. Operation

C. Prototype Page 287

D. Deployment

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

1. Deployment
2. Project planning
3. Project management Page 289

Correct answer: Project management Page 289