Question 1

A data map is a technique for establishing a match,or balance,between the source data and the target data warehouse.

Accepted Answer

A) True 
 B)False

Question 2

Data-mining tools use 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) True 
 B)False

Question 3

A data point is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 4

Business intelligence can provide managers with the ability to make better decisions.Which of the following is not an example of how different industries use business intelligence?

Accepted Answer

A)  Analyze popular vacation locations with current flight listings 
B)  Understand customer credit card usage and nonpayment rates 
C)  Compare the demographics of patients with critical illnesses 
D)  All of these choices are examples of how industries use business intelligence. 
A)  Analyze popular vacation locations with current flight listings 
B)  Understand customer credit card usage and nonpayment rates 
C)  Compare the demographics of patients with critical illnesses 
D)  All of these choices are examples of how industries use business intelligence.

Question 5

What is a data artist?

Accepted Answer

A)  Processes and manages algorithms across many machines in a computing environment 
B)  Focuses on forecasting future trends and producing insights using sophisticated quantitative methods,including statistics,descriptive and predictive data mining,simulation,and optimization 
C)  Occurs when the user goes into an emotional state of over-analysis (or over-thinking)a situation so that a decision or action is never taken,in effect paralyzing the outcome 
D)  A business analytics specialist who uses visual tools to help people understand complex data 
A)  Processes and manages algorithms across many machines in a computing environment 
B)  Focuses on forecasting future trends and producing insights using sophisticated quantitative methods,including statistics,descriptive and predictive data mining,simulation,and optimization 
C)  Occurs when the user goes into an emotional state of over-analysis (or over-thinking)a situation so that a decision or action is never taken,in effect paralyzing the outcome 
D)  A business analytics specialist who uses visual tools to help people understand complex data

Question 6

What is data latency?

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

Question 7

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Accepted Answer

A)  Data steward 
B)  Data stewardship 
C)  Data gap analysis 
D)  Data governance 
A)  Data steward 
B)  Data stewardship 
C)  Data gap analysis 
D)  Data governance

Question 8

Which of the following occurs when a system produces incorrect,inconsistent,or duplicate data?

Accepted Answer

A)  Information inconsistency issue 
B)  Information integrity issue 
C)  Data control issue 
D)  Data mining issue 
A)  Information inconsistency issue 
B)  Information integrity issue 
C)  Data control issue 
D)  Data mining issue

Question 9

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

Accepted Answer

A) True 
 B)False

Question 10

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is correct in reference to a database?

Accepted Answer

A)  A database can support only one logical view. 
B)  A database can support many physical views. 
C)  A database can support many logical views. 
D)  A database can support up to three logical views. 
A)  A database can support only one logical view. 
B)  A database can support many physical views. 
C)  A database can support many logical views. 
D)  A database can support up to three logical views.

Question 12

What an outlier?

Accepted Answer

A)  Processes and manages algorithms across many machines in a computing environment 
B)  A data value that is numerically distant from most of the other data points in a set of data 
C)  Occurs when the user goes into an emotional state of over-analysis (or over-thinking)a situation so that a decision or action is never taken,in effect paralyzing the outcome 
D)  The application of Big Data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value 
A)  Processes and manages algorithms across many machines in a computing environment 
B)  A data value that is numerically distant from most of the other data points in a set of data 
C)  Occurs when the user goes into an emotional state of over-analysis (or over-thinking)a situation so that a decision or action is never taken,in effect paralyzing the outcome 
D)  The application of Big Data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value

Question 13

The example the book gave of www.EllisIsland.org,which generates more than 2.5 billion hits,is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Accepted Answer

A)  Increased scalability and performance 
B)  Increased information security 
C)  Reduced information redundancy 
D)  Increased flexibility 
A)  Increased scalability and performance 
B)  Increased information security 
C)  Reduced information redundancy 
D)  Increased flexibility

Question 14

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a business-critical integrity constraint?

Accepted Answer

A)  System will not allow an entry for an order for a nonexistent customer. 
B)  System will not allow returns of fresh produce after 15 days past delivery. 
C)  System will not allow shipping a product to a customer who does not have a valid address. 
D)  Systems will not allow shipping of a nonexistent product to a customer. 
A)  System will not allow an entry for an order for a nonexistent customer. 
B)  System will not allow returns of fresh produce after 15 days past delivery. 
C)  System will not allow shipping a product to a customer who does not have a valid address. 
D)  Systems will not allow shipping of a nonexistent product to a customer.

Question 16

Ben works at a top accounting firm in Salt Lake City,and his responsibilities include developing reports for each salesperson,product,and part as well as departmental-wide sales reports by salesperson,product,and part.Ben's duties provide value-added to his company and would be categorized as occurring at the different information _____________.

Accepted Answer

A)  levels 
B)  formats 
C)  granularities 
D)  focus 
A)  levels 
B)  formats 
C)  granularities 
D)  focus

Question 17

What do data warehouses support?

Accepted Answer

A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing 
A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing

Question 18

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

A) True 
 B)False

Question 19

Duplicate data,inaccurate data,misleading data,and incorrect data are all problems associated with dirty data.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

Accepted Answer

A)  Physical view 
B)  Logical view 
C)  Data mart view 
D)  Data view 
A)  Physical view 
B)  Logical view 
C)  Data mart view 
D)  Data view

A data map is a technique for establishing a match,or balance,between the source data and the target data warehouse.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

A data point is an individual item on a graph or chart.

Business intelligence can provide managers with the ability to make better decisions.Which of the following is not an example of how different industries use business intelligence?

What is a data artist?

What is data latency?

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Which of the following occurs when a system produces incorrect,inconsistent,or duplicate data?

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

Dirty data is erroneous or flawed data.

Which of the following is correct in reference to a database?

What an outlier?

The example the book gave of www.EllisIsland.org,which generates more than 2.5 billion hits,is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Which of the following is a business-critical integrity constraint?

What do data warehouses support?

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Duplicate data,inaccurate data,misleading data,and incorrect data are all problems associated with dirty data.

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

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

A data map is a technique for establishing a match,or balance,between the source data and the target data warehouse.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

A data point is an individual item on a graph or chart.

Business intelligence can provide managers with the ability to make better decisions.Which of the following is not an example of how different industries use business intelligence?

What is a data artist?

What is data latency?

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Which of the following occurs when a system produces incorrect,inconsistent,or duplicate data?

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

Dirty data is erroneous or flawed data.

Which of the following is correct in reference to a database?

What an outlier?

The example the book gave of www.EllisIsland.org,which generates more than 2.5 billion hits,is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Which of the following is a business-critical integrity constraint?

What do data warehouses support?

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Duplicate data,inaccurate data,misleading data,and incorrect data are all problems associated with dirty data.

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

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