Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

The correct answer is D. OLAP cubes can be queried by using SQL. All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.

Creating Aggregate Tables

Question

Options

AOLAP cubes eliminate the need for a large number of aggregate tables.
BOLAP cubes are stored outside of the database in highly optimized file structures.
COLAP cubes can be easily transported from database to database.
DOLAP cubes can be queried by using SQL.

How the community answered

(24 responses)

A
8% (2)
B
17% (4)
C
4% (1)
D
71% (17)

Explanation

All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.

Topics

#Oracle OLAP#OLAP cubes#aggregation strategy#SQL querying

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice