Question 1

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

Accepted Answer

detection

Question 2

Which of the below defines 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 A

Question 3

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes 
A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes C

Question 4

An____________ allows separate systems to communicate directly with each other.

Accepted Answer

The answer of An____________ allows separate systems to communicate directly...

Question 5

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Accepted Answer

The answer of Data __________ issues occur when a system...

Question 6

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Accepted Answer

A) True 
 B)False

Question 7

The primary purpose of a data warehouse is to ____________.

Accepted Answer

A) Information scaling 
B) Streamlining data points 
C) Standardising information 
D) Standardising protocols 
A) Information scaling 
B) Streamlining data points 
C) Standardising information 
D) Standardising protocols

Question 8

BI,business analytics and data science appear quite similar.However,each is different and it has become increasingly necessary for organisations to become cognizant of the distinctions between these terms,as they relate to the value they can produce for the enterprise.How do BI,business analytics and data science differ?

Accepted Answer

•Business analytics is at the core of BI

Question 9

Standardising of data elements allows for:

Accepted Answer

A) Marketing, sales, inventory and billing 
B) Data mart 1, data mart 2 and data mart 3 
C) Competitor and industry information, mailing lists and stock market analysis 
D) Marketing information, sales information and stock market analysis 
A) Marketing, sales, inventory and billing 
B) Data mart 1, data mart 2 and data mart 3 
C) Competitor and industry information, mailing lists and stock market analysis 
D) Marketing information, sales information and stock market analysis

Question 10

What BI tools are required depends on how the data is currently managed and how it is to be analysed.BI software can be divided into three broad application categories;namely,data management tools,data discovery applications and reporting tools.What value can they potentially add to a business?

Accepted Answer

•Data management tools:The prime purpose

Question 11

Analytical information encompasses all of the information contained within a single business process or unit of work-its primary purpose is to support daily operational tasks.

Accepted Answer

A) True 
 B)False

Question 12

What is the 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) Statistical detection 
B) Cluster analysis 
C) Association detection 
D) None of the answers is correct 
A) Statistical detection 
B) Cluster analysis 
C) Association detection 
D) None of the answers is correct

Question 13

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Accepted Answer

A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of the answers is correct 
A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of the answers is correct

Question 14

Forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

Accepted Answer

A) True 
 B)False

Question 15

ETL is one of the three main BI tool categories.What does ETL do,and what is the role of a data mart in business?

Accepted Answer

The prime purpose of data management too

Question 16

Which of the following represents the different information levels?

Accepted Answer

A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of the answers are correct 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of the answers are correct

Question 17

What is a primary key?

Accepted Answer

A) A field (or group of fields) that uniquely identifies a given record in a table 
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C) Characteristics or properties of an entity 
D) A field (or group of fields) that uniquely identifies a given attribute in a table 
A) A field (or group of fields) that uniquely identifies a given record in a table 
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C) Characteristics or properties of an entity 
D) A field (or group of fields) that uniquely identifies a given attribute in a table

Question 18

Which of the following represents the different information granularities?

Accepted Answer

A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of the answers are correct 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of the answers are correct

Question 19

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are examples of analytical information?

Accepted Answer

A) Airline ticket, sales receipts and packing slips 
B) Hotel reservation, sales receipts and packing slips 
C) Trends, future growth analysis, sales projections and product statistics 
D) Packing slips, grocery receipt and competitor information 
A) Airline ticket, sales receipts and packing slips 
B) Hotel reservation, sales receipts and packing slips 
C) Trends, future growth analysis, sales projections and product statistics 
D) Packing slips, grocery receipt and competitor information

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

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

What is one of the biggest pitfalls associated with real-time information?

An____________ allows separate systems to communicate directly with each other.

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

The primary purpose of a data warehouse is to ____________.

Standardising of data elements allows for:

What BI tools are required depends on how the data is currently managed and how it is to be analysed.BI software can be divided into three broad application categories;namely,data management tools,data discovery applications and reporting tools.What value can they potentially add to a business?

Analytical information encompasses all of the information contained within a single business process or unit of work-its primary purpose is to support daily operational tasks.

What is the 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?

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

ETL is one of the three main BI tool categories.What does ETL do,and what is the role of a data mart in business?

Which of the following represents the different information levels?

What is a primary key?

Which of the following represents the different information granularities?

A foreign key provides details about data.

Which of the following are examples of analytical information?

Information Systems Are Business

Our Connected World

E-Business Mobile Business

Decisions and Processes

Essentials of Information Systems

Systems Development and Project Management

Enterprise Architecture and Security

Enterprise Information Systems: ERP and SCN

Enterprise Information Systems: CRM and Collaboration Systems

Ethics, Privacy, Social Media and Future Trends

Filters

Exam 8: Data and Business Intelligence

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

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

What is one of the biggest pitfalls associated with real-time information?

An____________ allows separate systems to communicate directly with each other.

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

The primary purpose of a data warehouse is to ____________.

Standardising of data elements allows for:

What BI tools are required depends on how the data is currently managed and how it is to be analysed.BI software can be divided into three broad application categories;namely,data management tools,data discovery applications and reporting tools.What value can they potentially add to a business?

Analytical information encompasses all of the information contained within a single business process or unit of work-its primary purpose is to support daily operational tasks.

What is the 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?

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

ETL is one of the three main BI tool categories.What does ETL do,and what is the role of a data mart in business?

Which of the following represents the different information levels?

What is a primary key?

Which of the following represents the different information granularities?

A foreign key provides details about data.

Which of the following are examples of analytical information?

Information Systems Are Business

Our Connected World

E-Business Mobile Business

Decisions and Processes

Essentials of Information Systems

Systems Development and Project Management

Enterprise Architecture and Security

Enterprise Information Systems: ERP and SCN

Enterprise Information Systems: CRM and Collaboration Systems

Ethics, Privacy, Social Media and Future Trends

Filters