Question 1

Online analytical processing tools enable users to ________.

Accepted Answer

A)   discover hidden predictive relationships in the data
B)   find associations or correlations among sets of items
C)   analyze different dimensions of data beyond simple data summaries
D)   group related records together on the basis of having similar values for attributes
E)   extract textual information from Web documentsF) A) and E)
G) A) and B)

Question 2

A decision support system (DSS)uses models to manipulate data.

Accepted Answer

A) True 
 B)False

Question 3

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 databaseF) C) and D)
G) A) and B)

Question 4

When we consider entities as tables,each column is a(n) ________.

Accepted Answer

A)   attribute
B)   record
C)   form
D)   applet
E)   queryF) B) and E)
G) A) and C)

Question 5

Which of the following statements is true about exception reports?

Accepted Answer

A)   They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
B)   They are produced at predefined intervals to support routine decisions.
C)   They answer unplanned information requests to support a non-routine decision.
D)   They provide a summary of critical information on a recurring schedule.
E)   They highlight situations that are out of the normal range.F) None of the above
G) All of the above

Question 6

An attribute is also referred to as a ________.

Accepted Answer

A)   form
B)   record
C)   field
D)   query
E)   botF) A) and D)
G) A) and C)

Question 7

The processing in an expert system (ES) is called ________.

Accepted Answer

A)   clustering
B)   inferencing
C)   normalizing
D)   recommending
E)   data cleansingF) B) and E)
G) B) and C) B

Question 8

Which of the following statements is true about business intelligence?

Accepted Answer

A)   It is an act of outsourcing tasks, traditionally performed by an employee or contractor, to an undefined, large group of people or community, through the use of information technology.
B)   It is the process by which a customer-owned mutual organization or cooperative changes legal form to a joint stock company.
C)   It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
D)   It is an organization's process of defining its strategy, or direction, and making decisions on allocating its resources to pursue this strategy, including its capital and people.
E)   It is the use of human resources to gather and analyze information from external sources in order to make better business decisions.F) C) and D)
G) None of the above

Question 9

Data mining agents are also known as shopping bots.

Accepted Answer

A) True 
 B)False

Question 10

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 a 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.F) B) and C)
G) A) and E) B

Question 11

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

Accepted Answer

A)   forms
B)   measures
C)   facts
D)   records
E)   dimensionsF) A) and B)
G) B) and E) E

Question 12

Which of the following statements is true about a rule in expert systems?

Accepted Answer

A)   It groups related records together on the basis of having similar values for attributes.
B)   It makes sure that each table contains only attributes that are related to an entity.
C)   It allows multiple dimensions to be added to a traditional two-dimensional table.
D)   It encodes knowledge after collecting information from a user.
E)   It presents a view of short-term technology integration.F) A) and E)
G) D) and E)

Question 13

Master data management is a management rather than a technology-focused issue.

Accepted Answer

A) True 
 B)False

Question 14

In a distributed online environment,performing real-time analytical processing enhances the performance of transaction processing.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following statements is true about an information system?

Accepted Answer

A)   Its primary purpose is to run the business on a current basis.
B)   It is primarily used by online customers, clerks, salespersons, and administrators.
C)   It consists of narrow and simple updates and queries.
D)   Its design goal is to enhance performance.
E)   Its design goal is to enhance ease of access and use.F) B) and E)
G) A) and E)

Question 16

The output from an expert system is called inferencing.

Accepted Answer

A) True 
 B)False

Question 17

By combining human intelligence and reasoning capabilities with technology's retrieval and analysis capabilities,visual analytics can help in decision making.

Accepted Answer

A) True 
 B)False

Question 18

The primary use of online transaction processing (OLTP)systems is to define a set of reachable and exploitable vulnerabilities present in a database.

Accepted Answer

A) True 
 B)False

Question 19

In a database management system (DBMS) ,data are kept separate from the applications' programming code.This means that ________.

Accepted Answer

A)   an application cannot be changed without making changes to the database
B)   an application's programming code needs to be updated continuously to keep up with the database
C)   an application needs to be changed when the database is changed
D)   the database does not need to be changed if a change is made to an application
E)   the database needs to be changed when a change is made to an applicationF) A) and D)
G) B) and E)

Question 20

Which of the following statements is true about key-indicator reports?

Accepted Answer

A)   They provide a summary of critical information on a recurring schedule.
B)   They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
C)   They are produced at predefined intervals to support routine decisions.
D)   They highlight situations that are out of the normal range.
E)   They answer unplanned information requests to support a non-routine decision.F) None of the above
G) A) and E)

Exam 6: Enhancing Business Intelligence Using Information Systems

Online analytical processing tools enable users to ________.

Correct AnswerverifiedShow Answer

A decision support system (DSS)uses models to manipulate data.

Correct AnswerverifiedShow Answer

A query is used to ________.

Correct AnswerverifiedShow Answer

When we consider entities as tables,each column is a(n) ________.

Correct AnswerverifiedShow Answer

Which of the following statements is true about exception reports?

Correct AnswerverifiedShow Answer

An attribute is also referred to as a ________.

Correct AnswerverifiedShow Answer

The processing in an expert system (ES) is called ________.

Correct AnswerverifiedB

Which of the following statements is true about business intelligence?

Correct AnswerverifiedShow Answer

Data mining agents are also known as shopping bots.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedE

Which of the following statements is true about a rule in expert systems?

Correct AnswerverifiedShow Answer

Master data management is a management rather than a technology-focused issue.

Correct AnswerverifiedShow Answer

In a distributed online environment,performing real-time analytical processing enhances the performance of transaction processing.

Correct AnswerverifiedShow Answer

Which of the following statements is true about an information system?

Correct AnswerverifiedShow Answer

The output from an expert system is called inferencing.

Correct AnswerverifiedShow Answer

By combining human intelligence and reasoning capabilities with technology's retrieval and analysis capabilities,visual analytics can help in decision making.

Correct AnswerverifiedShow Answer

The primary use of online transaction processing (OLTP)systems is to define a set of reachable and exploitable vulnerabilities present in a database.

Correct AnswerverifiedShow Answer

In a database management system (DBMS) ,data are kept separate from the applications' programming code.This means that ________.

Correct AnswerverifiedShow Answer

Which of the following statements is true about key-indicator reports?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
E

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified