Data Warehousing Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A data warehouse is which of the following? Contains only current data. Organized around important subject areas. Can be updated by end users. Contains numerous naming conventions and formats. Contains only current data. Organized around important subject areas. Can be updated by end users. Contains numerous naming conventions and formats. ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A goal of data mining includes which of the following? To confirm that data exists To explain some observed event or condition To create a new data warehouse To analyze data for expected relationships To confirm that data exists To explain some observed event or condition To create a new data warehouse To analyze data for expected relationships ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The generic two-level data warehouse architecture includes which of the following? At least one data mart Near real-time updates All of these Data that can extracted from numerous internal and external sources At least one data mart Near real-time updates All of these Data that can extracted from numerous internal and external sources ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Data transformation includes which of the following? A process to change data from a detailed level to a summary level A process to change data from a summary level to a detailed level Joining data from one source into various sources of data Separating data from one source into various sources of data A process to change data from a detailed level to a summary level A process to change data from a summary level to a detailed level Joining data from one source into various sources of data Separating data from one source into various sources of data ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The role of the ETL process is to identify erroneous data and to fix them. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS