Business Intelligence (BI) reporting analyses can be performed using ________ . extensions to SQL only standard SQL only both standard SQL and extensions to SQL OLAP only TRUE ANSWER : ? YOUR ANSWER : ?
Business Intelligence (BI) systems do not obtain their data by which of the following means? Read and process data from an operational database Process extracts from operational databases Process data purchased from data vendors Process transactions TRUE ANSWER : ? YOUR ANSWER : ?
A BI reporting system does not ________ . create meaningful information use statistical procedures to predict future events deliver information to users on a timely basis use disparate data sources TRUE ANSWER : ? YOUR ANSWER : ?
A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business. True False 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 ________ . confidence the basic probability lift support TRUE ANSWER : ? YOUR ANSWER : ?
Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making. False True TRUE ANSWER : ? YOUR ANSWER : ?
Most operational databases can be used for many BI applications. True False 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 : ?