CS614 - Data Warehousing

March 3,2014
Solved MCQS
MC100401285 Moaaz.pk@gmail.com Mc100401285@gmail.com PSMD01

CS614 - Quiz No.3 & 4 (2013 Spring & Fall)

Question # 1 of 10 (Total Marks: 1) Select correct option:

During the development phase we should follow standards for:

Naming Conventions
Calculation
Libraries
All of the given options (Page 307)

Question # 2 of 10 (Total Marks: 1) Select correct option:

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

Project Planning
Requirement definition (Page 299)
Requirement verification
Requirement validation

Question # 3 of 10 (Total Marks: 1) Select correct option:

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

1
Question # 4 of 10 (Total Marks: 1) Select correct option:
Waterfall model is appropriate when

When budget is low

When the deadline is strict
When resources are limited
Requirements are clearly defined (Page 284)

Question # 5 of 10 (Total Marks: 1) Select correct option:

A bottom up implementation approach is useful when

Technology is matured and well understands (page 283)

Organizationcannot implement latest technologies
The business objectives are very much clear
All requirements are well documented

Question # 6 of 10 (Total Marks: 1) Select correct option:

Technical architecture design specifies the:

Project schedule (Page 300)

Minimum project completion time
Required Components
Umbrella activities

Question # 7 of 10 (Total Marks: 1) Select correct option:

_____ says that as far as company goals are concerned, the entire company pursues in the same direction
Westerman (Page 285)
Bill inmon
Kimball
Bohnlein

Question # 8 of 10 (Total Marks: 1) Select correct option:

As per Bill Inmon, a data warehouse, in contrast with classical applications is:
Data driven (Page 285)
Resource driven
Requirement driven
Time Sensitive

2
Question # 9 of 10 (Total Marks: 1) Select correct option:
The _______ phase of fundamental data warehouse life cycle model includes data warehouse scheduled
maintenance

Deployment
Operation (Page 288)
Enhancement
Maintenance

Question # 10 of 10 (Total Marks: 1) Select correct option:

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

Question # 1 of 10 (Total Marks: 1) Select correct option:

As per Kimball, ______ is the main operational process

Requirement extraction
Global design
Business process (Page 285)
Scheme design

Question # 2 of 10 (Total Marks: 1) Select correct option:

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)
Deployment
Operation

3
Question # 3 of 10 (Total Marks: 1) Select correct option:
Waterfall is a/an ______ model

Iterative
Simple linear sequential (Page 284)
Object oriented
Rapid development

Question # 4 of 10 (Total Marks: 1) Select correct option:

One of the drawbacks of waterfall model is that:

Customers can not review the product during development (Page 284)
It does not work when the resources are limited
It does not define the project timeline/schedule
All of the given options

Question # 5 of 10 (Total Marks: 1) Select correct option:

Spiral model is ________

Sequence of waterfall model

Risk oriented model
An iterative model
All of the given (Page 284)

Question # 6 of 10 (Total Marks: 1) Select correct option:

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

Statistics
Knowledge discovery in database (Page 249)
Clustering
Information cleansing

4
Question # 7 of 10 (Total Marks: 1) Select correct option:
In data mining, initially you_____what you are looking for.
Know
Don't Know (Page 250)
May or may not know
None of the given options

Question # 8 of 10 (Total Marks: 1) Select correct option:

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

End-user interviews and re-interviews

Source system cataloguing
Definition of key performance indicators
System vision development (Page 287)

Question # 9 of 10 (Total Marks: 1) Select correct option:

A top down implementation approach is useful when

Technology is matured and well understands (Page 283)

Organization cannot implement latest technologies
The business objectives are very much clear
All requirements are well documented

Question # 10 of 10 (Total Marks: 1) Select correct option:

Which of the following is NOT one of the methodologies for Data Warehouse project development?
Goal Driven
Data Driven
User Driven
System Driven (Page 283)

Question # 1 of 10 (Total Marks: 1) Select correct option:

In context of data mining definition, the term "value" means
The primary key of table
Index location of the record
Importance of hidden patterns discovered (Page 250)
Numerical of string measure assigned to an attribute

5
Question # 2 of 10 (Total Marks: 1) Select correct option:
Data mining is all about

Knowledge discovery in database

Finding hidden patterns in data
Finding hidden relations in data
All of the given options (Page 249)

Question # 3 of 10 (Total Marks: 1) Select correct option:

In context of clustering, the term "distance" means

Similarity/dissimilarity of records (Page 272)

The difference between the primary keys of two records
The relation of a record with corresponding record in child table
None of the given options

Question # 4 of 10 (Total Marks: 1) Select correct option:

We should follow a proper ____________ cycle to implement a change even if it is smaller one.
Development -> QA -> Production (Page 314)
Production -> QA ->Development
Development -> Production -> QA
Production->Development -> QA

Question # 5 of 10 (Total Marks: 1) Select correct option:

For smooth DWH project implementation, one of the recommendations is to have:

Full time project manager assigned to the project (Page 318)

QA team ready for testing the code
Design of complete project before implementation
Components of complete project before implementation

Question # 6 of 10 (Total Marks: 1) Select correct option:

Normally it is recommended to have
Different servers for development and production environment
Same server for development and production environment
Interference while having different database environments on a single server (Page 313)
All of the given options

6
Question # 7 of 10 (Total Marks: 1) Select correct option:
Identify the TRUE statement:

Clustering is unsupervised learning and classification is supervised learning (Page 270)

Clustering is supervised learning and classification is unsupervised learning
Both clustering and classification are unsupervised learning
Both clustering and classification are supervised learning

Question # 8 of 10 (Total Marks: 1) Select correct option:

Mining multi-dimensional databases allow users to:

Categorize the data

Analyze the data
Summarize the data
All of the given options (Page 250)

7
Question # 1 of 10 (Total Marks: 1) Select correct option:
Technical architecture design supports the communication about technical requirements: I) within the team II)
Upward to management III) Outward to vendors

(I) only
(II) Only
(III) Only
(I), (II) and (III) (Page 300)

Question # 2 of 10 (Total Marks: 1) Select correct option:

Improper documentation results the problem(s) like:

Maintenance issue
New developers unable to configure already existing code (Page 314)
Lot of time required for enhancing the code
All of the given options

Question # 3 of 10 (Total Marks: 1) Select correct option:

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

Scope
Feasibility
Resources available
The potential impact or value to the business (Page 297)

Question # 4 of 10 (Total Marks: 1) Select correct option:

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

Requirement elicitation
Project Planning
Project management (Page 289)
Deployment

8
Question # 5 of 10 (Total Marks: 1) Select correct option:
“What means what”. The phrase refers to:
Meta data (Page 338)
External data
Transformed data
Internal representations

Question # 6 of 10 (Total Marks: 1) Select correct option:

Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?

Not interacting directly with end user

Not being an accommodating person (Page 316)
Isolating IT support people from business users
Training the users with dummy data and considering it success

Question # 7 of 10 (Total Marks: 1) Select correct option:

In ___________ phase of kimballs approach, we identify the components needed now and in future.

Requirement definition
Architectural design (Page 300)
Product development
Analytical application development

Question # 8 of 10 (Total Marks: 1) Select correct option:

Which of the following is NOT one of the advantages of changed data capture (CDC) technique?
Flat files are not required
Limited query interface is required for data extraction (Page 152)
No incremental on-line I/O required for log tape
Extraction of changed data occurs immediately

Question # 9 of 10 (Total Marks: 1) Select correct option:

_____ technique requires a separate column to specify the time and date when the last modification was
occurred.

CheckMarks
TimeStamps (Page 150)
Just-In-Time
RealTime extraction
9
Question # 10 of 10 (Total Marks: 1) Select correct option:
Non uniform use of abbreviations, units and values refers to:

Syntactically dirty data (Page 160)

Semantically dirty data
Coverage anomaly
Extraction issue

Question # 1 of 10 (Total Marks: 1) Select correct option:

In Extract, Load, Transform (ELT) process, data transformation _____

Takes place on the data warehouse server

Takes place on a separate transformation server (Page 147)
Depends on the nature of the source database
Does not take place

Question # 2 of 10 (Total Marks: 1) Select correct option:

If one or more records in a relational table do not satisfy one or more integrity constraint, then the data:

Is syntactically dirty
Is semantically dirty (Page 160)
Has Coverage anomaly
Has extraction issue

Question # 3 of 10 (Total Marks: 1) Select correct option:

Which of the following is not a task of Data Transformation?

Conversion
Summarization
Enrichment
Full Data Refresh (Page 135)

Question # 4 of 10 (Total Marks: 1) Select correct option:

Robotic libraries are needed for ___________
Cubes
Data marts
Data warehouse (Page 131)
Aggregates
10
Question # 5 of 10 (Total Marks: 1) Select correct option:
Change Data Capture (CDC) can be challenging task because:

Aggregates don’t change in real time

Transformation of extracted data is difficult (Page 149)
Identifying the recently modified data may be difficult
Source systems may not support extraction of changed aggregates

Question # 6 of 10 (Total Marks: 1) Select correct option:

In case of multiple sources for the same data element, we need to prioritize the source systems per element
bases, the process is called:

Ranking (Page 143)

Prioritization
Element Selection
Measurement Selection

Question # 7 of 10 (Total Marks: 1) Select correct option:

In context of Change Data Capture (CDC), sometimes a ____ object can be used to store the recently modified
data:

Buffer table
Change table (Page 149)
Checkmark table
Change control table

Question # 8 of 10 (Total Marks: 1) Select correct option:

Which of the following is NOT one of the examples of dynamic attributes?

Daily Sale
Date of Birth cnfim not (Page 342)
Air pressure
None of the given options

11
Question # 9 of 10 (Total Marks: 1) Select correct option:
In context of requirement definition phase of Kimball’s DWH development approach, ________ is positioned
as a findings review and prioritization meeting.

System analysis
Scope definition
Requirement configuration
Requirements wrap-up presentation (Page 297)

Question # 10 of 10 (Total Marks: 1) Select correct option:

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

Obtain resources
Establish the preliminary scope and justification
Assess organization's readiness for a data warehouse initiative
All of the given options (Page 290)

Question # 1 of 10 (Total Marks: 1) Select correct option:

Goal driven approach of data warehouse development was result of ______ work
Bill Inmon
Ralph Kimball
Böhnlein and Ulbrich-vom (Page 285)
Westerman

Question # 2 of 10 (Total Marks: 1) Select correct option:

In contrast to data mining, statistics is ______ driven.
Assumption
Knowledge
human (Page 255)
Database

Question # 3 of 10 (Total Marks: 1) Select correct option:

Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .

Linear
Quadratic
Exponential (Page 15)
Logarithmic

12
Question # 4 of 10 (Total Marks: 1) Select correct option:
In context of requirement definition phase in Kimball’s DWH development approach, activities like debriefing,
documentation, and prioritization are considered to be the part of:

Requirement preplanning
Business requirements collection
Post collection (Page 294)
None of the given options

Question # 5 of 10 (Total Marks: 1) Select correct option:

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

Tables should be properly de-normalized

Proper partitioning technique should be used
At least star or snow flake schema should be implementing
They should get information in timely manner (Page 314)

Question # 6 of 10 (Total Marks: 1) Select correct option:

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

Education
Technical education
Program Support
Interface Deployment (Page 309)

Question # 7 of 10 (Total Marks: 1) Select correct option:

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

Employee Name (Page 342)

Employee Date of Birth
Employee Blood Group
All of the given options

13
Question # 8 of 10 (Total Marks: 1) Select correct option:
Three parallel tracks in kimbal’s DWH development approach converge at _______ Phase

Project planning
Business requirement definition
Deployment (Page 308)
Maintenance and growth

Question # 9 of 10 (Total Marks: 1) Select correct option:

Which of the following is not a technique of "De-Normalization" ?
Pre-joining
Splitting Tables
Adding Redundant Columns
ER Modeling (Page 52)

Question # 10 of 10 (Total Marks: 1) Select correct option:

Which one of the following is not a technique of "Change Data Capture” in currently used Modem Source
Systems?
Timestamps
Partitioning
Triggers
Dimensional Modeling (Page 150)

Question # 1 of 10 (Total Marks: 1) Select correct option:

Normally the term "DWH face to the business user" refers to:

Lifecycles technology track

Lifecycle Data track
Lifecycle Analytical Applications track (Page 306)
Lifecycle Maintenance track

Question # 2 of 10 (Total Marks: 1) Select correct option:

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

Understand the audience, don't overwhelm

Train after delivery of the data and analytic applications
Postpone education, if DWH not ready
All of the given options (Page 308)
14
Question # 3 of 10 (Total Marks: 1) Select correct option:
In context of analytical applications track, the application development activity can begin after

Database Design is complete (Page 307)

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

15