Q.1
Both status data and event data can be stored in a database.
Q.2
Static extract is used for ongoing warehouse maintenance.
Q.3
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Q.4
Every key used to join the fact table with a dimensional table should be a surrogate key.
Q.5
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Q.6
A data mart is designed to optimize the performance for well-defined and predicable uses.
Q.7
Joining is the process of partitioning data according to predefined criteria.
Q.8
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Q.9
The role of the ETL process is to identify erroneous data and to fix them.
Q.10
The load and index is which of the following?
Q.11
Data in operational systems are typically fragmented and inconsistent.
Q.12
Most operational systems are based on the use of transient data.
Q.13
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Q.14
Data in the data warehouse are loaded and refreshed from operational systems.
Q.15
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Q.16
Periodic data are data that are physically altered once added to the store.
Q.17
The extract process is which of the following?
Q.18
A star schema has what type of relationship between a dimension and fact table?
Q.19
Transient data is which of the following?
Q.20
A multifield transformation does which of the following?
0 h : 0 m : 1 s