Both status data and event data can be stored in a database. True False TRUE ANSWER : ? YOUR ANSWER : ?
Fact tables are which of the following? Partially denoralized Completely denoralized Completely normalized Partially normalized TRUE ANSWER : ? YOUR ANSWER : ?
Joining is the process of partitioning data according to predefined criteria. True False TRUE ANSWER : ? YOUR ANSWER : ?
A data mart is designed to optimize the performance for well-defined and predicable uses. True False TRUE ANSWER : ? YOUR ANSWER : ?
A goal of data mining includes which of the following? To explain some observed event or condition To create a new data warehouse To analyze data for expected relationships To confirm that data exists TRUE ANSWER : ? YOUR ANSWER : ?
Data transformation includes which of the following? A process to change data from a summary level to a detailed level A process to change data from a detailed level to a summary level Separating data from one source into various sources of data Joining data from one source into various sources of data TRUE ANSWER : ? YOUR ANSWER : ?
The role of the ETL process is to identify erroneous data and to fix them. True False TRUE ANSWER : ? YOUR ANSWER : ?
Data scrubbing is which of the following? A process to load the data in the data warehouse and to create the necessary indexes A process to upgrade the quality of data before it is moved into a data warehouse A process to upgrade the quality of data after it is moved into a data warehouse A process to reject data from the data warehouse and to create the necessary indexes TRUE ANSWER : ? YOUR ANSWER : ?
The extract process is which of the following? Capturing a subset of the data contained in various operational systems Capturing a subset of the data contained in various decision support systems Capturing all of the data contained in various operational systems Capturing all of the data contained in various decision support systems TRUE ANSWER : ? YOUR ANSWER : ?
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications. True False TRUE ANSWER : ? YOUR ANSWER : ?