Question 1

Relational databases offer many advantages over using a text document or a spreadsheet,which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 2

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 3

Describe a database,a database management system,and the relational database model.

Accepted Answer

A database maintains information about v...

Question 4

Business-critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 5

When does information cleansing occur in the data warehouse?

Accepted Answer

A)  During the ETL process
B)  On the information,once it is in the data warehouse
C)  During the ETL process and once it is in the data warehouse
D)  During the ETL process and before it is in the data warehouse

Question 6

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems
B)  Customer information in each operational system could change
C)  Customer information in each operational system can be different
D)  All of the above

Question 7

Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?

Accepted Answer

A)  Data analysis tools
B)  Electronic analysis tools
C)  Data-mining tools
D)  Data integrity tools

Question 8

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Accepted Answer

A)  Data model
B)  Data element
C)  Data mining tool
D)  Data mart tool

Question 9

Business-critical ___________ constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

The answer of Business-critical ___________ constraints enforce business rules vital...

Question 10

The data warehouse is a location for all of business information.

Accepted Answer

A) True 
 B)False

Question 11

What is the primary difference between an entity and an attribute?

Accepted Answer

A)  An attribute is a table,an entity is a column from the attribute table
B)  An entity is specific,where as an attribute is not data at all but brainstorming ideas that take place before the entity is created
C)  An attribute refers to applications,and an entity refers to executives
D)  An entity is a table that stores information about people,places,or events,where as an attribute is a column or specific field of the data elements associated with an entity

Question 12

Which of the following is not a common form of data mining?

Accepted Answer

A)  Division organization
B)  Classification
C)  Estimation
D)  Clustering

Question 13

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Accepted Answer

A) True 
 B)False

Question 14

What are rules that help ensure the quality of information?

Accepted Answer

A)  Information integrity
B)  Integrity constraints
C)  Information quality
D)  Information ethics

Question 15

Time-series information is time-stamped information collected at a particular ___________.

Accepted Answer

The answer of Time-series information is time-stamped information collected at...

Question 16

Which of the following would not be considered part of the consistent characteristic of high-quality information?

Accepted Answer

A)  Do all sales columns equal the total for the revenue column?
B)  Is the two digit state code missing in the information?
C)  Is all summary information in agreement with detailed information?
D)  Does the order number match the item and the color options available?

Question 17

What is another term for data that does not exist in a fixed location?

Accepted Answer

A)  Structured data
B)  Unstructured data
C)  Text mining
D)  Web mining

Question 18

A content _________ is the person responsible for creating the original website content.

Accepted Answer

The answer of A content _________ is the person responsible...

Question 19

Explain the business benefits of a data-driven website.

Accepted Answer

A data-driven website is an interactive ...

Question 20

What compiles all of the metadata about the data elements in the data model?

Accepted Answer

A)  Data entity
B)  Data element
C)  Data attribute
D)  Data dictionary

Exam 6: Data: Business Intelligence

What is another term for data that does not exist in a fixed location?

Correct AnswerverifiedShow Answer

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Correct AnswerverifiedShow Answer

Business-critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

Time-series information is time-stamped information collected at a particular ___________.

Correct AnswerverifiedShow Answer

What are rules that help ensure the quality of information?

Correct AnswerverifiedShow Answer

Business-critical ___________ constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

A data miner contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

What is the primary difference between an entity and an attribute?

Correct AnswerverifiedShow Answer

The data warehouse is a location for all of business information.

Correct AnswerverifiedShow Answer

Explain the business benefits of a data-driven website.

Correct AnswerverifiedA data-driven website is an interactive ...View AnswerShow Answer

Which of the following is not a common form of data mining?

Correct AnswerverifiedShow Answer

Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?

Correct AnswerverifiedShow Answer

Describe a database,a database management system,and the relational database model.

Correct AnswerverifiedA database maintains information about v...View AnswerShow Answer

A content _________ is the person responsible for creating the original website content.

Correct AnswerverifiedShow Answer

What compiles all of the metadata about the data elements in the data model?

Correct AnswerverifiedShow Answer

Which of the following statements is true regarding customer information?

Correct AnswerverifiedShow Answer

Which of the following would not be considered part of the consistent characteristic of high-quality information?

Correct AnswerverifiedShow Answer

Relational databases offer many advantages over using a text document or a spreadsheet,which include decreased flexibility and decreased scalability and performance.

Correct AnswerverifiedShow Answer

When does information cleansing occur in the data warehouse?

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
A data-driven website is an interactive ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database maintains information about v...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified