Question 1 of 25
Hints left: 3
Q1
Reconciled data is which of the following?
Q2
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Q3
A star schema has what type of relationship between a dimension and fact table?
Q4
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Q5
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Q6
Data in operational systems are typically fragmented and inconsistent.
Q7
Periodic data are data that are physically altered once added to the store.
Q8
The extract process is which of the following?
Q9
A distributed database has which of the following advantages over a centralized database?
Q10
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Q11
Location transparency allows for which of the following?
Q12
The load and index is which of the following?
Q13
Most operational systems are based on the use of transient data.
Q14
Data in the data warehouse are loaded and refreshed from operational systems.
Q15
A data mart is designed to optimize the performance for well-defined and predicable uses.
Q16
Joining is the process of partitioning data according to predefined criteria.
Q17
Transient data is which of the following?
Q18
Both status data and event data can be stored in a database.
Q19
Static extract is used for ongoing warehouse maintenance.
Q20
A transaction manager is which of the following?
Q21
An autonomous homogenous environment is which of the following?
Q22
Every key used to join the fact table with a dimensional table should be a surrogate key.
Q23
The role of the ETL process is to identify erroneous data and to fix them.
Q24
A multifield transformation does which of the following?
Q25
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.