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 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 inconsistent data dirty data a "wrong format" problem non-integrated data inconsistent data dirty data a "wrong format" problem ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Market basket analysis primarily uses the technique of conditional probabilities. False True False True 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
Database Processing for BIS The "curse of dimensionality" relates to which problem of using operational data for BI reporting? Non-integrated data Dirty data Too much data Inconsistent data Non-integrated data Dirty data Too much data Inconsistent data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ . support confidence the basic probability lift support confidence the basic probability lift ANSWER DOWNLOAD EXAMIANS APP