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
Humanities
Q:
In XML Schema, there are two types of elements, simple and composite.
Q:
XML Schemas consist of elements, attributes, and properties.
Q:
An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.
Q:
XML documents and XML Schemas are created in different languages.
Q:
XML documents that conform to an XML Schema are validated against that schema.
Q:
XML Schema is a synonym for Document Type Declaration (DTD).
Q:
XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.
Q:
XML documents that do not conform to their DTD are said to be non-type-valid XML documents.
Q:
XML documents that conform to their DTD are said to be type-valid XML documents.
Q:
All type-valid XML documents are required to have a DTD.
Q:
DTD stands for Document Type Declaration.
Q:
XML designers created a system that allows document structure, data content, and materialization to be mixed.
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:
XML provides a standardized, non-customizable way to describe the content of a document.
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:
NoSQL really stands for "Not only SQL."
Q:
What is a star schema?
Q:
What is a data warehouse?
Q:
Why is operational data sometimes unusable for Business Intelligence use?
Q:
What is data mining application?
Q:
What is a reporting system?
Q:
What are Business Intelligence (BI) systems?
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) .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
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 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
Q:
Here is Market Basket data for 1,000 transactions at a Drug Store. All transactions involve 1 or 2 drugs. Use the table below to answer the following questions.1,000 TransactionsDrug A500Drug B300Drug C200Drug A0100125Drug B1002575Drug C125750No Additional Drug2751000Refer 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.
Q:
Market basket analysis is ________.A) a data mart specific techniqueB) a reporting techniqueC) an OLAP applicationD) a data mining technique
Q:
Which of the following popular data mining techniques does not require special software?
A) Decision tree analysis
B) Logistic regression analysis
C) Market basket analysis
D) Neural networks
Q:
Which of the following is a common supervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) SQL analysis
Q:
Which of the following is a common unsupervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) QBE queries
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 are correct
Q:
OLAP stands for ________.
A) Online Analytical Processing
B) Offline Analytical Processing
C) Online Analysis Process
D) Offline Analytical Process
E) Lazy, Old And Particular
Q:
A report generated by a reporting system is delivered to the appropriate users via a printed report on a pre-determined schedule. This system uses which of the following report modes?
A) Push
B) Pull
C) Query
D) OLAP
Q:
The reports generated by a reporting system can be delivered in all of the following media except ________.
A) Paper
B) Smoke signals
C) Digital dashboard
D) E-mail
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
Q:
The reports generated by a reporting system can be classified as any of the following except ________.
A) static
B) dynamic
C) fluid
D) push
Q:
The metadata maintained by a reporting system database describes all of the following except ________.
A) triggers
B) users
C) groups
D) reports
Q:
To produce the set of customers with a R score of 2, the SQL SELECT TOP ________ PERCENT syntax should be used.
A) 50
B) 33
C) 25
D) 20
Q:
RFM analysis can be done using SQL ________.
A) user-defined functions
B) stored procedures
C) triggers
D) union queries
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
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
Q:
The "R" in RFM analysis stands for ________.
A) rank
B) recent
C) relationship
D) readiness
Q:
RFM analysis analyzes and ranks customers based on ________.
A) their purchasing patterns
B) their income status
C) their residential location.
D) their age
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 are correct
Q:
A data mart differs from a data warehouse in all the following ways except ________.
A) data marts use more operational data
B) it deals with a particular component or functional area of the business
C) data mart users do not have the data management expertise of data warehouse employees
D) it has a smaller database
Q:
Which of the following is not a component of a data warehouse?
A) Data extract, transform, and load (ETL) preparation programs
B) Data warehouse data
C) Data warehouse metadata
D) Operational database updates
Q:
A data warehouse database differs from an operational database because ________.
A) data warehouse data are not stored in tables
B) data warehouse databases do not have metadata
C) data warehouse data are often stored in a dimensional database
D) efficiency does not matter in a data warehouse
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
Q:
We have obtained access to the company's operational data. We examine 50 records for customers with phone numbers that should use the current area code of 345. Of these 50 records, we find 10 that still use an older area code of 567. This is an example of ________.
A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
Q:
We have obtained access to the company's operational data. In one record, we find that a customer's age has been recorded as "337". This is an example of ________.
A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
Q:
Which of the following is not a reason that operational data are difficult to read?
A) Dirty data
B) Large values
C) Non-integrated data
D) Missing values
Q:
Which of the following is (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 are correct
Q:
Data mining applications are used accomplish all of the following tasks except ________.
A) update the database
B) make predications
C) facilitate decision making
D) perform what-if analysis
Q:
One Business Intelligence (BI) reporting system that uses extensions to SQL is ________.
A) cluster analysis
B) OLAP
C) regression analysis
D) RFM analysis
Q:
Business Intelligence (BI) reporting systems can do all of the following operations except ________.
A) filter data
B) group data
C) modify data
D) sort data
Q:
Business Intelligence (BI) systems obtain their data by all of the following means except ________.
A) read and process data from an operational database
B) triggers defined on the operational database
C) process data purchased from data vendors
D) process extracts from operational databases
Q:
Business Intelligence (BI) systems fall into which of the following categories?
A) Processing
B) Reporting
C) Data mining
D) Both B and C are correct
Q:
Business Intelligence (BI) systems do which of the following?
A) Analyze current and past activities
B) Predict future events
C) Record and process transactions
D) Both A and B are correct
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.