Question 1

Which of the following statements is true of dimensional databases?

Accepted Answer

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. 
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. A

Question 2

In the case of online analytical processing,the presentation of a measure with associated dimensions is referred to as an ________.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

Which of the following is a drawback of OLAP reports?

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

Query reports allow users to dynamically change report grouping structures.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

Explain report authoring,management,and delivery.

Accepted Answer

Authoring a report involves connecting t

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 25: Reporting Systems and Olap

Which of the following statements is true of dimensional databases?

In the case of online analytical processing,the presentation of a measure with associated dimensions is referred to as an ________.

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

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

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

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

Which of the following is a drawback of OLAP reports?

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

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

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

Query reports allow users to dynamically change report grouping structures.

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

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

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

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

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

Explain report authoring,management,and delivery.

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

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

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

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations 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

Collaboration Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Hyper-Social Organisations and Knowledge Management

Database Marketing

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters