Oracle Cloud Infrastructure 2019 Architect Associate — Question 58

Which two system privileges does a user need to create analytic views? (Choose two.)

Answer options

• A. CREATE ANALYTIC MEASURE
• B. CREATE ANALYTIC LEVEL
• C. CREATE ANALYTIC HIERARCHY
• D. CREATE ANALYTIC VIEW
• E. CREATE ATTRIBUTE DIMENSION

Correct answer: D, E

Explanation

To create analytic views, a user must have the CREATE ANALYTIC VIEW and CREATE ATTRIBUTE DIMENSION privileges. The other options, while related to analytics, do not specifically pertain to the creation of analytic views.