Database Processing for BIS A data warehouse is a database system that is optimized for operational transaction processing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS In OLAP, we are interested in ________ . dimensions only measures and dimensions levels only measures only dimensions only measures and dimensions levels only measures only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Report types include static, dynamic, query and OLAP. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ . a "wrong format" problem dirty data non-integrated data inconsistent data a "wrong format" problem dirty data non-integrated data inconsistent data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Which of the following is not a component of a data warehouse? Data extraction/cleaning/preparation programs Data metadata None of these Data warehouse data Data extraction/cleaning/preparation programs Data metadata None of these Data warehouse data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS RFM analysis uses customer's purchasing patterns to ________ . perform OLAP analyze and rank customers record transactions predict future sales using regression techniques perform OLAP analyze and rank customers record transactions predict future sales using regression techniques ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS