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 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 confidence support the basic probability lift confidence support ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS In OLAP, we are interested in ________ . levels only measures only dimensions only measures and dimensions levels only measures only dimensions only measures and dimensions ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Most operational databases can be used for many BI applications. True False True False 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 a "wrong format" problem dirty data non-integrated data inconsistent data a "wrong format" problem dirty data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . standard SQL only both standard SQL and extensions to SQL OLAP only extensions to SQL only standard SQL only both standard SQL and extensions to SQL OLAP only extensions to SQL only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS