nerdexam
Oracle

1Z0-515 · Question #28

The Analytic Workspace Manager would be used to generate_______.

The correct answer is B. Oracle OLAP Option cubes. You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option. Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and…

Advanced Concepts

Question

The Analytic Workspace Manager would be used to generate_______.

Options

  • AMaterialized views
  • BOracle OLAP Option cubes
  • COracle Data Mining algorithms
  • DOracle SQL Analytic functions

How the community answered

(52 responses)
  • A
    17% (9)
  • B
    71% (37)
  • C
    4% (2)
  • D
    8% (4)

Explanation

You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option. Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database. Note: Applications and DBA operations often work with more than one version of the data. Three common reasons to have multiple data versions are concurrency, auditing and scenario creation. Oracle Workspace Manager provides workspaces as a virtual environment to isolate a collection of changes to production data, keep a history of changes to data and create multiple data scenarios for "what if" analysis. It can save money, time and labor over traditional

Topics

#Analytic Workspace Manager#Oracle OLAP#OLAP cubes

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice