Deck 25: Reporting Systems and Olap

Question 1

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

Answer 1

False

Question 2

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.

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

Answer 2

B

Question 3

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

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

Answer 3

B

Question 4

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

Question 5

Reporting systems cannot generate reports that require calculations on data.

Question 6

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.

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

Question 7

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

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

Question 8

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

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

Question 9

A pull report refers to a report ________.

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 10

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)________.

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

Question 11

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

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

Question 12

A reporting system uses metadata to prepare and deliver reports to proper users on a timely basis.

Question 13

Which of the following types of reports allows users to dynamically change the report grouping structures?

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

Question 14

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)________.

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

Question 15

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

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

Question 16

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

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

Question 17

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)________.

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

Question 18

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

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

Question 19

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

Question 20

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

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

Question 21

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

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

Question 22

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

Question 23

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

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 24

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

Question 25

What is the difference between push and pull reports?

Question 26

An online analytical processing (OLAP)cube is a characteristic of a measure in an OLAP report.

Question 27

Explain report authoring, report management, and report delivery.

Question 28

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

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

Question 29

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

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

Question 30

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

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

Question 31

Explain the different types of reports.

Question 32

In the case of online analytical processing (OLAP), a presentation of a measure with associated dimensions is referred to as an ________.

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

Question 33

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

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

Question 34

Which of the following statements is true of dimensional databases?

A)They store millions of static online analytical processing (OLAP)reports.
B)They are structured to support OLAP processing.
C)They specialize in sorting functions alone.
D)They specialize in filtering functions alone.

Question 35

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.

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

Question 36

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

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

Question 37

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

Question 38

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

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

Question 39

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

Question 40

Push reports are generated only on receiving a user request.

Question 41

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.

Question 42

Describe online analytical processing (OLAP).

Question 43

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

Question 44

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