Chapter 7 T/F

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

IPMA - Module 4 - Classification

View Set

Diencephalon Structure and Function

View Set

APUSH Enduring Vision Chapter 21

View Set

Unit 3: Session 3: Types of Investment Risks

View Set

NUR 221 PrepU: Basic Psychosocial Needs.

View Set

Theology History - TTBE 519 Final Exam - Dr. Naidu - Biola

View Set