Question 1

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  Non-formatted data 
B)  Misleading data 
C)  Incorrect data 
D)  All of these choices 
A)  Non-formatted data 
B)  Misleading data 
C)  Incorrect data 
D)  All of these choices

Question 3

Optimization is a statistical process for estimating the relationships among variables.

Accepted Answer

A) True 
 B)False

Question 4

What are predictions based on time-series information?

Accepted Answer

A)  Prediction 
B)  Optimization 
C)  Forecasting 
D)  Regression 
A)  Prediction 
B)  Optimization 
C)  Forecasting 
D)  Regression

Question 5

What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?

Accepted Answer

A)  Clustering factors 
B)  Mashup technology 
C)  Market basket analysis 
D)  Drill-down basket analysis 
A)  Clustering factors 
B)  Mashup technology 
C)  Market basket analysis 
D)  Drill-down basket analysis

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A)  It is only available to high-level executives due to the expense. 
B)  It is only available in aggregate levels of granularity. 
C)  It continually changes. 
D)  It rarely changes. 
A)  It is only available to high-level executives due to the expense. 
B)  It is only available in aggregate levels of granularity. 
C)  It continually changes. 
D)  It rarely changes.

Question 8

What is the logical view of information?

Accepted Answer

A)  Deals with the physical storage of information on a storage device such as a hard disk 
B)  Deals with the logical storage of information on a storage device such as a hard disk 
C)  Focuses on how users logically access information to meet their particular business needs 
D)  Focuses on how users physically access information to meet their particular business needs 
A)  Deals with the physical storage of information on a storage device such as a hard disk 
B)  Deals with the logical storage of information on a storage device such as a hard disk 
C)  Focuses on how users logically access information to meet their particular business needs 
D)  Focuses on how users physically access information to meet their particular business needs

Question 9

A data set is an organized collection of data.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Accepted Answer

A)  Quality business constraints 
B)  Critical Web constraints 
C)  Business critical integrity constraints 
D)  Web integrity constraints 
A)  Quality business constraints 
B)  Critical Web constraints 
C)  Business critical integrity constraints 
D)  Web integrity constraints

Question 11

Infographics (information graphics)displays information graphically so it can be easily understood.

Accepted Answer

A) True 
 B)False

Question 12

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations,while identifying possible data gaps or where missing data might exist.

Accepted Answer

A) True 
 B)False

Question 13

What is a foreign key?

Accepted Answer

A)  A field (or group of fields)that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields)that uniquely identifies a given attribute in a table 
A)  A field (or group of fields)that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields)that uniquely identifies a given attribute in a table

Question 14

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 these choices 
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 these choices

Question 15

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of these choices 
A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of these choices

Question 16

What is a primary key?

Accepted Answer

A)  A field (or group of fields)that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields)that uniquely identifies a given attribute in a table 
A)  A field (or group of fields)that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields)that uniquely identifies a given attribute in a table

Question 17

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 18

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 19

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Accepted Answer

A) True 
 B)False

Question 20

What is data stewardship?

Accepted Answer

A)  The time it takes for data to be stored or retrieved 
B)  The management and oversight of an organization's data assets 
C)  The person responsible for ensuring policies and procedures are implemented across the organization 
D)  When a company examines its data to determine if it can meet business expectations,while identifying possible data gaps 
A)  The time it takes for data to be stored or retrieved 
B)  The management and oversight of an organization's data assets 
C)  The person responsible for ensuring policies and procedures are implemented across the organization 
D)  When a company examines its data to determine if it can meet business expectations,while identifying possible data gaps

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

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

Optimization is a statistical process for estimating the relationships among variables.

What are predictions based on time-series information?

What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?

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

What is one of the biggest pitfalls associated with real-time information?

What is the logical view of information?

A data set is an organized collection of data.

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Infographics (information graphics)displays information graphically so it can be easily understood.

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations,while identifying possible data gaps or where missing data might exist.

What is a foreign key?

Which of the following statements is true regarding customer information?

Which of the following occurs during data cleansing?

What is a primary key?

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

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.

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

What is data stewardship?

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Database Design and Entity Relationships

Filters

Exam 6: Data: Business Intelligence

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

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

Optimization is a statistical process for estimating the relationships among variables.

What are predictions based on time-series information?

What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?

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

What is one of the biggest pitfalls associated with real-time information?

What is the logical view of information?

A data set is an organized collection of data.

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Infographics (information graphics)displays information graphically so it can be easily understood.

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations,while identifying possible data gaps or where missing data might exist.

What is a foreign key?

Which of the following statements is true regarding customer information?

Which of the following occurs during data cleansing?

What is a primary key?

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

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.

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

What is data stewardship?

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Database Design and Entity Relationships

Filters