DEA-C02 Question #50: Real Exam Question with Answer & Explanation

Question

What are characteristics of Snowpark Python packages? (Choose three.)

Options

• AThird-party packages can be registered as a dependency to the Snowpark session using the
• BPython packages can access any external endpoints.
• CPython packages can only be loaded in a local environment.
• DThird-party supported Python packages are locked down to prevent hitting.
• EThe SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python
• FQuerying information_schema.packages will provide a list of supported Python packages and

Explanation

A is correct because Snowpark allows third-party packages to be registered as session-level dependencies via session.add_packages() (or session.add_requirements()), making them available for UDFs and stored procedures. E is correct because DESCRIBE FUNCTION on a Python UDF reveals metadata including the imported packages declared in its definition. F is correct because information_schema.packages is the official catalog view that lists all Snowflake-supported Python packages along with their available versions.

B is wrong because Snowpark Python code runs inside Snowflake's secure sandbox, which restricts outbound network access to external endpoints by default. C is wrong because packages run server-side within Snowflake's execution environment, not just locally. D is a plausible-sounding distractor but misrepresents the restriction - packages aren't "locked down" in a generic sense; rather, only packages from the Snowflake Anaconda channel are pre-approved for use, which is a security/compatibility policy, not described by option D's wording.

Memory tip: Think "ADD, DESCRIBE, QUERY" - you add packages to the session (A), describe a function to inspect them (E), and query information_schema.packages to discover what's available (F). These are the three operational touchpoints for managing Snowpark Python packages.

No community discussion yet for this question.