A data warehouse is a database system that is optimized for operational transaction processing. False True TRUE ANSWER : ? YOUR ANSWER : ?
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 TRUE ANSWER : ? YOUR ANSWER : ?
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes? Pull OLAP RFM Push TRUE ANSWER : ? YOUR ANSWER : ?
Business Intelligence (BI) systems do not obtain data from operational databases. True False TRUE ANSWER : ? YOUR ANSWER : ?
The "F" in RFM analysis stands for ________ . frequently fast food fantasy freshness TRUE ANSWER : ? YOUR ANSWER : ?
Business Intelligence (BI) reporting analyses can be performed using ________ . OLAP only standard SQL only both standard SQL and extensions to SQL extensions to SQL only TRUE ANSWER : ? YOUR ANSWER : ?
In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group. False True TRUE ANSWER : ? YOUR ANSWER : ?
The data warehouse DBMS needs to be the same DBMS used for the operational database. False True TRUE ANSWER : ? YOUR ANSWER : ?
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 ________ . lift the basic probability support confidence TRUE ANSWER : ? YOUR ANSWER : ?