Question 1

What is the difference between push and pull reports?

Accepted Answer

Organizations send a push report to users according to a preset schedule.Users receive the report without any activity on their part.In contrast, users must request a pull report.To obtain a pull report, a user goes to a Web portal or digital dashboard and clicks a link or button to cause the reporting system to produce and deliver the report.

Question 2

Explain report authoring, report management, and report delivery.

Accepted Answer

Report authoring involves connecting to data sources, creating a report structure, and formatting the report.Organizations can author reports by using a developer tool like Microsoft's Visual Studio.The purpose of report management is to define who receives what reports, when, and by what means.Most report management systems allow a report administrator to define user accounts and user groups and to assign particular users to particular groups.The report delivery function of a reporting system pushes reports or allows them to be pulled according to report management metadata.Reports can be delivered via an email server, via a Web site, via SOA services, or by other program-specific means.

Question 3

Emma needs to order thirty white shirts for a college play from an online store.She logs onto the Web site and enters her requirement.She receives a report stating that the store currently has only twenty shirts in stock.This information is an example of a(n)________.

Accepted Answer

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

Question 4

The ________ function of a reporting system pushes reports or allows them to be pulled according to report management metadata.

Accepted Answer

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

Question 5

Which of the following describes the reports, users, groups, roles, events, and other entities involved in the reporting activities of a reporting system?

Accepted Answer

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

Question 6

An online analytical processing (OLAP)cube can also be referred to as an ________.

Accepted Answer

A) OLAP database 
B) OLAP report 
C) OLAP service 
D) OLAP server 
A) OLAP database 
B) OLAP report 
C) OLAP service 
D) OLAP server

Question 7

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 8

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 9

Which of the following is a drawback of online analytical processing (OLAP)reports?

Accepted Answer

A) They have a single or no dimension. 
B) Their format is static in nature. 
C) They require a lot of computing power. 
D) They can perform arithmetic operations only on single sets of data. 
A) They have a single or no dimension. 
B) Their format is static in nature. 
C) They require a lot of computing power. 
D) They can perform arithmetic operations only on single sets of data.

Question 10

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 11

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 12

Alerts generated on the basis of user notification are not treated as reports.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Push reports are generated only on receiving a user request.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following report media is used for delivering a query report?

Accepted Answer

A) paper and PDF file 
B) digital dashboard 
C) Web site 
D) alerts via email 
A) paper and PDF file 
B) digital dashboard 
C) Web site 
D) alerts via email

Question 16

________ 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 17

A report on the current stock prices in the market is an example of a static report.

Accepted Answer

A) True 
 B)False

Question 18

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 19

What are reporting systems? What are the fundamental operations they perform?

Accepted Answer

A reporting system is an information sys

Question 20

Amy eagerly awaits the launch of the summer flash sale on her favorite online shopping site.She registers her cell phone number and email ID on the site to receive a notification when the sale begins.The notification that Amy will receive from the shopping site is an example of a(n)________.

Accepted Answer

A) query report 
B) subscription 
C) exception report 
D) alert 
A) query report 
B) subscription 
C) exception report 
D) alert

Exam 25: Reporting Systems and Olap

What is the difference between push and pull reports?

Explain report authoring, report management, and report delivery.

Emma needs to order thirty white shirts for a college play from an online store.She logs onto the Web site and enters her requirement.She receives a report stating that the store currently has only twenty shirts in stock.This information is an example of a(n)________.

The ________ function of a reporting system pushes reports or allows them to be pulled according to report management metadata.

Which of the following describes the reports, users, groups, roles, events, and other entities involved in the reporting activities of a reporting system?

An online analytical processing (OLAP)cube can also be referred to as an ________.

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.

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.

Which of the following is a drawback 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.

A pull report refers to a report ________.

Alerts generated on the basis of user notification are not treated as reports.

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

Push reports are generated only on receiving a user request.

Which of the following report media is used for delivering a query report?

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

A report on the current stock prices in the market is an example of a static report.

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.

What are reporting systems? What are the fundamental operations they perform?

Amy eagerly awaits the launch of the summer flash sale on her favorite online shopping site.She registers her cell phone number and email ID on the site to receive a notification when the sale begins.The notification that Amy will receive from the shopping site is an example of a(n)________.

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

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

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 Erpsystems

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