Deck 25: Reporting Systems and OLAP

Question 1

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

Answer 1

C

Question 2

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

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

Answer 2

B

Question 3

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

Answer 3

True

Question 4

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

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

Question 6

Reporting systems cannot generate reports that require calculations on data.

Question 7

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

Question 8

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?

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

Question 9

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

Question 10

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

Question 11

Reports that are prepared in response to data entered by users are termed ________.

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

Question 12

Reports that users receive when they declare that they wish to receive notifications of events via email or on their cell phones are known as ________.

A)query reports
B)subscriptions
C)exception reports
D)alerts

Question 13

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 14

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 15

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 16

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 17

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

Question 18

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 19

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 20

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 21

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 22

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 23

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 24

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 25

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

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

Question 26

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 27

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

Question 28

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 29

Explain report authoring,management,and report delivery.

Question 30

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 31

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 32

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

Question 33

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

Question 34

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 35

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

Question 36

Explain the different types of reports.

Question 37

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

Question 38

Push reports are generated only on receiving a user request.

Question 39

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 40

What is the difference between push and pull reports?

Question 41

Describe online analytical processing (OLAP).

Question 42

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