Question 1

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 databasesE) C) and D)
F) All of the above

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

MongoDB and SimpleDB are both examples of:

Accepted Answer

A)  Open-source databases.
B)  SQL databases.
C)  NoSQL databases.
D)  Cloud databases.E) All of the above
F) A) and C)

Question 4

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.E) All of the above
F) None of the above B

Question 5

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 6

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.E) B) and D)
F) B) and C)

Question 7

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 processingE) A) and D)
F) None of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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-oneE) A) and B)
F) A) and C)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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) C) and D)
F) All of the above

Question 14

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 15

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.E) A) and C)
F) A) and B) A

Question 16

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 17

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.E) A) and B)
F) All of the above

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.E) B) and C)
F) None of the above

Question 19

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.E) A) and C)
F) C) and D)

Question 20

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.E) B) and C)
F) None of the above

Exam 6: Foundations of Business Intelligence: Databases and Information Management

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

Correct Answer
verified

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

Correct Answer
verified

MongoDB and SimpleDB are both examples of:

Correct Answer
verified

DBMS typically include report-generating tools in order to:

Correct Answer
verified
B

Data cleansing is the same process as data scrubbing.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified
Data mining is one of the data analysis ...
View Answer

Hadoop is a(n) :

Correct Answer
verified

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

OLAP is a tool for enabling:

Correct Answer
verified
A

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

Correct Answer
verified
Student answers will vary; an example an...
View Answer

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

Correct Answer
verified

Data mining is a tool for allowing users to:

Correct Answer
verified

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

Correct Answer
verified

The project operation:

Correct Answer
verified

Exam 6: Foundations of Business Intelligence: Databases and Information Management

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

MongoDB and SimpleDB are both examples of:

Correct AnswerverifiedShow Answer

DBMS typically include report-generating tools in order to:

Correct AnswerverifiedB

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedData mining is one of the data analysis ...View AnswerShow Answer

Hadoop is a(n) :

Correct AnswerverifiedShow Answer

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

OLAP is a tool for enabling:

Correct AnswerverifiedA

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

Correct AnswerverifiedStudent answers will vary; an example an...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Data mining is a tool for allowing users to:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The project operation:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining is one of the data analysis ...
View Answer

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified
Student answers will vary; an example an...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified