Question 1

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 dataE) A) and B)
F) A) and D)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Forecasts are predictions based on time-series information.

Accepted Answer

A) True 
 B)False

Question 4

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 variablesE) None of the above
F) A) and D)

Question 5

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 dataE) A) and B)
F) A) and C)

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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)   cleansingE) None of the above
F) C) and D)

Question 9

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

Question 10

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?E) B) and C)
F) All of the above

Question 11

A DBMS provides details about data.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 dataA data map is a technique for establishing a match, or balance, between the source data and the target data warehouseE) All of the above
F) A) and D)

Question 14

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 choicesE) A) and C)
F) B) and C)

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 analyticsE) B) and C)
F) All of the above

Question 19

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 tasksE) A) and C)
F) A) and B)

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What are forecasts?

Correct AnswerverifiedShow Answer

What is a real-time system?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

What are advanced analytics?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Forecasts are predictions based on time-series information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a data map?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

What is the role of a foreign key?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A DBMS provides details about data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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