Question 1

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

Question 2

A DBMS makes the:

Accepted Answer

A)   relational database available for different analytical views.
B)   logical database available for different analytical views.
C)   physical database available for different relational views.
D)   relational database available for different physical views.
E)   physical database available for different logical views.F) C) and D)
G) A) and B)

Question 3

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

Accepted Answer

Data mining uncovers hidden relationship...

Question 4

A(n)  ________ is a dedicated computer in a client/server environment that hosts a DBMS.

Accepted Answer

A)   web server
B)   online server
C)   database server
D)   client server
E)   application serverF) C) and E)
G) B) and E)

Question 5

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
E)   Relationships between attributesF) A) and B)
G) C) and D)

Question 6

From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems?

Accepted Answer

A)   Online ticket sales were falling.
B)   There were too many sources of data.
C)   The entities and attributes of customer records were poorly organized.
D)   There was too much unorganized customer data for decision makers to digest.
E)   The team's computer hardware was outdated.F) None of the above
G) A) and D)

Question 7

A field identified in a record as holding the unique identifier for that record is called the:

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   foreign key.
E)   identifying field.F) All of the above
G) A) and B)

Question 8

A table that links two tables that have a many-to-many relationship is often called a(n) :

Accepted Answer

A)   derived table.
B)   intersection relation.
C)   foreign table.
D)   entity-relationship table.
E)   derived relation.F) None of the above
G) C) and D)

Question 9

Which of the following enables users to view the same data in different ways using multiple dimensions?

Accepted Answer

A)   Hadoop
B)   SQL
C)   Big data
D)   Data mining
E)   OLAPF) D) and E)
G) B) and C)

Question 10

MongoDB and SimpleDB are both examples of:

Accepted Answer

A)   open source databases.
B)   SQL databases.
C)   NoSQL databases.
D)   cloud databases.
E)   big data databases.F) None of the above
G) B) and D)

Question 11

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 12

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

Question 13

In a relational database, a record is also called a(n) :

Accepted Answer

A)   tuple.
B)   key field.
C)   entity.
D)   field.
E)   table.F) A) and D)
G) A) and C)

Question 14

Which of the following would you use to find patterns in user interaction data recorded by web servers?

Accepted Answer

A)   Web usage mining
B)   Web server mining
C)   Web structure mining
D)   Web content mining
E)   Web protocol miningF) A) and B)
G) A) and C)

Question 15

Web servers can directly access a firm's back-end databases using HTML.

Accepted Answer

A) True 
 B)False

Question 16

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)   DBMSF) C) and D)
G) B) and D)

Question 17

A data warehouse is best used for storing unstructured data.

Accepted Answer

A) True 
 B)False

Question 18

CGI is a specification for processing data on a web server.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

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

MongoDB and SimpleDB are both examples of:

Correct AnswerverifiedShow Answer

Web servers can directly access a firm's back-end databases using HTML.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A DBMS makes the:

Correct AnswerverifiedShow Answer

In a relational database, a record is also called a(n) :

Correct AnswerverifiedShow Answer

CGI is a specification for processing data on a web server.

Correct AnswerverifiedShow Answer

A field identified in a record as holding the unique identifier for that record is called the:

Correct AnswerverifiedShow Answer

Which of the following enables users to view the same data in different ways using multiple dimensions?

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

A table that links two tables that have a many-to-many relationship is often called a(n) :

Correct AnswerverifiedShow Answer

A data warehouse is best used for storing unstructured data.

Correct AnswerverifiedShow Answer

Which of the following would you use to find patterns in user interaction data recorded by web servers?

Correct AnswerverifiedShow Answer

A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.

Correct AnswerverifiedShow Answer

The select operation:

Correct AnswerverifiedShow Answer

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems?

Correct AnswerverifiedShow 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?

Correct AnswerverifiedData mining uncovers hidden relationship...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining uncovers hidden relationship...
View Answer