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