Transient data is which of the following? Data that are never deleted once they have been added Data in which changes to existing records cause the previous version of the records to be eliminated Data in which changes to existing records do not cause the previous version of the records to be eliminated Data that are never altered or deleted once they have been added TRUE ANSWER : ? YOUR ANSWER : ?
The role of the ETL process is to identify erroneous data and to fix them. False True TRUE ANSWER : ? YOUR ANSWER : ?
Reconciled data is which of the following? Data stored in the various operational systems throughout the organization. Data stored in one operational system in the organization. Data that has been selected and formatted for end-user support applications. Current data intended to be the single source for all decision support systems. TRUE ANSWER : ? YOUR ANSWER : ?
Periodic data are data that are physically altered once added to the store. False True TRUE ANSWER : ? YOUR ANSWER : ?
Every key used to join the fact table with a dimensional table should be a surrogate key. True False TRUE ANSWER : ? YOUR ANSWER : ?
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications. False True TRUE ANSWER : ? YOUR ANSWER : ?
A goal of data mining includes which of the following? To analyze data for expected relationships To explain some observed event or condition To confirm that data exists To create a new data warehouse TRUE ANSWER : ? YOUR ANSWER : ?
A snowflake schema is which of the following types of tables? All of these Dimension Helper Fact TRUE ANSWER : ? YOUR ANSWER : ?
Independent data marts are often created because an organization focuses on a series of short-term business objectives. True False TRUE ANSWER : ? YOUR ANSWER : ?
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW. True False TRUE ANSWER : ? YOUR ANSWER : ?