Chapter 7 T/F
5) It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes.
FALSE
6) Increasing the speed of a single query is always a priority, even if it requires slowing down the majority of other queries.
FALSE
7) Keeping data in the operational system past its time horizon enables the operational queries to run faster.
FALSE
1) A typical organization maintains and utilizes a number of operational data sources.
TRUE
12) Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit.
TRUE
18) 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
15) A data mart is a data store based on the same principles as a data warehouse but with a wider scope.
FALSE
17) Separate operational data sources cannot contain overlapping information.
FALSE
2) The operational data sources include the data warehouses and data marts.
FALSE
8) Summarized operational data is typically physically stored, while summarized analytical data is typically derived (calculated) rather than physically stored.
FALSE
9) Operational data typically represents the current state of affairs in the real world, while analytical data can represent both the current situation and snapshots from the past.
TRUE
19) Data warehouse front-end applications are often referred to as business intelligence (BI) applications.
TRUE
20) The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.
TRUE
10) 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
13) Analytical databases are referred to as application-oriented.
FALSE
3) A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.
TRUE
11) In contrast to a narrow constituency of operational data, analytical data is used by a widespread set of users.
FALSE
14) Operational databases are referred to as subject-oriented.
FALSE
16) Data marts are always implemented as relational databases.
FALSE
4) The performance of operational day-to-day tasks involving data use can be severely diminished if such tasks have to compete for computing resources with analytical queries.
TRUE