Data Warehousing Independent data marts are often created because an organization focuses on a series of short-term business objectives. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The @active data warehouse architecture includes which of the following? All of these Near real-time updates At least one data mart Data that can extracted from numerous internal and external sources All of these Near real-time updates At least one data mart 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 Separating data from one source into various sources of data Joining data from one source into various sources of data 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 A process to change data from a summary level to a detailed level ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A star schema has what type of relationship between a dimension and fact table? Many-to-many All of these One-to-one One-to-many Many-to-many All of these One-to-one One-to-many ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Data scrubbing is which of the following? A process to reject data from 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 load the data in the data warehouse and to create the necessary indexes A process to reject data from 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 load the data in the data warehouse and to create the necessary indexes ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A data mart is designed to optimize the performance for well-defined and predicable uses. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS