Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Management
Q:
DTD stands for Document Type Declaration.
Q:
SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.
Q:
Unlike SQL views, XML views are not limited to one multivalued path.
Q:
JSON stands for Jason Script Object Notation.
Q:
XML stands for Extensible Markup Language.
Q:
A document database may use either XML or JSON as the basis for storing data.
Q:
The key-value database uses columns.
Q:
The CAP theorem defines the three properties, one of which is partition tolerance.
Q:
The CAP theorem defines the three properties, one of which is authorization.
Q:
The CAP theorem defines the three properties, one of which is consistency.
Q:
One of the four categories of NoSQL databases used in the text is the Graphical database.
Q:
One of the four categories of NoSQL databases used in the text is the Column Family database.
Q:
One of the four categories of NoSQL databases used in the text is the Word Processing database.
Q:
One of the four categories of NoSQL databases used in the text is the Key-Value database.
Q:
What is a data warehouse?
Q:
Why is operational data sometimes unusable for Business Intelligence purposes?
Q:
What is data mining application?
Q:
Market basket analysis, as described in the text, uses the statistical technique of ________.
Q:
A report that is sent to users on a predetermined schedule is called a(n) ________ report.
Q:
Reports that rely on the most current data when they are prepared are called ________ reports.
Q:
In a common form of RFM analysis, customers with an F score of ________ are in the 20% of customers who have the most frequent orders.
Q:
In a common form of RFM analysis, customers are sorted into ________ groups and given an associated score depending on their group.
Q:
In RFM analysis, R stands for ________.
Q:
________ is a way of analyzing and ranking customers based on their purchasing patterns.
Q:
BI ________ are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.
Q:
Problematic data are called ________.
Q:
Refer to the table above. What is the lift for Drug B being purchased given that Drug A has been purchased?
A) .200
B) .250
C) .333
D) .500
E) .667
Q:
Refer to the table above. What is the confidence of Drug B being purchased given that Drug A has been purchased?
A) .200
B) .250
C) .333
D) .400
E) .500
Q:
Refer to the table above. What is the definition of confidence for Drug B with reference to Drug A?
A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased
Q:
Refer to the table above.What is the support for Drug A and Drug B?
A) .025
B) .075
C) .100
D) .125
E) .200
Q:
Refer to the table above.What is the definition of support for Drug A and Drug B?
A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased
Q:
Market basket analysis is:
A) a data mart specific technique.
B) a reporting technique.
C) an RFM application.
D) an OLAP application.
E) a data mining technique.
Q:
Which of the following popular data mining techniques require special software?
A) Decision tree analysis
B) Logistic regression analysis
C) Neural networks
D) A and B
E) A, B and C
Q:
Which of the following is a common supervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) Both A and B
E) All of the above
Q:
Which of the following is a common unsupervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) Both A and B
E) All of the above
Q:
Data mining techniques are used to find patterns and relationships that can be used to:
A) report.
B) classify.
C) predict.
D) Both B and C
E) All of the above
Q:
A report generated by a reporting system is delivered to the appropriate users via a printed report. This system uses which of the following report modes?
A) Push
B) Pull
C) Query
D) OLAP
E) None of the above
Q:
The reports generated by a reporting system can be delivered in which of the following media?
A) Paper
B) Web portal
C) Digital dashboard
D) E-mail
E) All of the above
Q:
A report generated by a reporting system is delivered to the appropriate users via an electronic display customized for each user. This system uses which of the following media?
A) Paper
B) Web portal
C) Digital dashboard
D) E-mail
E) None of the above
Q:
The reports generated by a reporting system can be classified as:
A) static.
B) dynamic.
C) fluid.
D) Both A and B
E) All of the above
Q:
The metadata maintained by a reporting system database describes:
A) reports.
B) users.
C) groups.
D) roles.
E) All of the above
Q:
We have done an RFM analysis on our customer data. John Smith has a score of "5 1 1." This means that John:
A) has ordered recently, and orders a lot when he orders.
B) hasn't ordered recently, but orders a lot when he orders.
C) has ordered recently, but doesn't order a lot when he orders.
D) hasn't ordered recently, and doesn't order a lot when he orders.
E) None of the above is correct.
Q:
RFM scores commonly range from ________, with ________ being the "high" or "most desirable" score.
A) 0 to 5; 0
B) 0 to 5; 5
C) 1 to 5, 1
D) 1 to 5; 5
E) 1 to 10; 10
Q:
The "R" in RFM analysis stands for:
A) rank.
B) recent.
C) relationship.
D) readiness.
E) random.
Q:
RFM analysis analyzes and ranks customers based on:
A) their purchasing patterns.
B) their income status.
C) their residential location.
D) Both A and B
E) All of the above
Q:
A BI reporting system:
A) creates meaningful information from disparate data sources.
B) delivers information to users on a timely basis.
C) uses statistical procedures to predict future events.
D) Both A and B
E) All of the above
Q:
Which of the following are components of a data warehouse?
A) Data extract, transform, and load (ETL) preparation programs
B) Data warehouse data
C) Data warehouse metadata
D) B and C
E) A, B and C
Q:
We have obtained access to the company's operational data. We have been asked to produce a report with an item by item analysis of sales, but the only sales figure available is the total sale value for each order. This is an example of:
A) dirty data.
B) inconsistent data.
C) nonintegrated data.
D) a "wrong format" problem.
E) a "too much data" problem.
Q:
Which of the following are true about data mining applications?
A) They use sophisticated mathematical techniques.
B) They use sophisticated statistical techniques.
C) Their report delivery is more difficult than report delivery for reporting systems.
D) Both A and B
E) All of the above
Q:
One Business Intelligence (BI) reporting system that uses extensions to SQL is:
A) cluster analysis.
B) OLAP.
C) regression analysis.
D) RFM analysis.
E) All of the above
Q:
In market basket analysis, lift is confidence divided by support.
Q:
In market basket analysis, confidence is the probability that one particular product will be purchased.
Q:
In market basket analysis, support is defined as the probability that two items will be purchased together.
Q:
Market basket analysis as described in the text uses the technique of conditional probabilities.
Q:
Market basket analysis is a data mining technique for determining which sets of products customers tend to purchase at the same time.
Q:
Cluster analysis is a commonly used technique in supervised data mining.
Q:
In supervised data mining, statistical techniques are used to estimate the parameters of the model.
Q:
In unsupervised data mining, a model or hypothesis is created ahead of time.
Q:
In unsupervised data mining, explanations are created after patterns are found.
Q:
Most data mining techniques are simple and easy to use.
Q:
Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict.
Q:
Report management systems include the ability to create associated user accounts and groups.
Q:
Report management defines who gets the report, how often, and how it is to be delivered.
Q:
Report authoring includes responsibility for delivery of the report.
Q:
Report systems include three functions: authoring, management and delivery.
Q:
A report that is sent to users only upon the users' request is called an on-demand report.
Q:
A report that is sent to users on a predetermined schedule is called a push report.
Q:
Reports that rely on the most current data when they are prepared are called dynamic reports.
Q:
Reports that do not change once prepared are called static reports.
Q:
Report modes include dynamic and static.
Q:
A digital dashboard is an electronic display customized for an individual user.
Q:
A reporting system does not maintain a database of metadata.
Q:
In a common form of RFM analysis, an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.
Q:
In a common form of RFM analysis, a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."
Q:
In a common form of RFM analysis, customers with an R score of 5 are in the 20% of customers who have the most recent orders.
Q:
In RFM analysis, R stands for "how recently", F stands for "how frequently" and M stands for "how many months."
Q:
RFM analysis is a way of analyzing and ranking customers based on online survey data.
Q:
BI Reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.
Q:
Report delivery is more important for data mining than it is for reporting systems.
Q:
When running the NetBeans IDE for the first time, use a default file workspace named:
A) NetBeans Workspace.
B) NetBeansProjects.
C) Documents.
D) My Documents.
E) My Workspace.