Question 1

A data warehouse is typically comprised of several smaller data marts.

Accepted Answer

A) True 
 B)False

Question 2

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Accepted Answer

A)  it typically focuses on a single subject area or line of business. 
B)  all the information is historical. 
C)  it uses a web interface. 
D)  all of the information belongs to a single company. 
E)  it is open-source. 
A)  it typically focuses on a single subject area or line of business. 
B)  all the information is historical. 
C)  it uses a web interface. 
D)  all of the information belongs to a single company. 
E)  it is open-source.

Question 3

Hadoop is a(n):

Accepted Answer

A)  NoSQL database technology that stores both data and procedures acting on the data as objects. 
B)  data mining platform designed for storing and analyzing big data produced by web communications and transactions. 
C)  open-source software framework designed for distributing data-processing over inexpensive computers. 
D)  pre-configured hardware-software system designed for analyzing big data. 
E)  high-speed platform used to analyze large data sets. 
A)  NoSQL database technology that stores both data and procedures acting on the data as objects. 
B)  data mining platform designed for storing and analyzing big data produced by web communications and transactions. 
C)  open-source software framework designed for distributing data-processing over inexpensive computers. 
D)  pre-configured hardware-software system designed for analyzing big data. 
E)  high-speed platform used to analyze large data sets.

Question 4

Links coming out of an online document are a sign of:

Accepted Answer

A)  richness or variety of topics covered. 
B)  popularity. 
C)  data quality. 
D)  data usage. 
E)  marketing. 
A)  richness or variety of topics covered. 
B)  popularity. 
C)  data quality. 
D)  data usage. 
E)  marketing.

Question 5

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Accepted Answer

A)  Hadoop 
B)  web mining 
C)  text mining 
D)  OLAP 
E)  DBMS 
A)  Hadoop 
B)  web mining 
C)  text mining 
D)  OLAP 
E)  DBMS

Question 6

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

Accepted Answer

These events often occur because of redu

Question 7

In clustering, a data mining tool will find:

Accepted Answer

A)  new groupings within data. 
B)  related predictions from existing values. 
C)  several events grouped by time. 
D)  new associations. 
E)  forecasts for future events. 
A)  new groupings within data. 
B)  related predictions from existing values. 
C)  several events grouped by time. 
D)  new associations. 
E)  forecasts for future events.

Question 8

End users use a data manipulation language to manipulate data in the database.

Accepted Answer

A) True 
 B)False

Question 9

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

Accepted Answer

Data accuracy when the new data is input

Question 10

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Accepted Answer

A) True 
 B)False

Question 11

Common data quality problems include all of the following except:

Accepted Answer

A)  misspelled names. 
B)  transposed numbers. 
C)  incorrect codes. 
D)  missing codes. 
E)  Internet connectivity problems. 
A)  misspelled names. 
B)  transposed numbers. 
C)  incorrect codes. 
D)  missing codes. 
E)  Internet connectivity problems.

Question 12

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Accepted Answer

A) True 
 B)False

Question 13

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

Accepted Answer

A) True 
 B)False

Question 14

The two key services of Hadoop are HDFS and in-memory computing.

Accepted Answer

A) True 
 B)False

Question 15

The select operation:

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  specifies the content of the database. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  specifies the content of the database.

Question 16

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to determine future behavior.

Accepted Answer

A) True 
 B)False

Question 17

In-memory computing relies on a computer's main memory for storing data.

Accepted Answer

A) True 
 B)False

Question 18

A small publishing company that you work for would like to develop a database that keeps track of the contracts that authors and publishers sign before starting a book. What fields do you anticipate needing for this database? Identify at least seven fields. Which of these fields might be in use in other databases within the firm?

Accepted Answer

Author first name, author last name, aut

Question 19

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

Big data are datasets with volumes so hu

Question 20

Which of the following statements about data warehouses is not true?

Accepted Answer

A)  They store supply data to be used across the enterprise for management analysis and decision making. 
B)  Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. 
C)  They may include data from website transactions. 
D)  Data warehouse systems provide easy-to-use tools for managers to easily update data. 
E)  Data warehouses make data available for anyone to access as needed. 
A)  They store supply data to be used across the enterprise for management analysis and decision making. 
B)  Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. 
C)  They may include data from website transactions. 
D)  Data warehouse systems provide easy-to-use tools for managers to easily update data. 
E)  Data warehouses make data available for anyone to access as needed.

A data warehouse is typically comprised of several smaller data marts.

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Hadoop is a(n):

Links coming out of an online document are a sign of:

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

In clustering, a data mining tool will find:

End users use a data manipulation language to manipulate data in the database.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Common data quality problems include all of the following except:

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

The two key services of Hadoop are HDFS and in-memory computing.

The select operation:

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to determine future behavior.

In-memory computing relies on a computer's main memory for storing data.

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Which of the following statements about data warehouses is not true?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

Exam 6: Foundations of Business Intelligence: Databases and

A data warehouse is typically comprised of several smaller data marts.

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Hadoop is a(n):

Links coming out of an online document are a sign of:

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Why might you receive multiple pieces of the same piece of mail, or multiple emails featuring the same promotion?

In clustering, a data mining tool will find:

End users use a data manipulation language to manipulate data in the database.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What difficulties do you anticipate?

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Common data quality problems include all of the following except:

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

The two key services of Hadoop are HDFS and in-memory computing.

The select operation:

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to determine future behavior.

In-memory computing relies on a computer's main memory for storing data.

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Which of the following statements about data warehouses is not true?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters