WorksheetsData Warehouse
Total questions: 5
Worksheet time: 4mins
Name
Class
Date
1.
A data warehouse is which of the following?
a)
Can be updated by end users
b)
Contains numerous naming conventions and formats.
c)
Organized around important subject areas.
d)
Contains only current data.
2.
The generic two-level data warehouse architecture includes which of the following?
a)
At least one data mart
b)
Data that can extracted from numerous internal and external sources
c)
Near real-time updates
d)
All of the above.
3.
What type of data formats do conventional database systems use?
a)
Highly Denormalized
b)
Highly Normalized
c)
A and B
d)
None of the above
4.
What is computing in data warehouses often referred to as?
a)
OLAP
b)
OLTP
c)
OLAT
d)
OLTA
5.
Which small logical units do data warehouses hold large amounts of information?
a)
Data Storage
b)
Data Marts
c)
Access Layer
d)
Data Miners
100 %
