CS614 Data Warehousing Quiz No. 1 Solution and Discussion Fall 2014 Close Date 21st November 2014



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


Question # 8 of 10 ( Start time: 06:57:45 PM ) Total M a r k s: 1

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.





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



Sponsored Links

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