47) Identify and describe three basic operations used to extract useful sets of data from a
relational database.
48) Big data does not refer to
A) datasets with fewer than a billion records.
B) datasets with unstructured data.
C) machine-generated data (i.e. from sensors).
D) data created by social media (i.e. tweets, Facebook Likes).
E) data from Web traffic.
49) Which of the following technologies would you use to analyze the social media data
collected by a major online retailer?
A) OLAP
B) data warehouse
C) data mart
D) Hadoop
E) DBMS
50) Which of the following is not one of the techniques used in Web mining?
A) content mining
B) structure mining
C) server mining
D) usage mining
E) data mining
51) You work for a retail clothing chain whose primary outlets are in shopping malls, and you
are conducting an analysis of your customers and their preferences. You wish to find out if there
are any particular activities that your customers engage in, or the types of purchases made in the
month before or after purchasing select items from your store. To do this, you will want to use
data mining software that is capable of
A) identifying associations.
B) identifying clusters.
C) identifying sequences.
D) classification.
E) forecasting.
52) You work for a national car rental agency and want to determine what characteristics are
shared among your most loyal customers. To do this, you will want to use data mining software
that is capable of
A) identifying associations.
B) identifying clusters.
C) identifying sequences.
D) classification.
E) forecasting.
53) A data warehouse is composed of
A) historical data from legacy systems.
B) current data.
C) internal and external data sources.
D) historic and current internal data.
E) historic external data.
54) All of the following are technologies used to analyze and manage big data except
A) cloud computing.
B) noSQL.
C) in-memory computing.
D) analytic platforms.
E) Hadoop.
55) A household appliances manufacturer has hired you to help analyze their social media
datasets to determine which of their refrigerators are seen as the most reliable. Which of the
following tools would you use to analyze this data?
A) text mining tools
B) sentiment analysis software
C) Web usage mining technologies
D) data mining software for identifying associations
E) data mining software for forecasting
56) The tool that enables users to view the same data in different ways using multiple dimensions
is
A) predictive analysis.
B) SQL.
C) OLAP.
D) data mining.
E) Hadoop.
57) OLAP is a tool for enabling
A) users to obtain online answers to ad-hoc questions in a rapid amount of time.
B) users to view both logical and physical views of data.
C) programmers to quickly diagram data relationships.
D) programmers to normalize data.
E) users to quickly generate summary reports.
58) Data mining is a tool for allowing users to
A) quickly compare transaction data gathered over many years.
B) find hidden relationships in data.
C) obtain online answers to ad-hoc questions in a rapid amount of time.
D) summarize massive amounts of data into much smaller, traditional reports.
E) access the vast amounts of data in a data warehouse.
59) In terms of data relationships, associations refers to
A) events linked over time.
B) patterns that describe a group to which an item belongs.
C) occurrences linked to a single event.
D) undiscovered groupings.
E) relationships between different customers.
60) ________ tools are used to analyze large unstructured data sets, such as e-mail, memos,
survey responses, etc., to discover patterns and relationships.
A) OLAP
B) Text mining
C) In-memory
D) Clustering
E) Classification
61) In place of application server software to allow a Web server to communicate with a back-
end database, you can use
A) CGI.
B) HTML.
C) Java.
D) SQL.
E) NoSQL.
62) HTML has become the preferred method of communicating with back-end databases because
it is a cross-platform language.
63) Legacy systems are used to populate and update data warehouses.
64) Multiple data marts are combined and streamlined to create a data warehouse.
65) To perform multidimensional data analysis, you would use OLAP.
66) OLAP is unable to manage and handle queries with very large sets of data.
67) With in-memory computing, a computer’s primary memory (RAM) is used for processing.
68) An application that transfers information from an organization’s internal database to a Web
server for delivery as part of a Web page to the user is called middleware.
69) Implementing a Web interface for an organization’s internal database usually requires
substantial changes to be made to the database.
70) You can manipulate data on a Web server by using a CGI script.
71) To analyze unstructured data, such as memos and legal cases, you would use text mining
tools.
72) In a client/server environment, a DBMS is located on a dedicated computer called a Web
server.
73) In associations, a data mining tool discovers different groupings within data, such as finding
affinity groups for bank cards.
74) High-speed analytic platforms use both relational and non-relational tools to analyze large
datasets.
75) A database server is software that handles all application operations between browser-based
computers and a company’s back-end business applications or databases.
76) In data mining, the technique of predicting uses a series of existing values to determine what
other future values will be.
77) You have been hired by a national furniture leasing company to implement its first business
intelligence systems and infrastructure. To prepare for your initial report, describe the types of
data in their firm they can use to support business intelligence and the systems that you will
implement to support both their power users and casual users, and explain how these systems or
tools work together.
78) Describe the ways in which database technologies could be used by an office stationery
supply company to achieve low-cost leadership.
79) Describe the ways in which database technologies could be used by a toy manufacturer to
achieve product differentiation.
80) What makes data mining an important business tool? What types of information does data
mining produce? In what type of circumstance would you advise a company to use data mining?
81) What are the differences between data mining and OLAP? When would you advise a
company to use OLAP?
82) The organization’s rules for sharing, disseminating, acquiring, standardizing, classifying, and
inventorying information is called a(n)
A) information policy.
B) data definition file.
C) data quality audit.
D) data governance policy.
E) data policy.
83) The special organizational function whose responsibilities include physical database design
and maintenance is called
A) data administration.
B) database administration.
C) information policy administration.
D) data auditing.
E) database management.
84) Which common database challenge is illustrated by a person receiving multiple copies of an
L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?
A) data normalization
B) data accuracy
C) data redundancy
D) data inconsistency
E) data duplication
85) Detecting and correcting data in a database or file that are incorrect, incomplete, improperly
formatted, or redundant is called
A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
E) data normalization.
86) Data cleansing not only corrects errors but also
A) establishes logical relationships between data.
B) structures data.
C) normalizes data.
D) removes duplicate data.
E) enforces consistency among different sets of data.
87) Which of the following is not a method for performing a data quality audit?
A) surveying entire data files
B) surveying samples from data files
C) surveying data definition and query files
D) surveying end users about their perceptions of data quality
E) surveying managers about their perceptions of data quality
88) The policies and processes for managing the integrity and security of data in a firm are
referred to as data governance.
89) The organizational function that is in charge of policies and procedures for managing internal
data resources is called data administration.
90) Data scrubbing is a more intensive corrective process than data cleansing.