Which best describes Oracle's OLAP Option for Oracle Database 11g Release 2?

The correct answer is C. Physically stores OLAP cubes as objects within the relational database. Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be…

Advanced Concepts

Question

Options

AIs stored as relational tables and is considered a ROLAP solution
BUses bitmap indexes
CPhysically stores OLAP cubes as objects within the relational database
DIs available both within the Oracle Database and as a stand-alone solution

How the community answered

(34 responses)

A
15% (5)
B
6% (2)
C
76% (26)
D
3% (1)

Explanation

Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views - enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 11g, it allows centralized management of data and business rules in a secure, scalable and enterprise- ready

Topics

#OLAP Option#OLAP cubes#relational database#ROLAP

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice