Question 1

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationships and is used when you are trying to discover data and new relationships, and is used to answer questions such as, are there any product sales that are related in time to other product sales. In contrast, OLAP is used to analyze multiple dimensions of data and is used to find answers to complex, but known, questions, such as what were sales of a product broken down by month and geographical region, and compared to sales forecasts. I would advise a company to use OLAP when they needed to analyze sales in different areas or for different products to see complex views of data.

Question 2

OLAP is a tool for enabling:

Accepted Answer

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. 
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. A

Question 3

DBMS typically include report-generating tools in order to:

Accepted Answer

A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis. 
A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis. B

Question 4

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Accepted Answer

A) True 
 B)False

Question 5

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

Student answers will vary; an example an

Question 6

MongoDB and SimpleDB are both examples of:

Accepted Answer

A) Open-source databases. 
B) SQL databases. 
C) NoSQL databases. 
D) Cloud databases. 
A) Open-source databases. 
B) SQL databases. 
C) NoSQL databases. 
D) Cloud databases.

Question 7

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 8

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?

Accepted Answer

Data mining is one of the data analysis

Question 9

What are the relationships that the relational database is named for?

Accepted Answer

A) Relationships between rows and columns 
B) Relationships between entities 
C) Relationships between fields and records 
D) Relationships between databases 
A) Relationships between rows and columns 
B) Relationships between entities 
C) Relationships between fields and records 
D) Relationships between databases

Question 10

In a table for customers, the information about a single customer would reside in a single:

Accepted Answer

A) field. 
B) row. 
C) column. 
D) table. 
A) field. 
B) row. 
C) column. 
D) table.

Question 11

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. 
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.

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

The project 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) organizes elements into segments. 
D) identifies the table from which the columns will be selected. 
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) organizes elements into segments. 
D) identifies the table from which the columns will be selected.

Question 14

The type of logical database model that treats data as if they were stored in two-dimensional tables is the:

Accepted Answer

A) two-tiered DBMS. 
B) pre-digital DBMS. 
C) relational DBMS. 
D) hierarchical DBMS. 
A) two-tiered DBMS. 
B) pre-digital DBMS. 
C) relational DBMS. 
D) hierarchical DBMS.

Question 15

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

A) True 
 B)False

Question 16

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

Accepted Answer

A) one-to-many 
B) one-to-one 
C) many-to-many 
D) many-to-one 
A) one-to-many 
B) one-to-one 
C) many-to-many 
D) many-to-one

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Data mining is a tool for allowing users to:

Accepted Answer

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. 
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.

Question 19

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

Accepted Answer

A) batch processing 
B) data redundancy 
C) data independence 
D) online processing 
A) batch processing 
B) data redundancy 
C) data independence 
D) online processing

Question 20

A field identified in a table as holding the unique identifier of the table's records is called the:

Accepted Answer

A) primary key. 
B) key field. 
C) primary field. 
D) foreign key. 
A) primary key. 
B) key field. 
C) primary field. 
D) foreign key.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

OLAP is a tool for enabling:

DBMS typically include report-generating tools in order to:

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

MongoDB and SimpleDB are both examples of:

Data cleansing is the same process as data scrubbing.

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?

What are the relationships that the relational database is named for?

In a table for customers, the information about a single customer would reside in a single:

Hadoop is a(n):

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

The project operation:

The type of logical database model that treats data as if they were stored in two-dimensional tables is the:

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

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

Data mining is a tool for allowing users to:

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

A field identified in a table as holding the unique identifier of the table's records is called the:

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: Enterprise Applications

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 Information Management

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

OLAP is a tool for enabling:

DBMS typically include report-generating tools in order to:

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

MongoDB and SimpleDB are both examples of:

Data cleansing is the same process as data scrubbing.

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?

What are the relationships that the relational database is named for?

In a table for customers, the information about a single customer would reside in a single:

Hadoop is a(n):

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

The project operation:

The type of logical database model that treats data as if they were stored in two-dimensional tables is the:

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

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

Data mining is a tool for allowing users to:

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

A field identified in a table as holding the unique identifier of the table's records is called the:

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: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters