Snowflake
ADA-C01 · Question #2
ADA-C01 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
Question
The following SQL command was executed: Use role SECURITYADMIN; Grant ownership On future tables In schema PROD. WORKING To role PROD_WORKING_OWNER; Grant role PROD_WORKING_OWNER to role SYSADMIN; Use role ACCOUNTADMIN; Create table PROD.WORKING.XYZ (value number) ; Which role(s) can alter or drop table XYZ?
Options
- ABecause ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop
- BSECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
- CPROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
- DOnly the PROD_WORKING_OWNER role can alter or drop table XYZ.
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.