Data Warehousing Every key used to join the fact table with a dimensional table should be a surrogate key. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The extract process is which of the following? Capturing a subset of the data contained in various operational systems Capturing all of the data contained in various operational systems Capturing all of the data contained in various decision support systems Capturing a subset of the data contained in various decision support systems Capturing a subset of the data contained in various operational systems Capturing all of the data contained in various operational systems Capturing all of the data contained in various decision support systems Capturing a subset of the data contained in various decision support systems ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing The role of the ETL process is to identify erroneous data and to fix them. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Independent data marts are often created because an organization focuses on a series of short-term business objectives. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Fact tables are which of the following? Completely normalized Partially normalized Completely denoralized Partially denoralized Completely normalized Partially normalized Completely denoralized Partially denoralized ANSWER DOWNLOAD EXAMIANS APP
Data Warehousing Static extract is used for ongoing warehouse maintenance. False True False True ANSWER DOWNLOAD EXAMIANS APP