Snowflake Certification Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Improve your knowledge and prepare effectively for the Snowflake Certification Test with our comprehensive practice quiz. Study with detailed flashcards and multiple choice questions. Get ready to ace your exam!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

Is it recommended to use the ACCOUNTADMIN role for automated scripts?

Yes, always use it
No, it's not recommended
Only for administrative tasks
Only if required by the script

The correct answer is: No, it's not recommended

Using the ACCOUNTADMIN role for automated scripts is not recommended due to the potential security risks and the principle of least privilege. The ACCOUNTADMIN role has comprehensive access rights across the Snowflake environment, which can pose a significant risk if the automated script is compromised or if there's an unintended consequence from running scripts with such high-level privileges. By using a role with more limited access tailored to the specific tasks the script needs to perform, you minimize the exposure and potential impact of errors or security breaches. Additionally, adopting roles with restricted access helps organizations maintain better governance and auditing practices. This ensures that users and scripts operate under the principle of least privilege, effectively reducing the attack surface and increasing overall security posture.