Question 1

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A) Data warehouses make quick decisions, data marts make slow decisions 
B) Data warehouse tackle ethical issues, data marts tackle hypothetical issues 
C) Data warehouses have a more organization-wide focus, data marts have functional focus 
D) Data warehouses have a physical focus, data marts have logical focus 
A) Data warehouses make quick decisions, data marts make slow decisions 
B) Data warehouse tackle ethical issues, data marts tackle hypothetical issues 
C) Data warehouses have a more organization-wide focus, data marts have functional focus 
D) Data warehouses have a physical focus, data marts have logical focus

Question 2

Veracity includes the uncertainty of data, including biases, noise, and abnormalities.

Accepted Answer

A) True 
 B)False

Question 3

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

Accepted Answer

A) Identity management. 
B) Master data management. 
C) Data validation. 
D) Data latency. 
A) Identity management. 
B) Master data management. 
C) Data validation. 
D) Data latency.

Question 4

In terms of big data what is velocity?

Accepted Answer

A) Includes different forms of structured and unstructured data. 
B) Includes the uncertainty of data, including biases, noise, and abnormalities. 
C) Includes the scale of data. 
D) Includes the analysis of streaming data as it travels around the Internet. 
A) Includes different forms of structured and unstructured data. 
B) Includes the uncertainty of data, including biases, noise, and abnormalities. 
C) Includes the scale of data. 
D) Includes the analysis of streaming data as it travels around the Internet.

Question 5

How would the technology industry use business intelligence?

Accepted Answer

A) Track crime patterns, locations, and criminal behavior 
B) Analyze customer demographics 
C) Predict sales, inventory levels, and distribution 
D) Predict hardware failures 
A) Track crime patterns, locations, and criminal behavior 
B) Analyze customer demographics 
C) Predict sales, inventory levels, and distribution 
D) Predict hardware failures

Question 6

A data warehouse is a central location in which data is stored and managed.

Accepted Answer

A) True 
 B)False

Question 7

Organizational information comes at the same level, formats and granularities.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not a dirty data problem?

Accepted Answer

A) Duplicate data. 
B) Inaccurate data. 
C) Specific data. 
D) Non-integrated data. 
A) Duplicate data. 
B) Inaccurate data. 
C) Specific data. 
D) Non-integrated data.

Question 9

What are the rules that help ensure the quality of information?

Accepted Answer

A) Information integrity 
B) Integrity constraints 
C) Relational integrity constraints 
D) Business-critical integrity constraints 
A) Information integrity 
B) Integrity constraints 
C) Relational integrity constraints 
D) Business-critical integrity constraints

Question 10

What is source data?

Accepted Answer

A) Identifies the primary location where data is collected. 
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) Identifies the primary location where data is collected. 
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 11

Optimization is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Accepted Answer

A) True 
 B)False

Question 12

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

Accepted Answer

A) True 
 B)False

Question 13

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A) Database 
B) Data model 
C) Data mining 
D) Data intelligence 
A) Database 
B) Data model 
C) Data mining 
D) Data intelligence

Question 14

What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools?

Accepted Answer

A) Big data 
B) Distributed computing 
C) Advanced analytics 
D) Data scientist 
A) Big data 
B) Distributed computing 
C) Advanced analytics 
D) Data scientist

Question 15

Volume includes the uncertainty of data, including biases, noise, and abnormalities.

Accepted Answer

A) True 
 B)False

Question 16

What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Accepted Answer

A) Fast data 
B) Outlier 
C) Analysis paralysis 
D) Cube 
A) Fast data 
B) Outlier 
C) Analysis paralysis 
D) Cube

Question 17

What includes data that change based on user actions?

Accepted Answer

A) Content creator 
B) Content editor 
C) Static information 
D) Dynamic information 
A) Content creator 
B) Content editor 
C) Static information 
D) Dynamic information

Question 18

Timely information asks if the information current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 19

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 20

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Accepted Answer

A) True 
 B)False

What are the primary differences between a data warehouse and a data mart?

Veracity includes the uncertainty of data, including biases, noise, and abnormalities.

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

In terms of big data what is velocity?

How would the technology industry use business intelligence?

A data warehouse is a central location in which data is stored and managed.

Organizational information comes at the same level, formats and granularities.

Which of the following is not a dirty data problem?

What are the rules that help ensure the quality of information?

What is source data?

Optimization is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

What maintains information about various types of objects, events, people, and places?

What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools?

Volume includes the uncertainty of data, including biases, noise, and abnormalities.

What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

What includes data that change based on user actions?

Timely information asks if the information current with respect to the business needs.

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

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

What are the primary differences between a data warehouse and a data mart?

Veracity includes the uncertainty of data, including biases, noise, and abnormalities.

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

In terms of big data what is velocity?

How would the technology industry use business intelligence?

A data warehouse is a central location in which data is stored and managed.

Organizational information comes at the same level, formats and granularities.

Which of the following is not a dirty data problem?

What are the rules that help ensure the quality of information?

What is source data?

Optimization is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

What maintains information about various types of objects, events, people, and places?

What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools?

Volume includes the uncertainty of data, including biases, noise, and abnormalities.

What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

What includes data that change based on user actions?

Timely information asks if the information current with respect to the business needs.

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

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