CH 7 430
Analytical databases are referred to as application-oriented.
FALSE
Data marts are always implemented as relational databases.
FALSE
It is usually possible to configure the system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time
FALSE
Operational databases are referred to as subject-oriented.
FALSE
Separate operational data sources cannot contain overlapping information.
FALSE
The operational data sources include the data warehouses and data marts.
FALSE
A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.
TRUE
Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit.
TRUE
ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses.
TRUE
The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.
TRUE