Quiz

Analytic Privilege - Quiz

1. What is the main purpose of Analytic Privilege?
a. Restrict users to access database tables
b. Restrict user to access modeling view
c. Restrict row level access so that user will be able to see only certain portion of the data
d. All of the above

2. What is the system privilege required to create analytic privilege?
a. CREATE STRUCTURED PRIVILEGE
b. CREATE PRIVILEGE
c. STRUCTUREDPRIVILEGE ADMIN
d. PRIVILEGE ADMIN

3. Analytic Privilege can be applied to
a. Attribute views
b. Analytic views
c. Calculation views
d. Table
e. SQL View

4. What is the system privilege required to drop analytic privilege?
a. PRIVILEGE ADMIN
b. CREATE STRUCTURED PRIVILEGE
c. CREATE PRIVILEGE
d. STRUCTUREDPRIVILEGE ADMIN

Answer:
1. c
2. a
3. a,b,c
4. d

Click here to go to next chapter. 3.1 System Generated Schemas in HANA