Business Intelligence (BI) reporting analyses can be performed using ________ . extensions to SQL only both standard SQL and extensions to SQL OLAP only standard SQL only TRUE ANSWER : ? YOUR ANSWER : ?
In OLAP, we are interested in ________ . measures and dimensions levels only measures only dimensions only TRUE ANSWER : ? YOUR ANSWER : ?
BI reporting systems summarize the current status of business activities in order to predict future activities. True False TRUE ANSWER : ? YOUR ANSWER : ?
RFM analysis uses customer's purchasing patterns to ________ . predict future sales using regression techniques perform OLAP record transactions analyze and rank customers TRUE ANSWER : ? YOUR ANSWER : ?
The reports generated by a reporting system are usually not delivered in which of the following media? Web portal E-Mail Commercial courier service Digital dashboard TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an unsupervised data mining technique? Both Regression Analysis and RFM Analysis Regression Analysis only RFM Analysis only Cluster analysis only TRUE ANSWER : ? YOUR ANSWER : ?
Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data. True False TRUE ANSWER : ? YOUR ANSWER : ?
OnLine Analytical Processing (OLAP) is a BI reporting system. True False 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 data purchased from data vendors Process transactions Process extracts from operational databases 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 a "wrong format" problem dirty data TRUE ANSWER : ? YOUR ANSWER : ?