SnowPro Associate: Platform Question 297
Single answer○ EnableA Snowflake administrator wants to allow a data engineering team to start using Snowpark Python in a development account. The engineers already have user accounts and can run SQL, but when they try to create Python worksheets and execute Snowpark code, they are blocked. The administrator wants to enable this capability using the simplest account-level change that aligns with Snowflake best practices. What should the administrator do?
- A
Enable Anaconda packages for the account so Python worksheets and supported Snowpark Python package dependencies can be used
- B
Grant the ACCOUNTADMIN role to the engineering team so they can create and run Python worksheets
- C
Create a new virtual warehouse that is optimized for Python workloads, because Snowpark Python requires a dedicated warehouse type
- D
Enable Tri-Secret Secure for the account, because Python execution in Snowflake depends on customer-managed encryption keys
Show answer and explanation
Correct answer: A
Explanation
The scenario focuses on the account-level prerequisite needed before users can work with Python worksheets and Snowpark Python in Snowflake. In Snowflake, administrators typically need to enable/accept Anaconda package terms for the account so supported Python packages can be used in Snowflake-hosted Python execution environments. This is a common first-time setup task for Snowpark Python. Best practice is to enable only the required feature and continue using least-privilege role assignments rather than broad admin roles like ACCOUNTADMIN. Relevant Snowflake documentation includes Snowpark for Python guidance and Python worksheet/package management documentation in Snowsight, which describes the dependency on enabled Anaconda packages.
- A. Correct.
Correct. To use Python worksheets and many Snowpark Python package dependencies in Snowflake, the account must have access to Anaconda packages enabled/accepted. This is the account-level prerequisite that commonly blocks teams when they first try to use Python in Snowsight. After that, standard object privileges and a warehouse are still needed, but enabling Anaconda is the key account-level step to allow supported Python packages in Snowflake-managed execution environments.
- B. Incorrect.
Incorrect. ACCOUNTADMIN is a highly privileged administrative role and is not required just to create or run Python worksheets. Granting it would violate least-privilege best practices. The issue described is an account feature enablement/prerequisite problem, not a lack of top-level administrative access.
- C. Incorrect.
Incorrect. Snowpark Python runs using regular Snowflake compute resources; there is no special warehouse type that must be created specifically for Python workloads at the SnowPro Associate level. A warehouse is needed to run code, but creating a special Python-optimized warehouse does not address the enablement issue in the scenario.
- D. Incorrect.
Incorrect. Tri-Secret Secure is an advanced security feature related to encryption key management and is unrelated to enabling Python worksheets or Snowpark Python execution. Someone might choose this if they confuse security enablement with runtime/package enablement, but it does not solve the problem described.