Question 1

Data governance is 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) True 
 B)False

Question 2

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 the above are examples of how industries use business intelligence.E) A) and B)
F) A) and C)

Question 3

Record is a collection of related data elements

Accepted Answer

A) True 
 B)False

Question 4

Data artist is a business analytics specialist who uses visual tools to help people understand complex data.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following lists include all of the five characteristics common to high-quality information?

Accepted Answer

A)  Accuracy, completeness, strength, support, and positive feedback
B)  Accuracy, association, referral, sales, and marketing
C)  Accuracy, competition, support, customer service, and visibility
D)  Accuracy, completeness, consistency, timeliness, and uniquenessE) A) and B)
F) A) and C)

Question 6

A foreign key uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following refers to the extent of detail within the information?

Accepted Answer

A)  Knowledge information
B)  Information granularity
C)  Chance information
D)  Information analyticsE) B) and C)
F) A) and C)

Question 8

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise)and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Accepted Answer

A) True 
 B)False

Question 9

What is distributed computing?

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.E) None of the above
F) B) and D)

Question 10

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 11

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Accepted Answer

A)  Reduces disk space requirements
B)  Makes updating information easier
C)  Improves information quality
D)  All of the aboveE) B) and C)
F) None of the above

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 14

What is prediction?

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

Question 15

Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?

Accepted Answer

A)  Analytical information
B)  Transactional information
C)  Statistical information
D)  Targeted informationE) A) and D)
F) B) and C)

Question 16

A data miner is a business analytics specialist who uses visual tools to help people understand complex data.

Accepted Answer

A) True 
 B)False

Question 17

Regression is a statistical process for estimating the relationships among variables. It includes many techniques for modeling and analyzing several variables when the focus is on the relationship between a dependent variable and one or more independent variables

Accepted Answer

A) True 
 B)False

Question 18

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Correct AnswerverifiedShow Answer

ETL stands for extraction, transformation, and loading.

Correct AnswerverifiedShow Answer

Data governance is 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

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?

Correct AnswerverifiedShow Answer

A foreign key uniquely identifies a given record in a table.

Correct AnswerverifiedShow Answer

Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?

Correct AnswerverifiedShow Answer

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Correct AnswerverifiedShow Answer

What is prediction?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data miner is a business analytics specialist who uses visual tools to help people understand complex data.

Correct AnswerverifiedShow Answer

Regression is a statistical process for estimating the relationships among variables. It includes many techniques for modeling and analyzing several variables when the focus is on the relationship between a dependent variable and one or more independent variables

Correct AnswerverifiedShow Answer

Record is a collection of related data elements

Correct AnswerverifiedShow Answer

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise)and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Correct AnswerverifiedShow Answer

Data artist is a business analytics specialist who uses visual tools to help people understand complex data.

Correct AnswerverifiedShow Answer

Which of the following refers to the extent of detail within the information?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is distributed computing?

Correct AnswerverifiedShow Answer

Which of the following lists include all of the five characteristics common to high-quality information?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

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