Snowflake
ADA-C01 · Question #48
ADA-C01 Question #48: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.
Question
Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1: This statement is executed: USE ROLE ACCOUNTADMIN; DROP ROLE A; What will occur?
Exhibit
Options
- AThe table object DB1. S1. T1 will be dropped.
- BThe OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN
- CThe SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role
- DThe SELECT privileges for roles B and C will remain.
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.