Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?

Accepted Answer

A) Association detection 
B) Masking detection tool 
C) Cluster grouping 
D) Blocking barriers 
A) Association detection 
B) Masking detection tool 
C) Cluster grouping 
D) Blocking barriers

Question 3

What is the overall management of the availability, usability, integrity, and security of company data?

Accepted Answer

A) Data Intelligence 
B) Data governance 
C) Data forbearance 
D) Data forecasting 
A) Data Intelligence 
B) Data governance 
C) Data forbearance 
D) Data forecasting

Question 4

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 5

Which of the following represent the four primary traits that help determine the value of information?

Accepted Answer

A) Information type, information timeliness, information quality, and information governance 
B) Information statistics, information tracking, information quality, and information governance 
C) Information type, information chance, information analytics, and information policy 
D) Information timeliness, information quality, information quantity, and information governance policy 
A) Information type, information timeliness, information quality, and information governance 
B) Information statistics, information tracking, information quality, and information governance 
C) Information type, information chance, information analytics, and information policy 
D) Information timeliness, information quality, information quantity, and information governance policy

Question 6

What is master data management?

Accepted Answer

A) The time it takes for data to be stored or retrieved. 
B) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete. 
C) The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data. 
D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps. 
A) The time it takes for data to be stored or retrieved. 
B) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete. 
C) The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data. 
D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.

Question 7

Estimation determines which things go together.

Accepted Answer

A) True 
 B)False

Question 8

What is a dynamic website?

Accepted Answer

A) The person responsible for creating the original website content. 
B) Includes data that change based on user action. 
C) Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database. 
D) An interactive website kept constantly updated and relevant to the needs of its customers using a database. 
A) The person responsible for creating the original website content. 
B) Includes data that change based on user action. 
C) Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database. 
D) An interactive website kept constantly updated and relevant to the needs of its customers using a database.

Question 9

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False

Question 10

What is erroneous or flawed data?

Accepted Answer

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

Question 11

What 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 tasks?

Accepted Answer

A) Transactional information 
B) Analytical information 
C) Timeliness 
D) Quality 
A) Transactional information 
B) Analytical information 
C) Timeliness 
D) Quality

Question 12

What is an example of using cluster analysis in business to create target-marketing strategies?

Accepted Answer

A) Google search 
B) First name information 
C) Zip code segmentation 
D) Last name associations 
A) Google search 
B) First name information 
C) Zip code segmentation 
D) Last name associations

Question 13

What is a business analytics specialist who uses visual tools to help people understand complex data?

Accepted Answer

A) Distributed computing 
B) Advanced analytics 
C) Analysis paralysis 
D) Data artist 
A) Distributed computing 
B) Advanced analytics 
C) Analysis paralysis 
D) Data artist

Question 14

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 15

What is data mining?

Accepted Answer

A) The common term for the representation of multidimensional information 
B) A particular attribute of information 
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making 
D) Process of analyzing data to extract information not offered by the raw data alone 
A) The common term for the representation of multidimensional information 
B) A particular attribute of information 
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making 
D) Process of analyzing data to extract information not offered by the raw data alone

Question 16

What is the primary problem with redundant information?

Accepted Answer

A) It is difficult to determine which values are the most current 
B) It is often inconsistent 
C) It is difficult to determine which values are the most accurate 
D) All of the above 
A) It is difficult to determine which values are the most current 
B) It is often inconsistent 
C) It is difficult to determine which values are the most accurate 
D) All of the above

Question 17

Which of the following describes ETL?

Accepted Answer

A) A process that extracts information from internal and external databases 
B) A process that transforms information using a common set of enterprise definitions 
C) A process that loads information into a data warehouse 
D) All of the above 
A) A process that extracts information from internal and external databases 
B) A process that transforms information using a common set of enterprise definitions 
C) A process that loads information into a data warehouse 
D) All of the above

Question 18

Which of the following is a disadvantage of database-stored information?

Accepted Answer

A) Increased flexibility 
B) Increased performance 
C) Increased information redundancy 
D) Increased information integrity 
A) Increased flexibility 
B) Increased performance 
C) Increased information redundancy 
D) Increased information integrity

Question 19

A primary key is the smallest or basic unit of information.

Accepted Answer

A) True 
 B)False

Question 20

What are predictions based on time-series information?

Accepted Answer

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

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

Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?

What is the overall management of the availability, usability, integrity, and security of company data?

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.

Which of the following represent the four primary traits that help determine the value of information?

What is master data management?

Estimation determines which things go together.

What is a dynamic website?

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

What is erroneous or flawed data?

What 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 tasks?

What is an example of using cluster analysis in business to create target-marketing strategies?

What is a business analytics specialist who uses visual tools to help people understand complex data?

The financial industry uses business intelligence to predict hardware failures.

What is data mining?

What is the primary problem with redundant information?

Which of the following describes ETL?

Which of the following is a disadvantage of database-stored information?

A primary key is the smallest or basic unit of information.

What are predictions based on time-series information?

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

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

Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?

What is the overall management of the availability, usability, integrity, and security of company data?

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.

Which of the following represent the four primary traits that help determine the value of information?

What is master data management?

Estimation determines which things go together.

What is a dynamic website?

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

What is erroneous or flawed data?

What 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 tasks?

What is an example of using cluster analysis in business to create target-marketing strategies?

What is a business analytics specialist who uses visual tools to help people understand complex data?

The financial industry uses business intelligence to predict hardware failures.

What is data mining?

What is the primary problem with redundant information?

Which of the following describes ETL?

Which of the following is a disadvantage of database-stored information?

A primary key is the smallest or basic unit of information.

What are predictions based on time-series information?

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