Question 1

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 2

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A) Data-driven website 
B) Interactive website 
C) Database performing website 
D) Data processing website 
A) Data-driven website 
B) Interactive website 
C) Database performing website 
D) Data processing website

Question 3

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 4

What is a content editor?

Accepted Answer

A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action. 
A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action.

Question 5

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) Executives, managers, operational employees 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) Executives, managers, operational employees

Question 6

Information integrity are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Question 7

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Accepted Answer

A) True 
 B)False

Question 8

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Accepted Answer

A) True 
 B)False

Question 9

What is classification?

Accepted Answer

A) Determines values for an unknown continuous variable behavior or estimated future value. 
B) Determine 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) Determine 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 10

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Inaccurate data 
B) Misleading data 
C) Non-formatted data 
D) All of the above 
A) Inaccurate data 
B) Misleading data 
C) Non-formatted data 
D) All of the above

Question 11

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Accepted Answer

A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above. 
A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above.

Question 12

Information granularity means immediate, up-to-date information.

Accepted Answer

A) True 
 B)False

Question 13

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 14

The four primary traits of the value of information include levels, formats, granularities, and type.

Accepted Answer

A) True 
 B)False

Question 15

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 16

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?

Accepted Answer

A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above. 
A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above.

Question 17

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Accepted Answer

A) Clustering 
B) Classification 
C) Estimation 
D) Affinity grouping 
A) Clustering 
B) Classification 
C) Estimation 
D) Affinity grouping

Question 18

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 19

How would the banking industry use business intelligence?

Accepted Answer

A) Analyze popular vacation locations with current flight listings 
B) Understand customer credit card usage and nonpayment rates 
C) Compare the demographics of patients with critical illnesses 
D) Predict claim amounts and medical coverage costs 
A) Analyze popular vacation locations with current flight listings 
B) Understand customer credit card usage and nonpayment rates 
C) Compare the demographics of patients with critical illnesses 
D) Predict claim amounts and medical coverage costs

Question 20

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

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

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Data warehouses struggle with combining too much standardized information.

What is a content editor?

Which of the following represents the different information levels?

Information integrity are rules that help ensure the quality of information.

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

What is classification?

Which of the following is a problem associated with dirty data?

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Information granularity means immediate, up-to-date information.

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

The four primary traits of the value of information include levels, formats, granularities, and type.

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?

Which of the following forms of data mining assigns records to one of a predefined set of classes?

A foreign key provides details about data.

How would the banking industry use business intelligence?

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

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

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

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Data warehouses struggle with combining too much standardized information.

What is a content editor?

Which of the following represents the different information levels?

Information integrity are rules that help ensure the quality of information.

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

What is classification?

Which of the following is a problem associated with dirty data?

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Information granularity means immediate, up-to-date information.

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

The four primary traits of the value of information include levels, formats, granularities, and type.

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?

Which of the following forms of data mining assigns records to one of a predefined set of classes?

A foreign key provides details about data.

How would the banking industry use business intelligence?

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

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