Data Warehousing A data warehouse is which of the following? Contains numerous naming conventions and formats. Contains only current data. Can be updated by end users. Organized around important subject areas. Contains numerous naming conventions and formats. Contains only current data. Can be updated by end users. Organized around important subject areas. ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Static extract is used for ongoing warehouse maintenance. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A multifield transformation does which of the following? Converts data from multiple fields into one field All of these Converts data from multiple fields into multiple fields Converts data from one field into multiple fields Converts data from multiple fields into one field All of these Converts data from multiple fields into multiple fields Converts data from one field into multiple fields ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Fact tables are which of the following? Partially denoralized Completely normalized Partially normalized Completely denoralized Partially denoralized Completely normalized Partially normalized Completely denoralized ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The generic two-level data warehouse architecture includes which of the following? All of these Near real-time updates Data that can extracted from numerous internal and external sources At least one data mart All of these Near real-time updates Data that can extracted from numerous internal and external sources At least one data mart ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Data transformation includes which of the following? 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 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 ANSWER DOWNLOAD EXAMIANS APP