56. All of the following are technologies used to analyze and manage big data except
A) noSQL.
B) analytic platforms.
C) cloud computing.
D) in–memory computing.
57. A nationwide magazine publisher has hired you to help analyze their social media datasets to determine
which of their news publications are seen as the most trustworthy. Which of the following tools would you
use to analyze this data?
A) data mining software for identifying associations
B) Web usage mining technologies
C) sentiment analysis software
D) text mining tools
58. The tool that enables users to view the same data in different ways using multiple dimensions is
A) OLAP.
B) data mining.
C) SQL.
D) predictive analysis.
59. OLAP is a tool for enabling
A) users to view both logical and physical views of data.
B) users to obtain online answers to ad–hoc questions in a rapid amount of time.
C) programmers to quickly diagram data relationships.
D) programmers to normalize data.
60. Data mining is a tool for allowing users to
A) obtain online answers to ad–hoc questions in a rapid amount of time.
B) summarize massive amounts of data into much smaller, traditional reports.
C) find hidden relationships in data.
D) quickly compare transaction data gathered over many years.
61. In terms of data relationships, associations refers to
A) occurrences linked to a single event.
B) undiscovered groupings.
C) patterns that describe a group to which an item belongs.
D) events linked over time.
62. ________ tools are used to analyze large unstructured data sets, such as e–mail, memos, survey responses,
etc., to discover patterns and relationships.
A) In–memory
B) OLAP
C) Text mining
D) Clustering
63. An alternative to using application server software for interfacing between a Web server and back–end
databases is
A) CGI.
B) SQL.
C) Java.
D) HTML.
64. The organization‘s rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying
information is called a(n)
A) data definition file.
B) data governance policy.
C) data quality audit.
D) information policy.
65. The special organizational function whose responsibilities include physical database design and
maintenance, is called
A) data administration.
B) information policy administration.
C) data auditing.
D) database administration.
66. 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 redundancy
B) data inconsistency
C) data normalization
D) data accuracy
67. Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or
redundant is called
A) data optimization.
B) data auditing.
C) data scrubbing.
D) defragmentation.
68. You are creating a database to store temperature and wind data from national airport locations. Which of the
following fields is the most likely candidate to use as the basis for a primary key in the Airport table?
A) address
B) state
C) city
D) airport code
69. Data cleansing not only corrects errors but also
A) structures data.
B) establishes logical relationships between data.
C) enforces consistency among different sets of data.
D) normalizes data.
70. Which of the following is not a method for performing a data quality audit?
A) surveying entire data files
B) surveying data definition and query files
C) surveying samples from data files
D) surveying end users about their perceptions of data quality
71. Databases record information about general categories of information referred to as ________.
72. To analyze unstructured data, such as memos and legal cases, you would use ________ tools.
73. A(n) ________ view shows data as it is actually organized and structured on the data storage media.
74. DBMS have a(n) ________ capability to specify the structure of the content of the database.
75. Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.
76. In a client/server environment, a DBMS is located on a dedicated computer called a(n) ________.
77. In ________, a data mining tool discovers different groupings within data, such as finding affinity groups for
bank cards.
78. High–speed ________ use both relational and non–relational tools to analyze large datasets.
79. A(n) ________ is software that handles all application operations between browser–based computers and a
company’s back–end business applications or databases.
80. In data mining, the technique of ________ uses a series of existing values to predict what other values will be.
81. The small publishing company you work for wants to create a new database for storing information about all
of their author contracts. What factors will influence how you design the database?
82. When you design the new contracts database for the publishing house mentioned above, what fields do you
anticipate needing? Which of these fields might be in use in other databases used by the company?
83. List at least three conditions that contribute to data redundancy and inconsistency.
84. List and describe three main capabilities or tools of a DBMS.
85. 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.
86. Identify and describe three basic operations used to extract useful sets of data from a relational database.
87. Describe the ways in which database technologies could be used by an office stationery supply company to
achieve low–cost leadership.
88. Describe the ways in which database technologies could be used by a toy manufacturer to achieve product
differentiation.
89. 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?
90. What are the differences between data mining and OLAP? When would you advise a company to use
OLAP?
