Database Processing for BIS Data warehouse data are usually normalized. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting systems cannot do which of the following operations? Filter data Group data Both filter and group data Modify data Filter data Group data Both filter and group data Modify data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . standard SQL only extensions to SQL only both standard SQL and extensions to SQL OLAP only standard SQL only extensions to SQL only both standard SQL and extensions to SQL OLAP only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The data warehouse DBMS needs to be the same DBMS used for the operational database. 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 Too much data Inconsistent data Dirty data Non-integrated data Too much data Inconsistent data Dirty 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 ________ . dirty data inconsistent data non-integrated data a "wrong format" problem dirty data inconsistent data non-integrated data a "wrong format" problem ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS