Question 1

Which of the following represents the different information formats?

Accepted Answer

A) Detail,summary,aggregate 
B) Document,presentation,spreadsheet,database 
C) Individual,department,enterprise 
D) None of the above 
A) Detail,summary,aggregate 
B) Document,presentation,spreadsheet,database 
C) Individual,department,enterprise 
D) None of the above

Question 2

A ________________ key is a field (or group of fields)that uniquely identifies a given record in a table.

Accepted Answer

The answer of A ________________ key is a field (or...

Question 3

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Accepted Answer

A) True 
 B)False

Question 4

What is another term for information cleansing?

Accepted Answer

A) Information mining 
B) Information scrubbing 
C) Information scrapping 
D) Information marts 
A) Information mining 
B) Information scrubbing 
C) Information scrapping 
D) Information marts

Question 5

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

A) True 
 B)False

Question 6

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The primary purpose of a data ___________ is to combine information,specifically,strategic information,throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Accepted Answer

The answer of The primary purpose of a data ___________...

Question 9

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 10

Explain ETL and the role of a data mart in business.

Accepted Answer

Extraction,transformation,and loading (E

Question 11

Real-time systems provide real-time information in response to requests.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following encompasses all of the information contained within a single business process or unit of work,and 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 13

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

Accepted Answer

A) Dynamic website 
B) Data-driven website 
C) Static information 
D) Dynamic information 
A) Dynamic website 
B) Data-driven website 
C) Static information 
D) Dynamic information

Question 14

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 15

The core component of any system,regardless of size,is a database and a database management system.

Accepted Answer

A) True 
 B)False

Question 16

What is the primary problem with redundant data?

Accepted Answer

A) It is difficult to determine which values are the most current 
B) It is often inconsistent 
C) It is difficult to determine which values are the most accurate 
D) All of the above 
A) It is difficult to determine which values are the most current 
B) It is often inconsistent 
C) It is difficult to determine which values are the most accurate 
D) All of the above

Question 17

The ___________ view of information focuses on how individual users logically access information to meet their own business needs.

Accepted Answer

The answer of The ___________ view of information focuses on...

Question 18

A data __________ is the smallest or basic unit of information.

Accepted Answer

The answer of A data __________ is the smallest or...

Question 19

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 20

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A) Block 
B) Square 
C) Column 
D) Cube 
A) Block 
B) Square 
C) Column 
D) Cube

Which of the following represents the different information formats?

A ________________ key is a field (or group of fields)that uniquely identifies a given record in a table.

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

What is another term for information cleansing?

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

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

The primary purpose of a data ___________ is to combine information,specifically,strategic information,throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Data warehouses struggle with combining too much standardized information.

Explain ETL and the role of a data mart in business.

Real-time systems provide real-time information in response to requests.

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

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

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

The core component of any system,regardless of size,is a database and a database management system.

What is the primary problem with redundant data?

The ___________ view of information focuses on how individual users logically access information to meet their own business needs.

A data __________ is the smallest or basic unit of information.

Which of the following are examples of transactional information?

Which of the following is the common term for the representation of multidimensional 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

Filters

Exam 6: Data: Business Intelligence

Which of the following represents the different information formats?

A ________________ key is a field (or group of fields)that uniquely identifies a given record in a table.

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

What is another term for information cleansing?

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

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

The primary purpose of a data ___________ is to combine information,specifically,strategic information,throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Data warehouses struggle with combining too much standardized information.

Explain ETL and the role of a data mart in business.

Real-time systems provide real-time information in response to requests.

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

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

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

The core component of any system,regardless of size,is a database and a database management system.

What is the primary problem with redundant data?

The ___________ view of information focuses on how individual users logically access information to meet their own business needs.

A data __________ is the smallest or basic unit of information.

Which of the following are examples of transactional information?

Which of the following is the common term for the representation of multidimensional 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

Filters