Font size
WorksheetsData Warehouse - Foundations
Total questions: 10
Worksheet time: 6mins
Which is not a property of data warehouse?
subject oriented
time variant
collection from heterogeneous sources
volatile
data warehousing used in_______________
transaction system
decision support system
What are the characeristics of OLAP systems?
query driven
integrated
less users
store current data
Which system is application oriented?
Online transaction processing system
Online analytical processing system
Which operation can perform on data warehouse?
read/write
modify
alter
scan
data warehouse is based on_____________
two dimensional model
three dimensional model
multidimensional model
unidirectional model
Data warehousing is related to______
create data warehouse
update data
scan and load data for analysis
write new data
A basic concept of data warehouse is which of the following?
Can be updated by end users.
Contains numerous naming conventions and formats.
Store the data in formats suitable for easy access for decision making.
Contains only current data.
Which schema is best for data warehouse development?
