Snowflake
ADA-C01 · Question #15
ADA-C01 Question #15: Real Exam Question with Answer & Explanation
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.
Community Discussion
No community discussion yet for this question.