A data engineer is developing a Snowpark application using Python and needs to connect to Snowflake. They want to avoid hardcoding credentials directly in the script and utilize environment variables for authentication. Which of the following approaches is the MOST secure and RECOMMENDED way to retrieve Snowflake connection parameters (account, user, password, database, schema, warehouse, role) from environment variables and establish a Snowpark session?

• A. Manually retrieve each parameter using 'os.environ.get()' and pass them directly into the 'Session.builder.configs()' method.
• B. Store all connection parameters as a JSON string in a single environment variable and parse it within the Snowpark application.
• C. Leverage the 'snowflake.connector.connect()' function with 'os.environ.get()' for credentials and then create a Snowpark session from the connection using Session. builder. from_connection(connectiony.
• D. Use the SnowCLl to configure a connection profile, and then reference this profile name when creating the Snowpark session. Ensure each environment variable is also separately available, but are not explicitly called in the code to establish connection but only to set up SnowCLl.
• E. Utilize the 'Session.builder.getorcreate()' method, assuming that Snowflake connection information (user, password, account, warehouse, etc.) are already set as environment variables with standard names, and let Snowpark automatically infer the parameters.

You are tasked with optimizing a Snowpark application that uses a Python UDF to perform complex string manipulations on a large dataset. The current implementation uses a scalar UDF. You are considering converting it to a vectorized UDF. What are the key considerations and potential limitations you need to address during the conversion to ensure correctness and optimal performance? Choose all that apply:

• A. The vectorized UDF should utilize libraries like NumPy or Pandas for efficient array processing, but it's important to be aware of the limitations on available Python packages in the Snowflake environment.
• B. Vectorized UDFs always perform better than scalar UDFs, regardless of the complexity of the string manipulations or the size of the dataset.
• C. The input and output data types of the vectorized UDF must exactly match the corresponding column data types in the Snowpark DataFrame.
• D. The vectorized UDF must be able to handle NULL values gracefully within the input arrays, as these can cause errors if not explicitly addressed.
• E. The vectorized UDF's return type must be compatible with Snowpark's data types, and the UDF should return an array of the appropriate type with the same length as the input arrays.

A data engineering team has created several Snowpark Python UDFs and UDTFs in the 'TRANSFORMATIONS' schema of the 'ANALYTICS' database. A data science team needs to use these functions in their data analysis notebooks. What is the MINIMUM set of privileges that must be granted to the data science team's role ('DATA SCIENTIST') to allow them to discover and execute these UDFs and UDTFs?

• A. GRANT ALL PRIVILEGES ON DATABASE ANALYTICS TO ROLE DATA SCIENTIST; GRANT ALL PRIVILEGES ON SCHEMA ANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST;
• B. GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST;
• C. GRANT USAGE ON DATABASE ANALYTICS TO ROLE DATA SCIENTIST; GRANT USAGE ON SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST; GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST;
• D. GRANT USAGE ON DATABASE ANALYTICS TO ROLE DATA SCIENTIST; GRANT USAGE ON SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST;
• E. GRANT USAGE ON DATABASE ANALYTICS TO ROLE DATA SCIENTIST; GRANT USAGE ON SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST; GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMAANALYTICS.TRANSFORMATIONS TO ROLE DATA SCIENTIST,

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?

• A.
  
• B.
  
• C.
  
• D.
  
• E.
  

You are developing a Snowpark application that processes large datasets stored in Snowflake. You need to implement custom User-Defined Functions (UDFs) written in Java. The UDF requires specific third-party libraries that are not available in the default Snowflake Java environment. What steps are necessary to package and deploy these UDFs correctly?

• A. Create a separate Python UDF that imports the Java code using Jpype and then register the Python UDF with Snowflake
• B. Package the Java code and dependencies into a JAR file and upload it to a Snowflake stage. Use the 'CREATE FUNCTION' command with the 'IMPORTS' clause to reference the JAR file.
• C. Utilize the Snowpark API to create a 'snowpark.functions.udf object, including the Java code and dependencies. The Snowpark runtime will handle the deployment.
• D. Compile the Java code into a native library (e.g., a .so file), upload it to a Snowflake stage, and use the 'CREATE EXTERNAL FUNCTIONS command to invoke it.
• E. Use the 'CREATE OR REPLACE JAVA FUNCTION' command directly in Snowsight and paste the Java code along with the dependencies' contents into the function body.