Question 1

Information constraints is a measure of the quality of information.

Accepted Answer

A) True 
 B)False

Question 2

Information integrity issues occur when the same data element has different values.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following refers to immediate, up-to-date information?

Accepted Answer

A) Daily information 
B) Strategic information 
C) Real-time information 
D) Crisis information 
A) Daily information 
B) Strategic information 
C) Real-time information 
D) Crisis information

Question 4

What is extraction, transformation, and loading?

Accepted Answer

A) It is a process of entering data, tracking data, and loading it into a database 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D) It is a process that is performed at the beginning of the data mining model 
A) It is a process of entering data, tracking data, and loading it into a database 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D) It is a process that is performed at the beginning of the data mining model

Question 5

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Accepted Answer

A) True 
 B)False

Question 6

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Accepted Answer

A) True 
 B)False

Question 7

What is the smallest or basic unit of information?

Accepted Answer

A) Database management element 
B) Data element 
C) Data model 
D) Data integrity issue 
A) Database management element 
B) Data element 
C) Data model 
D) Data integrity issue

Question 8

In terms of big data what includes the scale of data?

Accepted Answer

A) Variety 
B) Veracity 
C) Volume 
D) Velocity 
A) Variety 
B) Veracity 
C) Volume 
D) Velocity

Question 9

What is a data map?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
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) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
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 10

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals, and generating financial analysis across departments and the enterprise as a whole for the executive team to review. Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.

Accepted Answer

A) levels 
B) formulas 
C) granularities 
D) focus 
A) levels 
B) formulas 
C) granularities 
D) focus

Question 11

What do data warehouses support?

Accepted Answer

A) OLAP 
B) Analytical processing 
C) OLTP 
D) OLAP and analytical processing 
A) OLAP 
B) Analytical processing 
C) OLTP 
D) OLAP and analytical processing

Question 12

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

Accepted Answer

A) Information inconsistency 
B) Information integrity issues 
C) Data governance 
D) Master data management 
A) Information inconsistency 
B) Information integrity issues 
C) Data governance 
D) Master data management

Question 13

Prediction is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is correct in reference to a database?

Accepted Answer

A) A database can support only one logical view 
B) A database can support many physical views 
C) A database can support many logical views 
D) A database can support up to 3 logical views 
A) A database can support only one logical view 
B) A database can support many physical views 
C) A database can support many logical views 
D) A database can support up to 3 logical views

Question 15

What can help uncover correlations and trends in data that would otherwise go unrecognized?

Accepted Answer

A) Informing 
B) Infographics 
C) Data visualization tools 
D) Business intelligence dashboards 
A) Informing 
B) Infographics 
C) Data visualization tools 
D) Business intelligence dashboards

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A data mart contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 18

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Accepted Answer

A) True 
 B)False

Question 19

Data validation helps to ensure that every data value is correct and accurate. In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not one of the five characteristics common to high-quality information?

Accepted Answer

A) Accuracy 
B) Completeness 
C) Quantity 
D) Consistency 
A) Accuracy 
B) Completeness 
C) Quantity 
D) Consistency

Information constraints is a measure of the quality of information.

Information integrity issues occur when the same data element has different values.

Which of the following refers to immediate, up-to-date information?

What is extraction, transformation, and loading?

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

What is the smallest or basic unit of information?

In terms of big data what includes the scale of data?

What is a data map?

What do data warehouses support?

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

Prediction is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Which of the following is correct in reference to a database?

What can help uncover correlations and trends in data that would otherwise go unrecognized?

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

A data mart contains a subset of data warehouse information.

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Data validation helps to ensure that every data value is correct and accurate. In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Which of the following is not one of the five characteristics common to high-quality 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

Information constraints is a measure of the quality of information.

Information integrity issues occur when the same data element has different values.

Which of the following refers to immediate, up-to-date information?

What is extraction, transformation, and loading?

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

What is the smallest or basic unit of information?

In terms of big data what includes the scale of data?

What is a data map?

What do data warehouses support?

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

Prediction is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Which of the following is correct in reference to a database?

What can help uncover correlations and trends in data that would otherwise go unrecognized?

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

A data mart contains a subset of data warehouse information.

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Data validation helps to ensure that every data value is correct and accurate. In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Which of the following is not one of the five characteristics common to high-quality 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