Question 1

What are the similarities and differences between a data warehouse and a data mart?

Accepted Answer

A data warehouse stores current and hist...

Question 2

Data mining is a tool for allowing users to:

Accepted Answer

A)   quickly compare transaction data gathered over many years.
B)   perform multidimensional data analysis.
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)   find hidden relationships in data.F) A) and C)
G) B) and C)

Question 3

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.

Accepted Answer

A)   data management
B)   data administration
C)   server administration
D)   data modeling
E)   database administrationF) A) and B)
G) B) and E)

Question 4

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Accepted Answer

Text mining and web mining techniques wo...

Question 5

Non-relational databases:

Accepted Answer

A)   store information in an unstructured format.
B)   use rows and columns to organize data.
C)   are used to store structured and unstructured data.
D)   are used to store low volumes of transactional data.
E)   use database-mapping to normalize relations.F) A) and E)
G) A) and B)

Question 6

Hadoop is an open source software framework for processing large quantities of any type of data, including video and Twitter feeds.

Accepted Answer

A) True 
 B)False

Question 7

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Accepted Answer

A) True 
 B)False

Question 8

A foreign key is a field that links to a separate table.

Accepted Answer

A) True 
 B)False

Question 9

A logical view of data shows data as it is organized on the storage media.

Accepted Answer

A) True 
 B)False

Question 10

OLAP is a tool that enables users to:

Accepted Answer

A)   obtain online answers to ad hoc questions in a rapid amount of time.
B)   view both logical and physical views of data.
C)   quickly diagram data relationships.
D)   normalize data.
E)   find hidden patterns in large databases.F) A) and B)
G) B) and E)

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

Question 12

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

Accepted Answer

A)   DSS.
B)   business intelligence infrastructure.
C)   OLAP.
D)   data mining.
E)   in-memory computing.F) C) and D)
G) A) and B)

Question 13

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Accepted Answer

A)   Gartner
B)   Fortune
C)   IBM
D)   Microsoft
E)   FacebookF) B) and C)
G) B) and E)

Question 15

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 16

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.

Accepted Answer

A)   data mart
B)   data warehouse
C)   dashboard
D)   data lake
E)   relational DBMSF) B) and C)
G) None of the above

Question 17

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 18

Text mining is the discovery of useful patterns on the web.

Accepted Answer

A) True 
 B)False

Question 19

The select operation in a relational database joins records from different tables.

Accepted Answer

A) True 
 B)False

Question 20

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships: ...

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

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Correct AnswerverifiedShow Answer

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedBig data are datasets with volumes so hu...View AnswerShow Answer

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.

Correct AnswerverifiedShow Answer

The select operation in a relational database joins records from different tables.

Correct AnswerverifiedShow Answer

Common data quality problems include all of the following except:

Correct AnswerverifiedShow Answer

Hadoop is an open source software framework for processing large quantities of any type of data, including video and Twitter feeds.

Correct AnswerverifiedShow Answer

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

Correct AnswerverifiedShow Answer

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Correct AnswerverifiedShow Answer

Non-relational databases:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Correct AnswerverifiedText mining and web mining techniques wo...View AnswerShow Answer

A logical view of data shows data as it is organized on the storage media.

Correct AnswerverifiedShow Answer

A foreign key is a field that links to a separate table.

Correct AnswerverifiedShow Answer

OLAP is a tool that enables users to:

Correct AnswerverifiedShow Answer

What are the similarities and differences between a data warehouse and a data mart?

Correct AnswerverifiedA data warehouse stores current and hist...View AnswerShow Answer

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.

Correct AnswerverifiedShow Answer

Text mining is the discovery of useful patterns on the web.

Correct AnswerverifiedShow Answer

What types of relationships are possible in a relational database? Describe and give an example of each.

Correct AnswerverifiedThere are three types of relationships: ...View AnswerShow Answer

Data mining is a tool for allowing users to:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Big data are datasets with volumes so hu...
View 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
Text mining and web mining techniques wo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse stores current and hist...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There are three types of relationships: ...
View Answer

Correct Answer
verified