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

The correct answer is D. CREATE ANALYTIC VIEW E. CREATE ATTRIBUTE DIMENSION. https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic- views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

Secure Java EE 7 Applications

Question

Options

ACREATE ANALYTIC MEASURE
BCREATE ANALYTIC LEVEL
CCREATE ANALYTIC HIERARCHY
DCREATE ANALYTIC VIEW
ECREATE ATTRIBUTE DIMENSION

How the community answered

(20 responses)

A
10% (2)
C
5% (1)
D
85% (17)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic- views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

Topics

#analytic views#system privileges#attribute dimension#database security

Community Discussion

No community discussion yet for this question.

Full 1Z0-931 Practice