Instantly download SPS-C01 updated real questions

Snowflake SPS-C01 Exam Overview:

Snowflake SPS-C01 Exam Syllabus Topics:

Snowflake Certified SnowPro Specialty - Snowpark Sample Questions:

1. You are developing a Snowpark application to process customer sentiment from text reviews. You have a Python function, , that utilizes a pre-trained NLP model loaded from a file on a Snowflake stage named This function returns a sentiment score (float) between -1 and 1. You need to register this function as a UDF so that it can be used within Snowpark DataFrames. Which of the following code snippets correctly registers the UDF, ensuring the NLP model is available to the function during execution?

A)

B)

C)

D)

E)

2. When using key pair authentication with Snowpark, what security best practices should you implement to protect your private key?
(Select all that apply)

A) Store the private key in an environment variable or a secure secret management system (e.g., HashiCorp Vault, AWS Secrets Manager, Azure Key Vault).
B) Store the private key directly in the Snowpark code repository.
C) Grant broad access to the environment variable containing the private key to all developers.
D) Encrypt the private key at rest.
E) Regularly rotate the key pair.

3. You have a Snowpark application that utilizes a vectorized Python UDF to perform complex calculations on a large dataset. You notice that the performance is still not optimal. You suspect that the bottleneck might be related to how the data is being partitioned and processed by Snowflake. Which of the following actions, when performed in conjunction with vectorization, would MOST likely improve performance?

A) Convert the DataFrame to a Pandas DataFrame before applying the UDF.
B) Repartition the Snowpark DataFrame using to align the data distribution with the computational needs of the UDF.
C) Increase the number of UDF worker threads within the UDF definition.
D) Ensure that the data is pre-sorted according to the primary key of the table before applying the UDF.
E) Broadcast the DataFrame to all compute nodes before applying the UDF.

4. Consider the following Snowflake SQL statement intended to modify the properties of a Snowpark-optimized virtual warehouse named
'SNOWPARK_WH':

Which of the following statements accurately describe the expected outcome of executing this SQL statement?

A) The SQL statement will fail because the 'SCALING POLICY parameter cannot be set for Snowpark-optimized warehouses.
B) The SQL statement will execute successfully, resizing the 'SNOWPARK WI-i' warehouse to 'LARGE', setting the maximum number of clusters to 3, the minimum to 1, and enabling the 'ECONOMY' scaling policy.
C) The SQL statement will execute successfully after checking if 'SNOWPARK_WH' is of Snowpark-optimized warehouse type, resizing the 'SNOWPARK_WH' warehouse to 'LARGE', setting the maximum number of clusters to 3, the minimum to 1, and enabling the 'ECONOMY' scaling policy.
D) The SQL statement will fail because you cannot modify 'WAREHOUSE_SIZE and 'MAX CLUSTER COUNT in a single SALTER WAREHOUSE statement.
E) The SQL statement will execute successfully only if the user executing it has the 'MODIFY privilege on the 'SNOWPARK_WH' warehouse.

5. You have created a Snowpark UDF that uses a custom Python module 'my_module.py', containing a function 'process data'. This module is not available through Anaconda'. You've packaged the module into a zip file named 'my module.zip'. What steps are necessary to deploy this UDF in Snowflake so that it can correctly use the 'my_module'?

A) Upload 'my_module.zip' to an internal stage. When creating the UDF, specify the stage path in the 'imports' argument. Within the UDF, modify 'sys.path' to include the path where Snowflake unpacks the zip file.
B) Upload 'my_module.zip' to an internal stage. When creating the UDF, specify the stage path in the 'packages' argument. Within the UDF, modify 'sys.path' to include the path where Snowflake unpacks the zip file.
C) Upload 'my_module.zip' to an external stage (e.g., AWS S3 or Azure Blob Storage). Configure Snowflake to access the external stage. Create the UDF, specifying the external stage path in the 'imports' argument.
D) Upload 'my_module.zip' to an internal stage. When creating the UDF, specify the stage path in the 'imports' argument. No changes to sys.path are required within the UDF.
E) Upload 'my_module.zip' to an internal stage, then create the UDF using 'session.add_import' within the UDF definition, specifying the stage path. No additional configuration is needed.

Solutions: