Question 1

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Accepted Answer

A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) Mission-critical integrity constraint 
A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) Mission-critical integrity constraint

Question 2

Data aggregation is the collection of data from various sources for the purpose of data processing.

Accepted Answer

A) True 
 B)False

Question 3

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is incorrect in terms of data warehousing and business intelligence?

Accepted Answer

A) Does not include information from other operational applications 
B) Operational systems are integrated 
C) Operational information is mainly current 
D) Operational information frequently has quality issues 
A) Does not include information from other operational applications 
B) Operational systems are integrated 
C) Operational information is mainly current 
D) Operational information frequently has quality issues

Question 5

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Accepted Answer

A) True 
 B)False

Question 6

What is information that people use to support their decision-making efforts?

Accepted Answer

A) Information cleansing and scrubbing 
B) Data-mining tools 
C) Data mining 
D) Business intelligence 
A) Information cleansing and scrubbing 
B) Data-mining tools 
C) Data mining 
D) Business intelligence

Question 7

Text analytics analyzes unstructured data to find trends and patterns in words and sentences. Text mining a firm's customer support email might identify which customer service representative is best able to handle the question, allowing the system to forward it to the right person.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Duplicate data 
B) Incorrect data 
C) Violates business rules 
D) All of the above 
A) Duplicate data 
B) Incorrect data 
C) Violates business rules 
D) All of the above

Question 9

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

Accepted Answer

A) Oracle. 
B) SAS. 
C) Ascential Software. 
D) McAffee. 
A) Oracle. 
B) SAS. 
C) Ascential Software. 
D) McAffee.

Question 10

A central location in which data is stored and managed is called a data mart.

Accepted Answer

A) True 
 B)False

Question 11

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A) True 
 B)False

Question 12

Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following are examples of external databases in the data warehouse model?

Accepted Answer

A) Marketing, sales, inventory, and billing 
B) Data mart 1, data mart 2, and data mart 3 
C) Competitor and industry information, mailing lists, and stock market analysis 
D) Marketing information, sales information, and stock market analysis 
A) Marketing, sales, inventory, and billing 
B) Data mart 1, data mart 2, and data mart 3 
C) Competitor and industry information, mailing lists, and stock market analysis 
D) Marketing information, sales information, and stock market analysis

Question 14

Which of the following are examples of an external databases in the data warehouse model?

Accepted Answer

A) Marketing information 
B) Sales information 
C) Competitor information 
D) All of the above 
A) Marketing information 
B) Sales information 
C) Competitor information 
D) All of the above

Question 15

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

A) True 
 B)False

Question 16

A comparative analysis can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 17

What is dynamic information?

Accepted Answer

A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action. 
A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action.

Question 18

What is it called when each transaction, entity, and event is represented only once in the information?

Accepted Answer

A) Uniqueness 
B) Accuracy 
C) Consistency 
D) Timeliness 
A) Uniqueness 
B) Accuracy 
C) Consistency 
D) Timeliness

Question 19

What processes and manages algorithms across many machines in a computing environment?

Accepted Answer

A) Big data 
B) Distributed computing 
C) Advanced analytics 
D) Data scientist 
A) Big data 
B) Distributed computing 
C) Advanced analytics 
D) Data scientist

Question 20

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Data aggregation is the collection of data from various sources for the purpose of data processing.

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Which of the following is incorrect in terms of data warehousing and business intelligence?

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

What is information that people use to support their decision-making efforts?

Text analytics analyzes unstructured data to find trends and patterns in words and sentences. Text mining a firm's customer support email might identify which customer service representative is best able to handle the question, allowing the system to forward it to the right person.

Which of the following is a problem associated with dirty data?

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

A central location in which data is stored and managed is called a data mart.

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Which of the following are examples of external databases in the data warehouse model?

Which of the following are examples of an external databases in the data warehouse model?

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

A comparative analysis can compare two or more data sets to identify patterns and trends.

What is dynamic information?

What is it called when each transaction, entity, and event is represented only once in the information?

What processes and manages algorithms across many machines in a computing environment?

A data miner contains a subset of data warehouse information.

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters

Exam 6: Data: Business Intelligence

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Data aggregation is the collection of data from various sources for the purpose of data processing.

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Which of the following is incorrect in terms of data warehousing and business intelligence?

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

What is information that people use to support their decision-making efforts?

Text analytics analyzes unstructured data to find trends and patterns in words and sentences. Text mining a firm's customer support email might identify which customer service representative is best able to handle the question, allowing the system to forward it to the right person.

Which of the following is a problem associated with dirty data?

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

A central location in which data is stored and managed is called a data mart.

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Which of the following are examples of external databases in the data warehouse model?

Which of the following are examples of an external databases in the data warehouse model?

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

A comparative analysis can compare two or more data sets to identify patterns and trends.

What is dynamic information?

What is it called when each transaction, entity, and event is represented only once in the information?

What processes and manages algorithms across many machines in a computing environment?

A data miner contains a subset of data warehouse information.

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters