Question 1

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Accepted Answer

A) True 
 B)False

Question 2

Unique information asks if each transaction and event represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 3

What determines the accuracy and completeness of organizational data?

Accepted Answer

A)  Data quantity audit
B)  Data quality audit
C)  Data intelligence audit
D)  Data accuracy audit

Question 4

What is a statistical process for estimating the relationships among variables?

Accepted Answer

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

Question 5

What is text analytics?

Accepted Answer

A)  Analyzes text flowing across the Internet, including unstructured text from blogs and messages.
B)  The process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise.
C)  Analyzes unstructured data to find trends and patterns in words and sentences.
D)  Analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Question 6

Which of the following is a valid type of integrity constraint?

Accepted Answer

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

Question 7

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 8

What moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?

Accepted Answer

A)  Informing
B)  Infographics
C)  Data visualization tools
D)  Business intelligence dashboards

Question 9

What is speech analytics?

Accepted Answer

A)  Analyzes text flowing across the Internet, including unstructured text from blogs and messages.
B)  The process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise.
C)  Analyzes unstructured data to find trends and patterns in words and sentences.
D)  Analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Question 10

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 11

The four common characteristics of big data include variety, veracity, volume, velocity.

Accepted Answer

A) True 
 B)False

Question 12

Static information includes data that changes based on user actions.

Accepted Answer

A) True 
 B)False

Question 13

What is information inconsistency?

Accepted Answer

A)  Occurs when the same data element has different values.
B)  Occurs when a system produces incorrect, inconsistent, or duplicate data.
C)  Refers to the overall management of the availability, usability, integrity, and security of company data.
D)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Question 14

Business analysis is difficult from operational databases. Which of the following is not a reason why?

Accepted Answer

A)  Every department has its own method for recording data.
B)  When sharing data, it matches and users get the data they need.
C)  The data is of poor quality.
D)  The data collected is not always useful for intended purposes.

Question 15

What analyzes unstructured data to find trends and patterns in words and sentences?

Accepted Answer

A)  Social media analytics
B)  Speech analytics
C)  Text analytics
D)  Web analytics

Question 16

Time-series information is time-stamped information collected at a particular frequency.

Accepted Answer

A) True 
 B)False

Question 17

What is the term for the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Accepted Answer

A)  Data governance.
B)  Master data management.
C)  Data validation.
D)  Data gap analysis.

Question 18

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

Question 19

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

Accepted Answer

A)  Data set.
B)  Dirty data.
C)  Data map.
D)  Data point.

Question 20

Web analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?

Correct AnswerverifiedShow Answer

Static information includes data that changes based on user actions.

Correct AnswerverifiedShow Answer

Web analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Correct AnswerverifiedShow Answer

Business analysis is difficult from operational databases. Which of the following is not a reason why?

Correct AnswerverifiedShow Answer

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

Correct AnswerverifiedShow Answer

What analyzes unstructured data to find trends and patterns in words and sentences?

Correct AnswerverifiedShow Answer

Unique information asks if each transaction and event represented only once in the information.

Correct AnswerverifiedShow Answer

What is speech analytics?

Correct AnswerverifiedShow Answer

One of the advantages found in a relational database is increased information redundancy.

Correct AnswerverifiedShow Answer

What is a statistical process for estimating the relationships among variables?

Correct AnswerverifiedShow Answer

What is information inconsistency?

Correct AnswerverifiedShow Answer

Time-series information is time-stamped information collected at a particular frequency.

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

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?

Correct AnswerverifiedShow Answer

Which of the following is a valid type of integrity constraint?

Correct AnswerverifiedShow Answer

What determines the accuracy and completeness of organizational data?

Correct AnswerverifiedShow Answer

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Correct AnswerverifiedShow Answer

What is text analytics?

Correct AnswerverifiedShow Answer

The four common characteristics of big data include variety, veracity, volume, velocity.

Correct AnswerverifiedShow Answer

What is the term for the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

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