Snowflake
SOL-C01 · Question #275
A junior data analyst accidentally deleted a critical table using Snowsight. After restoring the table from Time Travel, they want to prevent this from happening again. What is the MOST appropriate pr
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #275. The question stem and answer options stay visible for context.
Snowflake Account and Security
Question
A junior data analyst accidentally deleted a critical table using Snowsight. After restoring the table from Time Travel, they want to prevent this from happening again. What is the MOST appropriate preventative measure they should take using Snowsight, considering they still need access to query other tables?
Options
- ARevoke the DELETE privilege on all tables for the analyst.
- BConfigure multi-factor authentication for the analyst's Snowflake account.
- CRevoke the ACCOUNTADMIN role from the analyst.
- DGrant the analyst the MONITOR privilege on the database.
- ERevoke the DELETE privilege ONLY on the specific critical table.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-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.
Topics
#Privilege Management#Access Control#Data Security#RBAC