Deck 25: Reporting Systems and OLAP

Question 1

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

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

Answer 1

A

Question 2

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

Answer 2

C

Question 3

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) operating system
B) reporting system
C) intrusion detection system
D) domain name system

Answer 3

B

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

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 9

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

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

Question 10

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 11

Reports that are updated 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 12

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

Question 13

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) OLAP reports

Question 14

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

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

Question 15

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) metadata
B) microdata
C) network packets
D) data structures

Question 16

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 17

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) categorizing
B) calculating
C) grouping
D) filtering

Question 18

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 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) subscriptions
D) dynamic reports

Question 20

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 21

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

Question 22

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

Question 23

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

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

Question 24

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

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

Question 25

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

Question 26

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

Question 27

Query reports allow users to dynamically change report grouping structures.

Question 28

Which of the following statements is true of dimensional databases?

A) They store millions of static 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 29

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

Question 30

Reporting systems cannot generate reports that require calculations on data.

Question 31

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 32

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

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

Question 33

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

Question 34

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

Question 35

Push reports are generated only on receiving a user request.

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

What is the difference between push and pull reports?

Question 42

Describe online analytical processing.

Question 43

Explain report authoring,management,and delivery.

Question 44

Explain the different types of reports.