Deck 28: Reporting Systems and OLAP

Question 1

Ordinal data is used to describe reports,users,groups,roles,events,and other entities involved in the reporting activity.

Answer 1

False

Question 2

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

A) stable reports
B) static reports
C) underlying reports
D) data reports

Answer 2

B

Question 3

The purpose of ________ is to define who receives what reports,when,and by what means.

A) report management
B) report authoring
C) report finishing
D) report pitching

Answer 3

A

Question 4

Creating the report structure and formatting the report are a part of ________.

A) report management
B) report authoring
C) report pitching
D) report delivery

Question 5

Which of the following tools is used to create meaningful information from disparate data sources and to deliver that information to the proper user on a timely basis?

A) authoritative systems
B) reporting systems
C) monitoring systems
D) intelligence systems

Question 6

Which of the following reports has 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 7

Users can declare that they wish to receive notification of events,say,via email or on their cell phones.These kinds of reports are termed as ________.

A) datums
B) RFM
C) OLAP reports
D) alerts

Question 8

Which of the following is an electronic report media that can be customized for particular users?

A) hoardings
B) mirror display
C) digital dashboards
D) billboards

Question 9

Reporting systems use the ________ as a reference to prepare and deliver reports to the proper users on a timely basis.

A) index
B) directory
C) metadata
D) register

Question 10

Reporting systems cannot generate reports that require calculations on the data.

Question 11

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 12

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 13

In the OLAP reports,the data item that is to be processed is called ________.

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

Question 14

Data generated from public sources is a component of reporting systems.

Question 15

Pull report refers to ________.

A) a report that takes hours for creation
B) a report about the functioning of the system
C) a report generated by user request
D) a report prepared from the underlying data

Question 16

Which of the following is a medium for reporting query reports?

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

Question 17

With reference to the online analytical processing,a presentation of a measure with associated dimensions is known as an ________.

A) OLAP mode
B) OLAP server
C) OLAP report
D) OLAP cube

Question 18

Which of the following reporting system functions will come useful if a user wants to select a portion of the database on the basis of a specific criterion?

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

Question 19

What are dimensional databases?

A) Databases storing detailed data about organizational operations.
B) Databases that are structured to support OLAP processing.
C) Databases consisting of data developed by individual end-users.
D) Databases that are located online and cover millions of systems.

Question 20

XML Web service reports are an example of ________ reports.

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

Question 21

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

Question 22

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

Question 23

What is the difference between push and pull reports?

Question 24

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

Question 25

A reporting system can create dynamic reports only if the most current data is available.

Question 26

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

Question 27

An administrator in a company defines who receives what reports,when,and by what means.These functions performed by the administrator are referred to as report delivery.

Question 28

Each OLAP cube in a report is a characteristic of the measures in the OLAP report.

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

What is a reporting system? What are the operations performed by them?

Question 34

OLAP report generation is slower compared to standard DBMS report generation.

Question 35

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

Question 36

Explain report authoring,management,and delivery.

Question 37

Reporting systems use dedicated indexing systems instead of metadata to prepare and deliver reports to the proper users on a timely basis.

Question 38

What are the different types of reports? Explain.

Question 39

Push reports are generated only on receiving a user request.

Question 40

Connecting to data sources is a part of report management.

Question 41

Describe online analytical processing.

Question 42

What is an OLAP cube?