Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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. 
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 3

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 quality 
A) Real-time information 
B) Real-time systems 
C) Information level 
D) Information quality

Question 4

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. 
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.

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

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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. 
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.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

Information is data converted into a mea

Question 12

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 13

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. 
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.

Question 14

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 trends 
A) Identifies redundant records 
B) Identifies inaccurate or incomplete data 
C) Identifies missing records or attributes 
D) Identifies sales trends

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

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 above 
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 above

Question 19

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 issue 
A) Data modeling issue 
B) Data mining issue 
C) Data governance issue 
D) Information inconsistency issue

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. 
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.

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

What is social media analytics?

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

What is a data point?

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

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

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

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

What is identity management?

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

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

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.

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

Which of the following is not an information cleansing activity?

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

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.

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

What is the role of a foreign key?

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

What is advanced analytics?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters

Exam 6: Data: Business Intelligence

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

What is social media analytics?

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

What is a data point?

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

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

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

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

What is identity management?

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

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

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.

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

Which of the following is not an information cleansing activity?

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

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.

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

What is the role of a foreign key?

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

What is advanced analytics?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters