Free Access Snowflake.SPS-C01.v2026-07-23.q130 Practice Test (Page 12)

Question 51

You have a complex data pipeline implemented using Snowpark Tasks in a Directed Acyclic Graph (DAG). One of the tasks, , depends on the successful completion of two parent tasks, and 'task B'. You need to implement error handling such that if 'task_R fails, 'task_C' should not be executed, but should still complete its execution regardless of status. If 'task B' fails, 'task_C' should not be executed. How do you configure the task dependencies and error handling in Snowflake to achieve this behavior?

Question 52

You have a Snowpark DataFrame named with the following schema: '(timestamp: TmestampType, sensor_id: StringType, value: FloatType)'. You need to identify the top 3 sensors with the highest average value over the entire dataset. Which of the following Snowpark Python code snippets correctly implements this requirement?

Question 53

You have a Python function, 'calculate metrics(df: snowpark.DataFrame, metric name: str) -> snowpark.DataFrame', that calculates various metrics on a Snowpark DataFrame. You want to deploy this function as a stored procedure in Snowflake. You need to ensure that the stored procedure has appropriate permissions to read data from a table named 'customer data' and write results to a table named 'metrics_table'. Which of the following steps are necessary to achieve this, assuming you are using the 'session.sproc.register' method?

A.Grant the 'USAGE privilege on the database and schema containing the 'customer_data' and 'metrics_table' tables to the role executing the stored procedure.

B.Grant the 'SELECT privilege on the 'customer_data' table and the 'INSERT privilege on the 'metrics_table' table to the role executing the stored procedure.

C.When registering the stored procedure using 'session.sproc.register' , specify the argument and provide a 'replace=True' if necessary. This will allow you to assign ownership of the stored procedure to a role with the necessary privileges.

D.Specify the 'packages' argument in 'session.sproc.register' to include any Python dependencies required by the 'calculate_metrics' function.

E.Specify the 'imports' argument in 'session.sproc.register' with the list of packages which are needed to run 'calculate_metrics' function.

Question 54

You are developing a Snowpark application that involves creating a set of stored procedures and UDFs to process data'. To ensure proper version control and dependency management, you decide to package your Python code into a single Python Wheel file and deploy it to Snowflake. Which of the following methods are valid for deploying and utilizing this Python Wheel file within Snowflake, considering best practices for maintainability and security? (Select TWO)

A.Upload the Python Wheel file to an internal stage and directly reference it in the UDF or stored procedure definition using the 'USING' clause.

B.Upload the Python Wheel file to an external stage (e.g., AWS S3) and configure Snowflake to access the external stage, then reference the wheel file path in the USING' clause of the UDF or stored procedure.

C.Use the Snowsight UI to upload the Python Wheel file as a dependency for the Snowflake environment, making it available for all stored procedures and UDFs within that environment.

D.Create a Conda environment file (environment.yml) that specifies the Python Wheel file as a dependency and use this file to create a Snowflake environment. Then, associate the stored procedures and UDFs with that environment.

E.Use the 'snowflake-cli' to push the Python Wheel file as a package, then add the package name to the list of packages when creating the stored procedure or UDF.

Question 55

You are tasked with creating a Snowpark DataFrame from a Python list of tuples. Each tuple represents a customer record with the following structure: '(customer_id, signup_date, The 'customer _ id' should be an integer, 'signup_date' should be a date, and should be a decimal. You want to define the schema explicitly for type safety and performance. Which of the following code snippets correctly defines the schema and creates the Snowpark DataFrame?