Deck 25: Reporting Systems and OLAP

Question 1

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 tool
D)OLAP cube

Answer 1

D

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

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

Answer 3

True

Question 4

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

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

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 tools is used to create information from disparate data sources and to deliver that information to the proper user on a timely basis?

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

Question 7

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

Question 8

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

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

Question 10

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 11

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

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

Question 12

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 13

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 14

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

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

Question 15

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

Question 16

XML Web service reports are an example of ________ reports.

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

Question 17

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 18

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

A)hoarding
B)mirror display
C)digital dashboard
D)billboard

Question 19

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 20

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 21

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

Question 22

What are the different types of report? Explain.

Question 23

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

Question 24

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

Question 25

Connecting to data sources is a part of report management.

Question 26

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

Question 27

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

Question 28

Explain report authoring,management,and delivery.

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

What is the difference between push and pull reports?

Question 37

Push reports are generated only on receiving a user request.

Question 38

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

Question 39

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 40

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

Question 41

What is an OLAP cube?

Question 42

Describe online analytical processing.