Snowflake
ADA-C01 · Question #15
The following commands were executed: Grant usage on database PROD to role PROD_ANALYST; Grant usage on database PROD to role PROD_SUPERVISOR; Grant ALL PRIVILEGES on schema PROD. WORKING to role…
The correct answer is D. Both user A and user B can create tables in the PROD. WORKING schema. See the full explanation below for the reasoning.
Question
The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST; Grant usage on database PROD to role PROD_SUPERVISOR; Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST; Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR; Grant role PROD ANALYST to user A; Grant role PROD SUPERVISOR to user B; What authority does each user have on the WORKING schema?
Options
- AOnly user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
- BTables created by either user A or user B will be visible to both users.
- CAll existing tables in schema PROD. WORKING will be visible to both users.
- DBoth user A and user B can create tables in the PROD. WORKING schema.
How the community answered
(55 responses)- A11% (6)
- B5% (3)
- C4% (2)
- D80% (44)
Community Discussion
No community discussion yet for this question.