CS614 Quiz
Data Warehouse
Quiz#1
Question # 1
Data Warehouse is about taking / colleting data from different ________ sources.
Select correct option:
Harmonized
Identical
Homogeneous
Heterogeneous
Question # 2
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known asSelect correct option:
Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture
Question # 3
It is observed that every year the amount of data recorded in an organizationSelect correct option:
Doubles
Remains same as previous year
Triples
Quartiles
Question # 4
The users of data warehouse are knowledge workers in other words they are _________ in the organization.Select correct option:
DWH Analyst
Decision maker
Database Administrator
Manager
Question # 5
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)
Question # 6
In _________ system, the contents change with time.Select correct option:
OLTP OLTP
ATM
DSS
OLAP
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
Question # 8
The growth of master files and magnetic tapes exploded around the mid- _______.
Select correct option:
1950s.
1960s.
1970s.
1980s.
Question # 9
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
Question # 10
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.Select correct option:
Relaxed
Good
Not Relaxed
None
Question # 11
________ gives total view of an organizationSelect correct option:
OLAP
OLTP
Data Warehouse
Database
Question # 12
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .Select correct option:
Linear
Quadratic
Exponential
logarithmic
_________________________________________________________________________