Question 1

Which of the following does a user receive without any activity on his or her part?

Accepted Answer

A) pull report 
B) push report 
C) subscription 
D) alert 
A) pull report 
B) push report 
C) subscription 
D) alert B

Question 2

Query reports allow users to dynamically change the report grouping structures.

Accepted Answer

A) True 
 B)False  False

Question 3

The process of dividing the data in online analytical processing (OLAP)reports into more details is termed drill down.

Accepted Answer

A) True 
 B)False  True

Question 4

A(n)________ enables people to create information by processing data from disparate data sources and delivering that information to the proper users on a timely basis.

Accepted Answer

A) operating system 
B) reporting system 
C) intrusion detection system 
D) domain name system 
A) operating system 
B) reporting system 
C) intrusion detection system 
D) domain name system

Question 5

Which of the following types of reports has the ability to sum,count,average,and perform other simple arithmetic operations on groups of data?

Accepted Answer

A) query reports 
B) static reports 
C) database reports 
D) online analytical processing (OLAP)reports 
A) query reports 
B) static reports 
C) database reports 
D) online analytical processing (OLAP)reports

Question 6

An online analytical processing (OLAP)server reads data from an operational database,performs preliminary calculations,and stores the results of those calculations in an OLAP database.

Accepted Answer

A) True 
 B)False

Question 7

A pull report refers to a report ________.

Accepted Answer

A) sent to users according to a preset schedule 
B) about the functioning of an organization's information systems 
C) generated by user request 
D) prepared by an organization from a competitor's data 
A) sent to users according to a preset schedule 
B) about the functioning of an organization's information systems 
C) generated by user request 
D) prepared by an organization from a competitor's data

Question 8

The ________ in a reporting system indicate the channel to be used for sending a report to a user and whether the report is to be pushed or pulled.

Accepted Answer

A) metadata 
B) microdata 
C) network packets 
D) data structures 
A) metadata 
B) microdata 
C) network packets 
D) data structures

Question 9

Push reports are generated only on receiving a user request.

Accepted Answer

A) True 
 B)False

Question 10

In an online analytical processing (OLAP)report,the purchase date is an example of a(n)________.

Accepted Answer

A) measure 
B) attribute 
C) dimension 
D) variable 
A) measure 
B) attribute 
C) dimension 
D) variable

Question 11

Which of the following is an electronic report medium that can be customized for a particular user?

Accepted Answer

A) Web site 
B) email alert 
C) digital dashboard 
D) PDF file 
A) Web site 
B) email alert 
C) digital dashboard 
D) PDF file

Question 12

In an online analytical processing (OLAP)report,a data item that is to be processed is called a ________.

Accepted Answer

A) measure 
B) dimension 
C) cube 
D) target 
A) measure 
B) dimension 
C) cube 
D) target

Question 13

A report on the current stock prices in the market is an example of a(n)________.

Accepted Answer

A) static report 
B) dynamic report 
C) exception report 
D) query report 
A) static report 
B) dynamic report 
C) exception report 
D) query report

Question 14

Which of the following types of reports is an example of a push report?

Accepted Answer

A) static report 
B) dynamic report 
C) query report 
D) online analytical processing (OLAP)report 
A) static report 
B) dynamic report 
C) query report 
D) online analytical processing (OLAP)report

Question 15

________ involves connecting to data sources,creating report structures,and formatting reports.

Accepted Answer

A) Report evaluation 
B) Report authoring 
C) Report monitoring 
D) Report delivery 
A) Report evaluation 
B) Report authoring 
C) Report monitoring 
D) Report delivery

Question 16

Reports that are not subject to change and are prepared from underlying data are referred to as ________.

Accepted Answer

A) exception reports 
B) static reports 
C) subscription reports 
D) dynamic reports 
A) exception reports 
B) static reports 
C) subscription reports 
D) dynamic reports

Question 17

Users are not allowed to alter the format of online analytical processing (OLAP)reports.

Accepted Answer

A) True 
 B)False

Question 18

In online analytical processing (OLAP)reports,a dimension refers to an item that is to be processed in the report.

Accepted Answer

A) True 
 B)False

Question 19

Explain report authoring,management,and report delivery.

Accepted Answer

Report authoring involves connecting to

Question 20

The sales manager of a retail store wants a list of customers who have made more than three repeat purchases from the store.Which of the following operations of a reporting system would help the sales manager obtain such a list?

Accepted Answer

A) categorizing 
B) calculating 
C) grouping 
D) filtering 
A) categorizing 
B) calculating 
C) grouping 
D) filtering

Exam 25: Reporting Systems and OLAP

Which of the following does a user receive without any activity on his or her part?

Query reports allow users to dynamically change the report grouping structures.

The process of dividing the data in online analytical processing (OLAP)reports into more details is termed drill down.

A(n)________ enables people to create information by processing data from disparate data sources and delivering that information to the proper users on a timely basis.

Which of the following types of reports has the ability to sum,count,average,and perform other simple arithmetic operations on groups of data?

An online analytical processing (OLAP)server reads data from an operational database,performs preliminary calculations,and stores the results of those calculations in an OLAP database.

A pull report refers to a report ________.

The ________ in a reporting system indicate the channel to be used for sending a report to a user and whether the report is to be pushed or pulled.

Push reports are generated only on receiving a user request.

In an online analytical processing (OLAP)report,the purchase date is an example of a(n)________.

Which of the following is an electronic report medium that can be customized for a particular user?

In an online analytical processing (OLAP)report,a data item that is to be processed is called a ________.

A report on the current stock prices in the market is an example of a(n)________.

Which of the following types of reports is an example of a push report?

________ involves connecting to data sources,creating report structures,and formatting reports.

Reports that are not subject to change and are prepared from underlying data are referred to as ________.

Users are not allowed to alter the format of online analytical processing (OLAP)reports.

In online analytical processing (OLAP)reports,a dimension refers to an item that is to be processed in the report.

Explain report authoring,management,and report delivery.

The sales manager of a retail store wants a list of customers who have made more than three repeat purchases from the store.Which of the following operations of a reporting system would help the sales manager obtain such a list?

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters