Database Concepts, 8e (Kroenke)
Chapter 8 Data Warehouses, Business Intelligence Systems, and Big Data
1) NoSQL really stands for “Not only SQL.”
2) Apache Cassandra is an example of a column family database.
3) Column family databases are indistinguishable from relational database tables.
4) In the MapReduce process, the Reduce step is followed by the Map step.
5) Non-relational DBMSs associated with the NoSQL movement include all of the following
except ________.
A) Key-value
B) Document
C) Column family
D) Graph
E) Hierarchical
6) Apache Cassandra is an example of a(n) ________ non-relational DBMS.
A) Key-value
B) Document
C) Column family
D) Graph
E) Object-Oriented
7) In the MapReduce process, the first step is the ________ step.
A) column
B) super column
C) column family
D) map
E) reduce
8) Hadoop is a(n) ________.
A) RDMBS
B) OODBMS
C) distributed file system (DFS)
D) print system
E) Web server
9) The term for the enormous datasets generated by Web 2.0 applications is ________.
10) Apache Cassandra is an example of a(n) ________ non-relational DBMS.
11) Hadoop is a(n) ________.
12) Business Intelligence (BI) systems are information systems that help users analyze and use
data.
13) Business Intelligence (BI) systems support operational activities.
14) Business Intelligence (BI) systems obtain data from three possible sources.
15) Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and
make simple calculations based on the data.
16) Business Intelligence (BI) reporting systems can analyze data using standard SQL.
17) BI reporting systems summarize the current status of business activities and compare that
status with past events but not with predicted future activities.
18) 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
E) Support routine operational activities
19) Business Intelligence (BI) systems fall into which of the following categories?
A) Processing
B) Reporting
C) Data mining
D) Both A and B
E) Both B and C
20) Business Intelligence (BI) reporting systems can do which of the following operations?
A) Filter data
B) Group data
C) Modify data
D) Both A and B
E) Secure data
21) A Business Intelligence (BI) reporting system that uses extensions to SQL is ________.
A) cluster analysis
B) OLAP
C) regression analysis
D) RFM analysis
E) PHP
22) Data mining applications are used to accomplish all of the following tasks except ________.
A) classify entities
B) make predictions
C) facilitate decision making
D) incorporate results into some other report/system
E) perform what-if analysis
23) Which of the following is 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 data mining applications have many different users to support.
24) A(n) ________ is an information system that helps users analyze and use data.
25) Business Intelligence (BI) systems fall into two broad categories: ________ and ________.
26) Business Intelligence (BI) systems obtain data in ________ different ways.
27) Business Intelligence (BI) ________ are used to filter data, sort data, group data and make
simple calculations based on the data.
28) Business Intelligence (BI) ________ uses sophisticated statistical and mathematical
techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
29) What are Business Intelligence (BI) systems?
30) What is a reporting system?
31) Why is operational data sometimes unusable for Business Intelligence use?
32) The simplest way to lease cloud services is SaaS.
33) When distributed databases break the database into sections and store the sections on
different servers, this is known as ________.
A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) None of the above
34) When distributed databases create copies of the database on different servers, this is known
as ________.
A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking
E) division
35) Distributed databases can be distributed by partitioning and ________.
36) Objects have ________, which are computer programs that perform some task.
37) Big Data is the name given to the enormous datasets generated by Web 2.0 applications.
38) Data Mining uses sophisticated statistical and mathematical techniques to perform what-if
analyses, to make predictions, and to facilitate decision making.
39) Report delivery is more important for data mining than it is for reporting systems.
40) Problematic data include so-called “dirty data.”
41) A data warehouse is a database system that has data and programs for, as well as personnel
specialized in, BI processing.
42) Data warehouses are populated with data prepared by extract, transform, and load (ETL)
systems.
43) A data mart is a collection of data that addresses a particular component or functional area of
a business.
44) Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Time-critical data
D) Non-integrated data
E) Inconsistent data
45) 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
E) a “too much data” problem
46) 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
E) a “too much data” problem
47) 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) both B and C
E) data warehouse databases contain unrelated tables