Question 1

Which of the following occurs during data cleansing?

Accepted Answer

A) clean missing records 
B) clean redundant records 
C) clean inaccurate data 
D) All of these are correct. 
A) clean missing records 
B) clean redundant records 
C) clean inaccurate data 
D) All of these are correct.

Question 2

Which of the following are examples of transactional information?

Accepted Answer

A) airline ticket, sales receipts, and packing slips 
B) trends and sales statistics 
C) product sales results, grocery receipts, and growth projections 
D) airline tickets and sales growth spreadsheets 
A) airline ticket, sales receipts, and packing slips 
B) trends and sales statistics 
C) product sales results, grocery receipts, and growth projections 
D) airline tickets and sales growth spreadsheets

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What is a foreign key?

Accepted Answer

A) a field (or group of fields) that uniquely identifies a given entity 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 entity 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 5

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 6

What is it called when each transaction, entity, and event is represented only once in the information?

Accepted Answer

A) uniqueness 
B) accuracy 
C) consistency 
D) timeliness 
A) uniqueness 
B) accuracy 
C) consistency 
D) timeliness

Question 7

What is a real-time system?

Accepted Answer

A) provides immediate, up-to-date information 
B) provides real-time information in response to query requests 
C) encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks 
D) 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 
A) provides immediate, up-to-date information 
B) provides real-time information in response to query requests 
C) encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks 
D) 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

Question 8

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 9

Human-generated unstructured data includes text messages, social media data, and emails.

Accepted Answer

A) True 
 B)False

Question 10

Machine-generated data is data that humans, in interaction with computers, generate.Human-generated structured data includes input data, click-stream data, or gaming data.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a business-critical integrity constraint?

Accepted Answer

A) System will not allow an entry for an order for a nonexistent customer. 
B) System will not allow returns of fresh produce after 15 days past delivery. 
C) System will not allow shipping a product to a customer who does not have a valid address. 
D) system will not allow shipping of a nonexistent product to a customer. 
A) System will not allow an entry for an order for a nonexistent customer. 
B) System will not allow returns of fresh produce after 15 days past delivery. 
C) System will not allow shipping a product to a customer who does not have a valid address. 
D) system will not allow shipping of a nonexistent product to a customer.

Question 12

Define a data warehouse, and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection

Question 13

How would the retail 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 14

A 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 15

What is classification?

Accepted Answer

A) determines values for an unknown continuous variable behavior or estimated future value 
B) determines which things go together 
C) segments a heterogeneous population of more homogeneous subgroups 
D) assigns records to one of a predefined set of classes 
A) determines values for an unknown continuous variable behavior or estimated future value 
B) determines which things go together 
C) segments a heterogeneous population of more homogeneous subgroups 
D) assigns records to one of a predefined set of classes

Question 16

Velocity includes different forms of structured and unstructured data.

Accepted Answer

A) True 
 B)False

Question 17

Velocity includes the analysis of streaming data as it travels around the Internet.

Accepted Answer

A) True 
 B)False

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) executives, managers, operational employees 
A) detail, summary, aggregate 
B) document, presentation, spreadsheet, database 
C) individual, department, enterprise 
D) executives, managers, operational employees

Question 19

Big data 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) True 
 B)False

Question 20

What is optimization?

Accepted Answer

A) a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover 
B) 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 
C) predictions based on time-series information 
D) a statistical process for estimating the relationships among variables 
A) a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover 
B) 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 
C) predictions based on time-series information 
D) a statistical process for estimating the relationships among variables

Which of the following occurs during data cleansing?

Which of the following are examples of transactional information?

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

What is a foreign key?

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

What is it called when each transaction, entity, and event is represented only once in the information?

What is a real-time system?

Data warehouses struggle with combining too much standardized information.

Human-generated unstructured data includes text messages, social media data, and emails.

Machine-generated data is data that humans, in interaction with computers, generate.Human-generated structured data includes input data, click-stream data, or gaming data.

Which of the following is a business-critical integrity constraint?

Define a data warehouse, and provide a few reasons it can make a manager more effective.

How would the retail industry use business intelligence?

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

What is classification?

Velocity includes different forms of structured and unstructured data.

Velocity includes the analysis of streaming data as it travels around the Internet.

Which of the following represents the different information granularities?

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

What is optimization?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns: Module 2: Technical Foundations of MIS

Infrastructures: Sustainable Technologies

Networks: Mobile Business: Module 3: Enterprise MIS

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporateresponsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Data-Bases-Apply Your Knowledge-Glossary

Filters

Exam 6: Data: Business Intelligence

Which of the following occurs during data cleansing?

Which of the following are examples of transactional information?

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

What is a foreign key?

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

What is it called when each transaction, entity, and event is represented only once in the information?

What is a real-time system?

Data warehouses struggle with combining too much standardized information.

Human-generated unstructured data includes text messages, social media data, and emails.

Machine-generated data is data that humans, in interaction with computers, generate.Human-generated structured data includes input data, click-stream data, or gaming data.

Which of the following is a business-critical integrity constraint?

Define a data warehouse, and provide a few reasons it can make a manager more effective.

How would the retail industry use business intelligence?

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

What is classification?

Velocity includes different forms of structured and unstructured data.

Velocity includes the analysis of streaming data as it travels around the Internet.

Which of the following represents the different information granularities?

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

What is optimization?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns: Module 2: Technical Foundations of MIS

Infrastructures: Sustainable Technologies

Networks: Mobile Business: Module 3: Enterprise MIS

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporateresponsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Data-Bases-Apply Your Knowledge-Glossary

Filters