Question 1

Explain report authoring,management,and delivery.

Accepted Answer

Authoring a report involves connecting to data sources,creating the report structure,and formatting the report.Organizations can author reports by using a developer tool like Microsoft's Visual Studio.The purpose of report management is to define who receives what reports,when,and by what means.Most report management systems allow the report administrator to define user accounts and user groups and to assign particular users to particular groups.The report-delivery function of a reporting system pushes reports or allows them to be pulled according to report-management metadata.Reports can be delivered via an email server,via a Web site,via SOA services,or by other program-specific means.

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A reporting system is an information sys

Question 6

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

Accepted Answer

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

Question 7

Pull report refers to ________.

Accepted Answer

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

What are dimensional databases?

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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?

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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?

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Connecting to data sources is a part of report management.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 25: Reporting Systems and OLAP

Explain report authoring,management,and delivery.

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

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

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

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

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

Pull report refers to ________.

What are dimensional databases?

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

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

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?

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

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 report on current stock prices is an example of a static report.

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

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

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

Connecting to data sources is a part of report management.

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

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

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and the Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Introduction to Microsoft Excel 2010

Database Design

Using Microsoft Access 2010

Using Excel and Access Together

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters