Question 1

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Accepted Answer

A) True 
 B)False

Question 2

Explain the four primary traits that determine the value of information.

Accepted Answer

Information is data converted into a mea...

Question 3

Which of the following is not an information cleansing activity?

Accepted Answer

A)  Identifies redundant records
B)  Identifies inaccurate or incomplete data
C)  Identifies missing records or attributes
D)  Identifies sales trendsE) B) and D)
F) A) and B)

Question 4

Association detection is a 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) True 
 B)False

Question 5

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 6

Data dictionary compiles all of the metadata about the data elements in the data model.

Accepted Answer

A) True 
 B)False

Question 7

Organizational information has three characteristics including levels, formats, and granularities.

Accepted Answer

A) True 
 B)False

Question 8

The logical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 9

Accurate information asks if the aggregate or summary information in agreement with detailed information.

Accepted Answer

A) True 
 B)False

Question 10

What provides real-time information in response to query requests?

Accepted Answer

A)  Real-time information
B)  Real-time systems
C)  Information level
D)  Information qualityE) All of the above
F) A) and D)

Question 11

What is identity management?

Accepted Answer

A)  Enforces business rules vital to an organization's success.
B)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete.
C)  A broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.E) A) and B)
F) A) and C)

Question 12

What is social media 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.E) A) and B)
F) A) and C)

Question 13

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 14

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Accepted Answer

A)  A historical perspective offers important variables for determining trends and patterns.
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C)  Setting strategic direction is critical for planning and creating solid business strategies.
D)  None of the above.E) B) and D)
F) B) and C)

Question 15

Which of the following occurs when the same data element has different values?

Accepted Answer

A)  Data modeling issue
B)  Data mining issue
C)  Data governance issue
D)  Information inconsistency issueE) A) and B)
F) A) and C)

Question 16

Data governance refers to the overall management of the availability, usability, integrity, and security of company data.

Accepted Answer

A) True 
 B)False

Question 17

What is a data point?

Accepted Answer

A)  Identifies the primary location where data is collected.
B)  An individual item on a graph or chart.
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.E) B) and C)
F) A) and D)

Question 18

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

Question 19

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False

Question 20

What is advanced analytics?

Accepted Answer

A)  A collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.
B)  Processes and manages algorithms across many machines in a computing environment.
C)  Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
D)  Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information.E) A) and B)
F) All of the above

Exam 6: Data: Business Intelligence

What is the role of a foreign key?

Correct AnswerverifiedShow Answer

What is social media analytics?

Correct AnswerverifiedShow Answer

The logical view of information deals with the physical storage of information on a storage device.

Correct AnswerverifiedShow Answer

Which of the following is not an information cleansing activity?

Correct AnswerverifiedShow Answer

What is identity management?

Correct AnswerverifiedShow Answer

Accurate information asks if the aggregate or summary information in agreement with detailed information.

Correct AnswerverifiedShow Answer

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Correct AnswerverifiedShow Answer

Association detection is a 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

What is advanced analytics?

Correct AnswerverifiedShow Answer

Explain the four primary traits that determine the value of information.

Correct AnswerverifiedInformation is data converted into a mea...View AnswerShow Answer

Which of the following occurs when the same data element has different values?

Correct AnswerverifiedShow Answer

What is a data point?

Correct AnswerverifiedShow Answer

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Correct AnswerverifiedShow Answer

Data dictionary compiles all of the metadata about the data elements in the data model.

Correct AnswerverifiedShow Answer

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Correct AnswerverifiedShow Answer

Data governance refers to the overall management of the availability, usability, integrity, and security of company data.

Correct AnswerverifiedShow Answer

ETL, within a data warehouse model, stands for exit, track, and load.

Correct AnswerverifiedShow Answer

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Correct AnswerverifiedShow Answer

What provides real-time information in response to query requests?

Correct AnswerverifiedShow Answer

Organizational information has three characteristics including levels, formats, and granularities.

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
Information is data converted into a mea...
View 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