The Analytic Workspace Manager would be used to generate_______.
A.
Materialized views
B.
Oracle OLAP Option cubes
C.
Oracle Data Mining algorithms
D.
Oracle SQL Analytic functions
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 approaches.