Snowflake Certified SnowPro Specialty - Snowpark 認定 SPS-C01 試験問題:

1. You have a Snowflake table containing JSON data with nested arrays and objects representing website user interactions. You want to extract all 'product_id' values from within an array named 'viewed _ products' nested inside a 'session' object for each event, using Snowpark for Python. Assume the 'raw_events' table has a variant column called 'event_data". Which of the following Snowpark code snippets will correctly extract and flatten the 'product_id' values into a DataFrame?

A)

B)

C)

D)

E)

2. You are tasked with building a Snowpark application that receives a DataFrame 'new customers_df containing customer data'. Your application needs to insert this data into the 'CUSTOMERS' table in Snowflake. The 'CUSTOMERS table has columns 'CUSTOMER ONT), 'NAME' (VARCHAR), and 'JOIN DATE' (DATE). However, contains all columns as VARCHAR. Which of the following approaches ensures the correct data types are inserted into the 'CUSTOMERS' table, minimizing errors and maximizing performance? Assume the 'session' object is already defined and a valid connection exists.

A) Option E
B) Option A
C) Option C
D) Option D
E) Option B

3. You are developing a Snowpark application that uses a Python UDF to perform geocoding operations. This UDF relies on a third-party geocoding library and a large dataset of geographical data stored in a file named 'geodata.db'. The UDF needs to be operationalized with minimal latency. Which of the following strategies will result in the FASTEST execution of the UDF and optimal resource utilization?

A) Package the geocoding library and 'geodata.db' file into a ZIP file. Upload the ZIP file to a Snowflake stage and reference it using 'imports' in the UDF definition. Use a virtual environment to manage package dependencies.
B) Create a Java UDF that performs the geocoding using a Java geocoding library. Upload the JAR file and 'geodata.db' to a stage and reference them using the 'imports' clause. Java UDFs always perform faster than Python UDFs.
C) Package the geocoding library and 'geodata.db' file into a ZIP file. Upload the ZIP file to a Snowflake stage and reference it using 'imports' in the UDF definition. Ensure 'geodata.db' is loaded only once into memory per worker process using global variable and proper caching for subsequent UDF invocations. Use a virtual environment to manage package dependencies.
D) Use an external function that calls a geocoding service over the internet. Store 'geodata.db' in an S3 bucket and access it from the external function. Call the external service whenever it requires it.
E) Create a custom Anaconda channel containing the geocoding library and 'geodata.db'. Configure the Snowflake account to use this channel. No need to use virtual environment.

4. A data scientist has developed a complex machine learning model in Python that needs to be operationalized within a Snowpark pipeline. This model depends on several custom Python packages not available in Snowflake's default environment. The data scientist wants to define a UDTF to apply this model to incoming data'. Which of the following steps are NECESSARY to successfully deploy and execute this UDTF in Snowflake? (Select three)

A) Upload the ZIP file to a Snowflake stage.
B) Create a virtual environment and install all the required Python packages.
C) Package the virtual environment as a ZIP file.
D) Specify the stage location in the 'imports' clause of the 'CREATE FUNCTION' statement when defining the UDTF.
E) Include only custom packages into the ZIP file and exclude common python library packages, as snowpark is pre-installed.

5. You are developing a secure UDF in Snowpark Python that needs to access sensitive data stored in an internal stage. The UDF should be accessible to users without granting them direct access to the stage. Which of the following security measures and code snippets are required to achieve this, assuming the stage is already created?

A) Create an external function and grant access to the API integration that provides the security context.
B) Create a secure UDF using the ' VOLATILE keyword, allowing it to access secured data with current user's permissions.
C) Create a secure UDF and use the function to access stage credentials within the UDF's handler function.
D) Create a secure UDF and use a stored procedure owned by a role with access to the internal stage to retrieve data, passing the data to the UDF as an argument.
E) Create a UDF and grant USAGE on the stage to the role that owns the UDF.

質問と回答：