Data Warehousing Data in the data warehouse are loaded and refreshed from operational systems. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing A star schema has what type of relationship between a dimension and fact table? Many-to-many One-to-one One-to-many All of these Many-to-many One-to-one One-to-many All of these ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The load and index 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 after it is moved into a data warehouse 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 load the data in the data warehouse and to create the necessary indexes 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 A process to upgrade the quality of data before it is moved into a data warehouse ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The generic two-level data warehouse architecture includes which of the following? At least one data mart Data that can extracted from numerous internal and external sources Near real-time updates All of these At least one data mart Data that can extracted from numerous internal and external sources Near real-time updates All of these ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing 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 after it is moved into a data warehouse 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 load the data in the data warehouse and to create the necessary indexes 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 A process to upgrade the quality of data before it is moved into a data warehouse ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Periodic data are data that are physically altered once added to the store. True False True False ANSWER DOWNLOAD EXAMIANS APP