Question 1

How does a reporting system obtain the necessary data to generate reports?

Accepted Answer

Data from disparate data sources are read and combined, using filtering, sorting, grouping, and simple calculating, to produce information. Some data are generated within an organization, other data are obtained from public sources, and still other data may be purchased from data utilities.

Question 2

Reporting systems manipulate data into meaningful context using all of the following fundamental operations but ________.

Accepted Answer

A)  filtering data 
B)  sorting data 
C)  grouping data 
D)  creating data 
A)  filtering data 
B)  sorting data 
C)  grouping data 
D)  creating data D

Question 3

Which of the following is an example of a measure in an online analytical processing (OLAP) report?

Accepted Answer

A)  sales region 
B)  average cost 
C)  customer location 
D)  customer type 
A)  sales region 
B)  average cost 
C)  customer location 
D)  customer type B

Question 4

Kevin, the store manager of a retail store, wants a list of customers who have made more than two purchases from the store in the previous month. The ________ operation of a reporting system would help Kevin in obtaining this list.

Accepted Answer

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

Question 5

Reports that are updated and generated by a reporting system at the time of creation are referred to as ________.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Steve, the branch manager at a brokerage firm, is concerned about the sudden dip in stock prices. He asks for a report on the current stock prices to analyze the incurred loss. The report Steve requires 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 8

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 9

Every Monday, Jenny receives a ________ with information about the previous week's sales.

Accepted Answer

A)  pull report 
B)  push report 
C)  dashboard report 
D)  microdata report 
A)  pull report 
B)  push report 
C)  dashboard report 
D)  microdata report

Question 10

________ are used by a reporting system to prepare and deliver reports to proper users on a timely basis.

Accepted Answer

A)  Metadata 
B)  Microdata 
C)  Network packets 
D)  Data structures 
A)  Metadata 
B)  Microdata 
C)  Network packets 
D)  Data structures

Question 11

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

Accepted Answer

A reporting system is an information sys

Question 12

For query reports, the report delivery system serves as an intermediary between a user and a report generator.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Explain report authoring, report management, and report delivery.

Accepted Answer

Report authoring involves connecting to

Question 15

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 16

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 17

What is the difference between push and pull reports?

Accepted Answer

Organizations send a push report to user

Question 18

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 19

Reporting systems cannot generate reports that require calculations on data.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 25: Reporting Systems and Olap

How does a reporting system obtain the necessary data to generate reports?

Reporting systems manipulate data into meaningful context using all of the following fundamental operations but ________.

Which of the following is an example of a measure in an online analytical processing (OLAP) report?

Kevin, the store manager of a retail store, wants a list of customers who have made more than two purchases from the store in the previous month. The ________ operation of a reporting system would help Kevin in obtaining this list.

Reports that are updated and generated by a reporting system at the time of creation are referred to as ________.

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

Steve, the branch manager at a brokerage firm, is concerned about the sudden dip in stock prices. He asks for a report on the current stock prices to analyze the incurred loss. The report Steve requires is an example of a(n) ________.

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

Every Monday, Jenny receives a ________ with information about the previous week's sales.

________ are used by a reporting system to prepare and deliver reports to proper users on a timely basis.

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

For query reports, the report delivery system serves as an intermediary between a user and a report generator.

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

Explain report authoring, report management, and report delivery.

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

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

What is the difference between push and pull reports?

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.

Reporting systems cannot generate reports that require calculations on data.

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Processes, 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 2016

Database Design

Using Microsoft Access 2016

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

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters