Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . OLAP only extensions to SQL only both standard SQL and extensions to SQL standard SQL only OLAP only extensions to SQL only both standard SQL and extensions to SQL standard SQL only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ . the basic probability lift support confidence the basic probability lift support confidence 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 ________ . inconsistent data non-integrated data dirty data a "wrong format" problem inconsistent data non-integrated data dirty data a "wrong format" problem ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Data mining applications are used accomplish which of the following tasks? Process transactions only Do RFM analysis only Do both RFM and what-if analysis Do what-if analysis only Process transactions only Do RFM analysis only Do both RFM and what-if analysis Do what-if analysis only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Data warehouse data are usually normalized. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS A BI reporting system does not ________ . deliver information to users on a timely basis use disparate data sources use statistical procedures to predict future events create meaningful information deliver information to users on a timely basis use disparate data sources use statistical procedures to predict future events create meaningful information ANSWER DOWNLOAD EXAMIANS APP