Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
A.
OLAP cubes eliminate the need for a large number of aggregate tables.
B.
OLAP cubes are stored outside of the database in highly optimized file structures.
C.
OLAP cubes can be easily transported from database to database.
D.
OLAP cubes can be queried by using SQL.
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.Reference: Oracle OLAP User’s Guide, What’s New in Oracle OLAP?
It should be A
I guess it should be A
The official answer seems reasonable.
You are not asked about the cubes in general – “A” is the obvious answer.
But in relation to OBIEE, the point is in access to OLAP Cubes.
This is where “D” is true:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/olap/biee/createbieemetadata.htm
“To access OLAP cubes and leverage the OLAP calculation engine, a SQL tool — such as OBIEE — uses the built-in SQL interface to OLAP. Oracle OLAP cube data is made directly accessible to SQL by a set of relational views. These views represent an OLAP cube as a star schema”
Thanks Angor, good explanation
“Calculated measures are simply selected as columns. The data is computed in the OLAP calculation engine and passed through the cube view.”
perform sql query on those views to retrieve the calculated measures on varied dimension member level(generation).