Database Processing for BIS In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . both standard SQL and extensions to SQL extensions to SQL only standard SQL only OLAP only both standard SQL and extensions to SQL extensions to SQL only standard SQL only OLAP only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Which of the following is not a component of a data warehouse? Data metadata None of these Data warehouse data Data extraction/cleaning/preparation programs Data metadata None of these Data warehouse data Data extraction/cleaning/preparation programs ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting systems cannot do which of the following operations? Group data Both filter and group data Filter data Modify data Group data Both filter and group data Filter data Modify data 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 ________ . non-integrated data a "wrong format" problem dirty data inconsistent data non-integrated data a "wrong format" problem dirty data inconsistent data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS In OLAP, we are interested in ________ . levels only dimensions only measures only measures and dimensions levels only dimensions only measures only measures and dimensions ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS