SnowPro Specialty: Snowpark Practice Test

• Create and manage Snowpark sessions using multiple authentication methods
• Use SessionBuilder, session methods, session attributes, and AsyncJob

Read and process unstructured data files using SnowflakeFile, UDFs, UDTFs, and stored procedures

• Create Snowpark DataFrames from tables, Python objects, SQL, files, and pandas
• Apply schemas and Snowpark data types to DataFrames

• Create, register, secure, and share Snowpark UDFs and UDTFs
• Specify return/parameter data types via type hints or the registration API
• Compare scalar and vectorized operations

• Create, register, and secure Snowpark stored procedures
• Use caller vs owner rights appropriately
• Orchestrate stored procedures with task DAGs via the Python API

• Filter, sort, limit, and cast data using Snowpark DataFrame operations
• Access rows and columns and extract data from Row objects

Clean and enrich data with joins, missing-value handling, and sampling

Perform aggregate, window, grouping, and set-based operations on DataFrames

Traverse, cast, flatten, and load semi-structured data in Snowpark DataFrames

Persist Snowpark DataFrame results as views, tables, or stage files

Perform delete, update, insert, and merge DML operations using Snowpark DataFrames

Configure and bill Snowpark-optimized virtual warehouses and decide when to scale

Improve Snowpark performance through caching, vectorization, and async execution

Troubleshoot Snowpark using event tables, local testing, pytest, and query history