5370 Quiz 9
An event is a database action that results from a transaction.
True
An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.
True
Data reconciliation occurs in two stages, an initial load and subsequent updates.
True
ETL is short for Extract, Transform, Load.
True
For performance reasons, it may be necessary to define more than one fact table for a star schema.
True
Grain and duration have a direct impact on the size of fact tables.
True
Joining is often complicated by problems such as errors in source data.
True
Scalable technology is often critical to a data mart.
True
The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
True
All of the following are some beneficial applications for real-time data warehousing EXCEPT:
data entry.
A data mart is a(n):
data warehouse that is limited in scope.
A star schema contains both fact and ________ tables.
dimension
Grain and duration have a direct impact on the size of ________ tables.
fact
The analysis of data or information to support decision making is called:
informational processing.
An operational data store (ODS) is a(n):
integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.
Conformed dimensions allow users to do the following:
query across fact tables with consistency.
Informational systems are designed for all of the following EXCEPT:
running a business in real time.
Transient data are never changed.
False
Factless fact tables may apply when:
we are deleting correlated data.
Operational and informational systems are generally separated because of which of the following factors?
A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.
Which of the following factors drive the need for data warehousing?
Businesses need an integrated view of company information.
A fact table holds descriptive data about the business.
False
A separate data warehouse causes more contention for resources in an organization.
False
Data federation consolidates all data into one database.
False
Independent data marts do not generally lead to redundant data and efforts.
False
Logical data marts are physically separate databases from the enterprise data warehouse.
False
NoSQL is a great technology for storing well-structured data.
False
Operational metadata are derived from the enterprise data model.
False
The development of the relational data model did not contribute to the emergence of data warehousing.
False
________ technologies are allowing more opportunities for real-time data warehouses.
RFID