[VUSR] 65343 CS614 - Data Warehousing Quiz No.1 April 26,2012

CS614 - Data Warehousing

Quiz No.1 April 26,2012

 

It is observed that every year the amount of data recorded in an organization  

Select correct option:  

 

 Doubles

 Remains same as previous year

 Triples 

 Quartiles 

 

Question # 2 of 10 ( Start time: 06:50:55 PM )  Total M a r k s: 1 

 

_______ is an application of information and data.  

Select correct option:  

 

 Knowledge

 Intelligence

 Power 

 Education 

 

Question # 3 of 10 ( Start time: 06:52:16 PM )  Total M a r k s: 1

  

Data Warehouse is about taking / colleting data from different ________ sources.  

Select correct option:  

 

 Harmonized

 Identical 

 Homogeneous 

 Heterogeneous 

 

Question # 4 of 10 ( Start time: 06:53:46 PM )  Total M a r k s: 1 

 

The need to synchronize data upon update is called  

Select correct option:  

 

 Data Imitation

 Data Manipulation

 Data Replication

 Data Coherency

 

 

Question # 5 of 10 ( Start time: 06:54:29 PM )  Total M a r k s: 1 

 

________ gives total view of an organization  

Select correct option:  

 

 OLAP 

 OLTP  

 Data Warehouse 

 Database 

 

 

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

Select correct option:  

 

 Linear 

 Quadratic 

 Exponential 

 Logarithmic 

 

Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.  

Select correct option:  

 

 O (n lg n)

 O (lg n)

 O (n)

 O (n2) 

 

The growth of master files and magnetic tapes exploded around the mid- _______.  

Select correct option:  

 

 1950s. 

 1960s. 

 1970s. 

 1980s. 

  

The input to the data warehouse can come from OLTP or transactional system but not from other third party database.  

Select correct option:  

 

 True 

 False 

 

 

In _________ system, the contents change with time.

OLTP

ATM

DSS

OLAP

 

Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.

Only One Direction

Any Direction

Two Direction

None of these

 

Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.

Relaxed

Good

Not Relaxed

None

 

A single database, couldn't serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.

True

False

 

 

Data Warehouse is about taking / colleting data from different Heterogeneous sources.

Harmonized

Identical

Homogeneous

Heterogeneous

 

________ gives total view of an organization

Select correct option:

OLAP

OLTP

Data Warehouse

Database

 

The input to the data warehouse can come from OLTP or transactional system but not from other third party

database.

Select correct option:

True

False

 

 

The need to synchronize data upon update is called

 

Select correct option:

Data Imitation

Data Manipulation

Data Replication

Data Coherency

 

B-Tree is used as an index to provide access to records

Select correct option:

Without scanning the entire table

By scanning the entire meta data

By scanning the entire table

None of these

 

 

For good decision making, data should be integrated across the organization to cross the LoB (Line of Business). This is to give the total view of organization from:

 

Owner's Perspective

Decision Maker Perspective

Customer's Perspective

Employee's Perspective

 

 

________ gives total view of an organization

 OLAP

OLTP

Data Warehouse

Database

 

 

Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.

Select correct option:

 

Only One Direction

Any Direction

Two Direction

None of these

 

B-Tree is used as an index to provide access to records

Without scanning the entire table

By scanning the entire meta data

Scanning the entire table

None of these

 

 

In _________ system, the contents change with time.

OLTP OLTP

ATM

DSS

OLAP

 

The input to the data warehouse can come from OLTP or transactional system but not from other third party database.

Select correct option:

True

False

 

Ad-hoc access means to run such queries which are known already.

True

False

 

 

The need to synchronize data upon update is called

Data Imitation

Data Manipulation

Data Replication

Data Coherency

 

The users of data warehouse are knowledge workers in other words they are _________ in the organization.

DWH Analyst

Decision maker

Database Administrator

Manager

 

Data Warehouse is about taking / colleting data from different ________ sources.

Harmonized

Identical

Homogeneous

Heterogeneous

 

It is observed that every year the amount of data recorded in an organization

Doubles

Remains same as previous year

Triples

Quartiles

--
Zindagi mein 2 Logo ka buhat khayal rahkoooo

Ist woh jiss ney tumhari jeet ke Liye buhat kuch hara hoo (Father)

2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)

Regards, 

Umair Saulat

--
Please visit http://vusr.net for Old and Latest Papers, Assignments, Quiz and GDBs.
 
http://VUSR.net The ultimate VU Study Resource
 
You received this message because you are subscribed to the Google
Groups "VUSR" group.
 
 
To unsubscribe
vusr+unsubscribe@googlegroups.com
To Visit Group Home Page
http://groups.google.com/group/vusr?hl=en?hl=en