Question 1

A(n)  ________ is a characteristic or quality that describes a database entity.

Accepted Answer

A)   field
B)   tuple
C)   key field
D)   attribute
E)   relationshipF) A) and B)
G) None of the above

Question 2

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Accepted Answer

A)   information policy.
B)   data definition file.
C)   data quality audit.
D)   data governance policy.
E)   data policy.F) A) and E)
G) C) and E)

Question 3

To perform multidimensional data analysis, you would use OLAP.

Accepted Answer

A) True 
 B)False

Question 4

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

A) True 
 B)False

Question 5

You can manipulate data on a Web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

Data redundancy occurs when different di...

Question 8

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A) True 
 B)False

Question 9

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Accepted Answer

A)   text mining tools
B)   sentiment analysis software
C)   Web usage mining technologies
D)   data mining software for identifying associations
E)   data mining software for forecastingF) None of the above
G) B) and D)

Question 10

The data dictionary serves as an important data management tool by

Accepted Answer

A)   assigning attributes to the data.
B)   creating an inventory of the data elements contained in the database.
C)   presenting data as end users or business specialists would perceive them.
D)   maintaining data in updated form.
E)   providing a guide to database terms and settings.F) C) and D)
G) A) and E)

Question 11

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Accepted Answer

A) True 
 B)False

Question 12

The most prominent data manipulation language today is

Accepted Answer

A)   Access.
B)   DB2.
C)   SQL.
D)   Crystal Reports.
E)   NoSQL.F) A) and D)
G) All of the above

Question 13

In a relational database, a record is referred to in technical terms as a(n)

Accepted Answer

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

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

Question 15

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

A) True 
 B)False

Question 16

A(n)  ________ is an example of non-digital data storage that is comparable to a database.

Accepted Answer

A)   library card catalog
B)   cash register receipt
C)   doctor's office invoice
D)   list of sales totals on a spreadsheet
E)   schedule of due dates on a project outlineF) A) and E)
G) A) and B)

Question 17

The logical view of a database

Accepted Answer

A)   displays the organization and structure of data on the physical storage media.
B)   includes a digital dashboard.
C)   allows the creation of supplementary reports.
D)   enables users to manipulate the logical structure of the database.
E)   presents data as they would be perceived by end users.F) A) and C)
G) A) and E)

Question 18

The relationship between entities and attributes is best illustrated by

Accepted Answer

A)   the entity CUSTOMER with the attribute PRODUCT.
B)   the entity CUSTOMER with the attribute PURCHASE.
C)   the entity PRODUCT with the attribute PURCHASE.
D)   the entity PRODUCT with the attribute CUSTOMER.
E)   the entity PURCHASE with the attribute CUSTOMER.F) B) and E)
G) A) and B)

Question 19

Data cleansing not only corrects errors but also

Accepted Answer

A)   establishes logical relationships between data.
B)   structures data.
C)   normalizes data.
D)   removes duplicate data.
E)   enforces consistency among different sets of data.F) All of the above
G) A) and B)

Question 20

A data warehouse is composed of

Accepted Answer

A)   historical data from legacy systems.
B)   current data.
C)   internal and external data sources.
D)   historic and current internal data.
E)   historic external data.F) A) and B)
G) None of the above

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

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Correct AnswerverifiedShow Answer

The relationship between entities and attributes is best illustrated by

Correct AnswerverifiedShow Answer

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Correct AnswerverifiedShow Answer

A(n) ________ is a characteristic or quality that describes a database entity.

Correct AnswerverifiedShow Answer

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Correct AnswerverifiedShow Answer

The data dictionary serves as an important data management tool by

Correct AnswerverifiedShow Answer

Data cleansing not only corrects errors but also

Correct AnswerverifiedShow Answer

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Correct AnswerverifiedShow Answer

A(n) ________ is an example of non-digital data storage that is comparable to a database.

Correct AnswerverifiedShow Answer

In a relational database, a record is referred to in technical terms as a(n)

Correct AnswerverifiedShow Answer

List at least three conditions that contribute to data redundancy and inconsistency.

Correct AnswerverifiedData redundancy occurs when different di...View AnswerShow Answer

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Correct AnswerverifiedShow Answer

You can manipulate data on a Web server by using a CGI script.

Correct AnswerverifiedShow Answer

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The logical view of a database

Correct AnswerverifiedShow Answer

To perform multidimensional data analysis, you would use OLAP.

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

A data warehouse is composed of

Correct AnswerverifiedShow Answer

The most prominent data manipulation language today is

Correct AnswerverifiedShow 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
Data redundancy occurs when different di...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified