Database Processing for BIS OLAP uses measures, dimensions and associations. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS BI reporting systems summarize the current status of business activities in order to predict future activities. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS A data warehouse is a database system that is optimized for operational transaction processing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The "curse of dimensionality" relates to which problem of using operational data for BI reporting? Dirty data Inconsistent data Too much data Non-integrated data Dirty data Inconsistent data Too much data Non-integrated data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . 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 both standard SQL and extensions to SQL 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 inconsistent data non-integrated data dirty data a "wrong format" problem inconsistent data non-integrated data dirty data ANSWER DOWNLOAD EXAMIANS APP