CS614 Final Term Solved MCQs with References 2014 by Moaaz

CS614 - Data Warehousing Solved MCQS · March 3,2014 · PSMD01 · CS614 - Quiz No.3 & 4 (2013 Spring & Fall)

During the development phase we should follow standards for:

Naming Conventions Calculation Libraries

As per kimball’s approach the second phase of DWH life cycle is:

Requirement definition (Page 299)

Requirement verification Requirement validation

Bill Inmon argues that requirements are well understood only after

They are documented They extracted and verified

Data warehouse is populated (Page 285)

All schemes are defined Waterfall model is appropriate when

When budget is low When the deadline is strict When resources are limited

Requirements are clearly defined (Page 284)

A bottom up implementation approach is useful when

Organizationcannot implement latest technologies

Technical architecture design specifies the:

Project schedule (Page 300)

Minimum project completion time Required Components Umbrella activities

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

Westerman (Page 285)

Bill inmon Kimball Bohnlein

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

Data driven (Page 285)

Resource driven Requirement driven Time Sensitive The _______ phase of fundamental data warehouse life cycle model includes data warehouse scheduled maintenance

Operation (Page 288)

Enhancement Maintenance

Following the coding standards during development helps to:

Minimize the future rework (Page 307)

Verify the requirements To refine the project scope To establish the test cases

As per Kimball, ______ is the main operational process

Requirement extraction Global design

Business process (Page 285)

Scheme design

In ______ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users

Design

Prototype (Page 287)

Operation