Deck 25: Reporting Systems and Olap

Question 1

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

Answer 1

making simple calculations on the data.

Question 2

Reports that users receive on declaring that they wish to receive notification of events via email or on their cell phones are termed as ________.

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

Answer 2

D

Question 3

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

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

Answer 3

B

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

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

Question 9

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

Question 10

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)microdata
D)metadata

Question 11

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 store manager obtain such a list?

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

Question 12

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

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

Question 13

A pull report refers to a report ________.

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

Question 14

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

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

Question 15

Query reports allow users to dynamically change report grouping structures.

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

Reporting systems cannot generate reports that require calculations on data.

Question 21

Purchase date is an example of a ________ in an OLAP report.

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

Question 22

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)database reports
B)query reports
C)OLAP reports
D)static reports

Question 23

In the case of online analytical processing,the 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 24

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

Question 25

What is the difference between push and pull reports?

Question 26

Explain report authoring,management,and delivery.

Question 27

In an OLAP report,a data item that is to be processed is called a ________.

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

Question 28

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

Question 29

Which of the following is an example of a measure in an OLAP report?

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

Question 30

Push reports are generated only on receiving a user request.

Question 31

An OLAP cube can also be referred to as an ________.

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

Question 32

Which of the following is a drawback of OLAP reports?

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

Question 33

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

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

Question 34

Which of the following statements is true of dimensional databases?

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

Question 35

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

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

Question 36

In OLAP reports,a dimension refers to an item that is to be processed in the report.

Question 37

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

Question 38

An OLAP cube is a characteristic of a measure in an OLAP report.

Question 39

Explain the different types of reports.

Question 40

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 evaluation
D)report delivery

Question 41

The process of dividing the data in OLAP reports into more details is termed drill-down.

Question 42

Users are not allowed to alter the format of OLAP reports.

Question 43

Describe online analytical processing.

Question 44

Databases that are structured to support OLAP processing are called dimensional databases.