Question 1

What is the process of analyzing data to extract information not offered by the raw data alone?

Accepted Answer

A) Data integrity 
B) Data mart analysis 
C) Data mining 
D) Data extraction 
A) Data integrity 
B) Data mart analysis 
C) Data mining 
D) Data extraction C

Question 2

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following statements is true regarding customer information?

Accepted Answer

A) Customer information can exist in several operational systems. 
B) Customer information in each operational system could change. 
C) Customer information in each operational system can be different. 
D) All of these. 
A) Customer information can exist in several operational systems. 
B) Customer information in each operational system could change. 
C) Customer information in each operational system can be different. 
D) All of these. D

Question 4

Many firms complete data ___________ audits to determine the accuracy and completeness of their data.

Accepted Answer

The answer of Many firms complete data ___________ audits to...

Question 5

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 6

Organizational information comes at different levels and in different formats and granularities.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks?

Accepted Answer

A) Targeted information 
B) Analytical information 
C) Productive information 
D) Transactional information 
A) Targeted information 
B) Analytical information 
C) Productive information 
D) Transactional information

Question 8

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A) True 
 B)False

Question 9

Nestlé is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?

Accepted Answer

A) They had 550,000 actual vendors, yet the information reports showed more than 9 million due to duplication and abbreviation inaccuracies. 
B) Some of the vendor names were abbreviated, whereas others were not. 
C) They had too many inaccuracies and duplications to be able to identify customer profitability. 
D) All of these 
A) They had 550,000 actual vendors, yet the information reports showed more than 9 million due to duplication and abbreviation inaccuracies. 
B) Some of the vendor names were abbreviated, whereas others were not. 
C) They had too many inaccuracies and duplications to be able to identify customer profitability. 
D) All of these

Question 10

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

Accepted Answer

A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of these 
A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of these

Question 11

Data mining is the process of analyzing data to extract information not offered by the raw _______ alone.

Accepted Answer

The answer of Data mining is the process of analyzing...

Question 12

Which of the following occurs when the same data element has different values?

Accepted Answer

A) Data modeling issue 
B) Data mining issue 
C) Data governance issue 
D) Data inconsistency issue 
A) Data modeling issue 
B) Data mining issue 
C) Data governance issue 
D) Data inconsistency issue

Question 13

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 14

Of the two primary tools available for retrieving information from a DBMS, the first is a _______ by example tool that helps users graphically design the answer to a question against a database.

Accepted Answer

The answer of Of the two primary tools available for...

Question 15

Which of the following is not an advantage of a data-driven website?

Accepted Answer

A) Development 
B) Minimizing human error 
C) Increasing update costs 
D) More efficient 
A) Development 
B) Minimizing human error 
C) Increasing update costs 
D) More efficient

Question 16

What type of keys do you need to use to create a relational database model?

Accepted Answer

A) Primary keys and secondary keys 
B) Primary keys and foreign keys 
C) Entity keys and attribute keys 
D) Relational keys and DBMS keys 
A) Primary keys and secondary keys 
B) Primary keys and foreign keys 
C) Entity keys and attribute keys 
D) Relational keys and DBMS keys

Question 17

A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

Accepted Answer

A) True 
 B)False

Question 18

What are rules that enforce basic and fundamental information-based constraints?

Accepted Answer

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

Question 19

Which of the following provides real-time information in response to requests?

Accepted Answer

A) Sales system 
B) Transactional system 
C) Real-time system 
D) Salary system 
A) Sales system 
B) Transactional system 
C) Real-time system 
D) Salary system

Question 20

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

What is the process of analyzing data to extract information not offered by the raw data alone?

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Which of the following statements is true regarding customer information?

Many firms complete data ___________ audits to determine the accuracy and completeness of their 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.

Organizational information comes at different levels and in different formats and granularities.

Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks?

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Nestlé is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?

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

Data mining is the process of analyzing data to extract information not offered by the raw _______ alone.

Which of the following occurs when the same data element has different values?

The primary purpose of a data warehouse is to perform transactional processes.

Of the two primary tools available for retrieving information from a DBMS, the first is a _______ by example tool that helps users graphically design the answer to a question against a database.

Which of the following is not an advantage of a data-driven website?

What type of keys do you need to use to create a relational database model?

A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

What are rules that enforce basic and fundamental information-based constraints?

Which of the following provides real-time information in response to requests?

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

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters

Exam 6: Data: Business Intelligence

What is the process of analyzing data to extract information not offered by the raw data alone?

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Which of the following statements is true regarding customer information?

Many firms complete data ___________ audits to determine the accuracy and completeness of their 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.

Organizational information comes at different levels and in different formats and granularities.

Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks?

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Nestlé is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?

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

Data mining is the process of analyzing data to extract information not offered by the raw _______ alone.

Which of the following occurs when the same data element has different values?

The primary purpose of a data warehouse is to perform transactional processes.

Of the two primary tools available for retrieving information from a DBMS, the first is a _______ by example tool that helps users graphically design the answer to a question against a database.

Which of the following is not an advantage of a data-driven website?

What type of keys do you need to use to create a relational database model?

A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

What are rules that enforce basic and fundamental information-based constraints?

Which of the following provides real-time information in response to requests?

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

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters