Question 1

The four primary traits of the value of information include levels,formats,granularities,and type.

Accepted Answer

A) True 
 B)False

Question 2

What is a data map?

Accepted Answer

A)  A business that collects personal information about consumers and sells that information to other organizations 
B)  A storage repository that holds a vast amount of raw data in its original format until the business needs it 
C) 	A technique for establishing a match, or balance, between the source data and the target data warehouse 
D)  	An approach to business governance that values decisions that can be backed up with verifiable data
A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse

Question 3

Web analytics analyzes unstructured data to find trends and patterns in words and sentences.

Accepted Answer

A) True 
 B)False

Question 4

What is a real-time system?

Accepted Answer

A)  Provides immediate,up-to-date information 
B)  Provides real-time information in response to query requests 
C)  Encompasses all organization information,and its primary purpose is to support the performing of managerial analysis tasks 
D)  Encompasses all of the information contained within a single business process or unit of work,and its primary purpose is to support the performing of daily operational tasks

Question 5

Regression is a statement about what will happen or might happen in the future,for example,predicting future sales or employee turnover.

Accepted Answer

A) True 
 B)False

Question 6

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)  Statistical detection 
B)  Cluster analysis 
C)  Association detection 
D)  Social media analytics

Question 7

A DBMS provides details about data.

Accepted Answer

A) True 
 B)False

Question 8

Forecasts are predictions based on time-series information.

Accepted Answer

A) True 
 B)False

Question 9

Information redundancy is the duplication of data,or the storage of the same data in multiple places.

Accepted Answer

A) True 
 B)False

Question 10

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Accepted Answer

A) True 
 B)False

Question 11

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

Accepted Answer

A)  improvements 
B)  change 
C)  clustering 
D)  cleansing

Question 12

What is the role of a foreign key?

Accepted Answer

A)  It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. 
B)  It is a unique way to identify each record. 
C)  Is a field that uniquely identifies a give record in a table. 
D)  All of these choices

Question 13

What are forecasts?

Accepted Answer

A)  A statement about what will happen or might happen in the future,for example,predicting future sales or employee turnover 
B)  A statistical process that finds the way to make a design,system,or decision as effective as possible,for example,finding the values of controllable variables that determine maximal productivity or minimal waste 
C)  Predictions based on time-series information 
D)  A statistical process for estimating the relationships among variables

Question 14

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

Accepted Answer

A) True 
 B)False

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

What are advanced analytics?

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

Question 17

BI can help managers with ___________,where a company keeps tabs of its competitor's activities on the Web using software that automatically tracks all competitor website activities such as discounts and new products.

Accepted Answer

A)  comparative analysis 
B)  competitive monitoring 
C)  data-driven decision management 
D)  source data

Question 18

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

Accepted Answer

A)  Is a value missing from the personal information? 
B)  Is each transaction represented only once in the information? 
C)  Is the address incomplete? 
D)  Is the area code missing for the phone information?

Question 19

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 20

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

The four primary traits of the value of information include levels,formats,granularities,and type.

What is a data map?

Web analytics analyzes unstructured data to find trends and patterns in words and sentences.

What is a real-time system?

Regression is a statement about what will happen or might happen in the future,for example,predicting future sales or employee turnover.

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

A DBMS provides details about data.

Forecasts are predictions based on time-series information.

Information redundancy is the duplication of data,or the storage of the same data in multiple places.

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

What is the role of a foreign key?

What are forecasts?

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

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.

What are advanced analytics?

BI can help managers with ___________,where a company keeps tabs of its competitor's activities on the Web using software that automatically tracks all competitor website activities such as discounts and new products.

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

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

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.