Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . OLAP only both standard SQL and extensions to SQL standard SQL only extensions to SQL only OLAP only both standard SQL and extensions to SQL standard SQL only extensions to SQL only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means. False True False True 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 ________ . dirty data a "wrong format" problem non-integrated data inconsistent data dirty data a "wrong format" problem non-integrated data inconsistent data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The "curse of dimensionality" relates to which problem of using operational data for BI reporting? Non-integrated data Inconsistent data Dirty data Too much data Non-integrated data Inconsistent data Dirty data Too much data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The data warehouse DBMS needs to be the same DBMS used for the operational database. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS