Question 1

Explain the process of consolidating data from operational systems with other organizational data.

Accepted Answer

A crucial process for consolidating data from operational systems with other organizational data to facilitate the use of data mining techniques to gain the greatest and broadest understanding from the data is extraction,transformation,and loading.
First,the data need to be extracted from various different systems.In the transformation stage,data are being cleansed and manipulated to fit the needs of the analysis.Data cleansing refers to the process of detecting,correcting (e.g.,standardizing the format),or removing corrupt or inaccurate data retrieved from different systems.Finally,the transformed data are loaded into the data warehouse and are ready for being used for complex analyses.

Question 2

Which of the following is a disadvantage of the database approach?

Accepted Answer

A)  enforcement of standards 
B)  program-data independence 
C)  organizational conflict 
D)  minimal data redundancy 
E)  reduced program maintenance 
A)  enforcement of standards 
B)  program-data independence 
C)  organizational conflict 
D)  minimal data redundancy 
E)  reduced program maintenance C

Question 3

)Online transaction processing (OLTP)systems enable us to fill out a grid,or template,in order to construct a sample or description of the data we would like to see,typically using the drag-and-drop features of a graphical user interface to create a query quickly and easily.

Accepted Answer

A) True 
 B)False  False

Question 4

The systems that are used to interact with customers and run a business in real time are called ________.

Accepted Answer

A)  tactical systems 
B)  strategic systems 
C)  operational systems 
D)  informational systems 
E)  executive systems 
A)  tactical systems 
B)  strategic systems 
C)  operational systems 
D)  informational systems 
E)  executive systems

Question 5

While using digital dashboards,pull reporting is conducted to ________.

Accepted Answer

A)  alert the user of any items that require immediate attention 
B)  provide the decision makers with a quick overview of key performance indicators 
C)  discover "hidden" predictive relationships in the data 
D)  analyze the root causes of an exception 
E)  extract textual information from Web documents 
A)  alert the user of any items that require immediate attention 
B)  provide the decision makers with a quick overview of key performance indicators 
C)  discover "hidden" predictive relationships in the data 
D)  analyze the root causes of an exception 
E)  extract textual information from Web documents

Question 6

Which of the following is a role of monitoring and sensing agents?

Accepted Answer

A)  tracking inventory levels 
B)  sending a report at the first of the month automatically 
C)  assembling customized news 
D)  analyzing data warehouses to detect changes deemed important by a user 
E)  finding the best price for a particular product the user wants to purchase 
A)  tracking inventory levels 
B)  sending a report at the first of the month automatically 
C)  assembling customized news 
D)  analyzing data warehouses to detect changes deemed important by a user 
E)  finding the best price for a particular product the user wants to purchase

Question 7

Describe online analytical processing.

Accepted Answer

Online analytical processing (OLAP)refer

Question 8

Text mining refers to extracting textual information from Web documents.

Accepted Answer

A) True 
 B)False

Question 9

Data mining agents are also known as shopping bots.

Accepted Answer

A) True 
 B)False

Question 10

In online analytical processing systems,________ provide a way to summarize the data.

Accepted Answer

A)  forms 
B)  measures 
C)  facts 
D)  records 
E)  dimensions 
A)  forms 
B)  measures 
C)  facts 
D)  records 
E)  dimensions

Question 11

One of the advantages of the database approach is program-data independence,which means that it is ________.

Accepted Answer

A)  easier to deploy and control data access using a centralized system 
B)  easier to evolve and alter software to changing business needs when data and programs are independent 
C)  a centralized system,making it easier to enforce access restrictions 
D)  a centralized system,making it much easier to enforce standards and rules for data creation,modification,naming,and deletion 
E)  useful for eliminating redundancy,greatly reducing the possibilities of inconsistency 
A)  easier to deploy and control data access using a centralized system 
B)  easier to evolve and alter software to changing business needs when data and programs are independent 
C)  a centralized system,making it easier to enforce access restrictions 
D)  a centralized system,making it much easier to enforce standards and rules for data creation,modification,naming,and deletion 
E)  useful for eliminating redundancy,greatly reducing the possibilities of inconsistency

Question 12

Which of the following statements is true about a data mart?

Accepted Answer

A)  It standardizes the format of data retrieved from different systems. 
B)  It contains selected data from the data warehouse. 
C)  It stores master data only. 
D)  It is a compilation of data from the database that is organized and produced in printed format. 
E)  It helps to eliminate data duplication. 
A)  It standardizes the format of data retrieved from different systems. 
B)  It contains selected data from the data warehouse. 
C)  It stores master data only. 
D)  It is a compilation of data from the database that is organized and produced in printed format. 
E)  It helps to eliminate data duplication.

Question 13

Online analytical processing systems are designed for efficient retrieval of data and categorize data as measures and dimensions.

Accepted Answer

A) True 
 B)False

Question 14

Data type helps the DBMS ________.

Accepted Answer

A)  present the data in a useful format 
B)  format data 
C)  allocate storage space 
D)  eliminate data duplication 
E)  retrieve information 
A)  present the data in a useful format 
B)  format data 
C)  allocate storage space 
D)  eliminate data duplication 
E)  retrieve information

Question 15

________ are produced at predefined intervals to support routine decisions.

Accepted Answer

A)  Ad hoc queries 
B)  Exception reports 
C)  Drill-down reports 
D)  Scheduled reports 
E)  Key-indicator reports 
A)  Ad hoc queries 
B)  Exception reports 
C)  Drill-down reports 
D)  Scheduled reports 
E)  Key-indicator reports

Question 16

The purpose of a data warehouse is to ________.

Accepted Answer

A)  standardize the format of data retrieved from different systems 
B)  allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data 
C)  provide capabilities for discovering "hidden" predictive relationships in the data 
D)  put key business information into the hands of more decision makers 
E)  increase the complexity of the data to be analyzed 
A)  standardize the format of data retrieved from different systems 
B)  allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data 
C)  provide capabilities for discovering "hidden" predictive relationships in the data 
D)  put key business information into the hands of more decision makers 
E)  increase the complexity of the data to be analyzed

Question 17

Business rules are captured by the designers of the database and included in the data dictionary to ________.

Accepted Answer

A)  organize and sort the data,complete calculations,and allocate storage space 
B)  prevent illegal or illogical entries from entering the database 
C)  eliminate data duplication 
D)  make sure that each table contains only attributes that are related to the entity 
E)  capture the structure of the database 
A)  organize and sort the data,complete calculations,and allocate storage space 
B)  prevent illegal or illogical entries from entering the database 
C)  eliminate data duplication 
D)  make sure that each table contains only attributes that are related to the entity 
E)  capture the structure of the database

Question 18

A query is used to ________.

Accepted Answer

A)  organize and sort the data in a database 
B)  allocate storage space for a database 
C)  eliminate data duplication 
D)  retrieve data from a database 
E)  prevent illegal or illogical entries from entering the database 
A)  organize and sort the data in a database 
B)  allocate storage space for a database 
C)  eliminate data duplication 
D)  retrieve data from a database 
E)  prevent illegal or illogical entries from entering the database

Question 19

Which of the following is a recording of a user's path through a Web site?

Accepted Answer

A)  clustering 
B)  normalization 
C)  slicing and dicing 
D)  clickstream data 
E)  inferencing 
A)  clustering 
B)  normalization 
C)  slicing and dicing 
D)  clickstream data 
E)  inferencing

Question 20

Which of the following statements is true about hard data?

Accepted Answer

A)  It involves the use of text mining technologies. 
B)  It includes nonanalytical information. 
C)  It involves input from dedicated personnel. 
D)  It includes textual news stories. 
E)  It includes facts and numbers. 
A)  It involves the use of text mining technologies. 
B)  It includes nonanalytical information. 
C)  It involves input from dedicated personnel. 
D)  It includes textual news stories. 
E)  It includes facts and numbers.

Explain the process of consolidating data from operational systems with other organizational data.

Which of the following is a disadvantage of the database approach?

)Online transaction processing (OLTP)systems enable us to fill out a grid,or template,in order to construct a sample or description of the data we would like to see,typically using the drag-and-drop features of a graphical user interface to create a query quickly and easily.

The systems that are used to interact with customers and run a business in real time are called ________.

While using digital dashboards,pull reporting is conducted to ________.

Which of the following is a role of monitoring and sensing agents?

Describe online analytical processing.

Text mining refers to extracting textual information from Web documents.

Data mining agents are also known as shopping bots.

In online analytical processing systems,________ provide a way to summarize the data.

One of the advantages of the database approach is program-data independence,which means that it is ________.

Which of the following statements is true about a data mart?

Online analytical processing systems are designed for efficient retrieval of data and categorize data as measures and dimensions.

Data type helps the DBMS ________.

________ are produced at predefined intervals to support routine decisions.

The purpose of a data warehouse is to ________.

Business rules are captured by the designers of the database and included in the data dictionary to ________.

A query is used to ________.

Which of the following is a recording of a user's path through a Web site?

Which of the following statements is true about hard data?

Managing in the Digital World

Gaining Competitive Advantage Through Information Systems

Managing the Information Systems Infrastructure and Services

Enabling Business-to-Consumer Electronic Commerce

Enhancing Organizational Communication and Collaboration Using Social Media

Enhancing Business Processes Using Enterprise Information Systems

Strengthening Business-to-Business Relationships via Supply Chain and Customer Relationship

Developing and Acquiring Information Systems

Securing Information Systems

Foundations of Information Systems Infrastructure

Filters

Exam 6: Enhancing Business Intelligence Using Information Systems

Explain the process of consolidating data from operational systems with other organizational data.

Which of the following is a disadvantage of the database approach?

)Online transaction processing (OLTP)systems enable us to fill out a grid,or template,in order to construct a sample or description of the data we would like to see,typically using the drag-and-drop features of a graphical user interface to create a query quickly and easily.

The systems that are used to interact with customers and run a business in real time are called ________.

While using digital dashboards,pull reporting is conducted to ________.

Which of the following is a role of monitoring and sensing agents?

Describe online analytical processing.

Text mining refers to extracting textual information from Web documents.

Data mining agents are also known as shopping bots.

In online analytical processing systems,________ provide a way to summarize the data.

One of the advantages of the database approach is program-data independence,which means that it is ________.

Which of the following statements is true about a data mart?

Online analytical processing systems are designed for efficient retrieval of data and categorize data as measures and dimensions.

Data type helps the DBMS ________.

________ are produced at predefined intervals to support routine decisions.

The purpose of a data warehouse is to ________.

Business rules are captured by the designers of the database and included in the data dictionary to ________.

A query is used to ________.

Which of the following is a recording of a user's path through a Web site?

Which of the following statements is true about hard data?

Managing in the Digital World

Gaining Competitive Advantage Through Information Systems

Managing the Information Systems Infrastructure and Services

Enabling Business-to-Consumer Electronic Commerce

Enhancing Organizational Communication and Collaboration Using Social Media

Enhancing Business Processes Using Enterprise Information Systems

Strengthening Business-to-Business Relationships via Supply Chain and Customer Relationship

Developing and Acquiring Information Systems

Securing Information Systems

Foundations of Information Systems Infrastructure

Filters