Snowflake Certification Practice Test

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

Prepare for the Snowflake Certification Exam. Gain expertise with flashcards and multiple-choice questions, with hints and explanations for each. Boost your exam readiness!

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.