SPS-C01 試験問題を無料オンラインアクセス

You are working with a Snowpark DataFrame 'transactions df that contains customer transaction data'. This data includes a 'transaction amount' column and a 'transaction date' column. You need to create a new feature called 'is weekend transaction' that indicates whether a transaction occurred on a weekend (Saturday or Sunday). Furthermore, some 'transaction_date' values are missing. You want to impute the missing dates with the mode (most frequent date) before determining if the transaction occurred on a weekend. Which of the following steps, when combined, provide the correct and most efficient approach to achieve this?

• A.1. Calculate the mode of the 'transaction_date' column. 2. Filter all rows where 'transaction_date' is null and load that data into a temporary table. 3. Update all rows in original 'transactions_df from temporary table. 4. Create a UDF that takes a date as input and returns True if it's a weekend (Saturday or Sunday), False otherwise. 5. Apply the UDF to the 'transaction_date' column to create the column.
• B.1. Calculate the mode of the 'transaction_date' column. 2. Fill the missing values in the 'transaction_date' column with the calculated mode. 3. Create a UDF that takes a date as input and returns True if it's a weekend (Saturday or Sunday), False otherwise. 4. Apply the UDF to the 'transaction_date' column to create the 'is weekend transaction' column.
• C.1. Calculate the mode of the 'transaction_date' column using Snowpark functions. 2. Fill the missing values in the 'transaction_date' column with the calculated mode using 3. Create a UDF using datetime library that takes a date as input and returns True if it's a weekend (Saturday or Sunday), False otherwise. 4. Apply the UDF to the 'transaction_date' column to create the column.
• D.1. Replace the null values in 'transaction_date' column with a constant string like '1900-01-01'.2. Create a UDF that takes a date as input and returns True if it's a weekend (Saturday or Sunday), False otherwise. 3. Apply the UDF to the 'transaction_dates column to create the column. 4. After applying the UDF convert back the replaced values in transaction_date to null.
• E.1. Calculate the mode of the 'transaction_date' column using Snowpark functions. 2. Fill the missing values in the 'transaction_date' column with the calculated mode using 'fillna()'. 3. Use the 'dayofweek' function to determine the day of the week and create using a 'when' condition.

Consider the following Snowpark Python stored procedure:

What steps are necessary to register this Python code as a stored procedure named 'GET ROW COUNT in Snowflake and allow users with the 'ANALYST' role to execute it, assuming the stored procedure will be created with the 'EXECUTE AS OWNER clause, and the table name parameter will be passed dynamically during invocation?

• A.1. create the stored procedure using 'CREATE OR REPLACE PROCEDURE RETURNS VARCHAR LANGUAGE PYTHON IMPORTS-('/path/to/dependencies.zip') EXECUTE AS OWNER;' 2. Grant 'USAGE-' privilege on the database and schema containing the stored procedure to the 'ANALYST role. 3. Grant ' EXECUTE privilege on the stored procedure to the 'ANALYST role.
• B.1. create the stored procedure using 'CREATE OR REPLACE PROCEDURE RETURNS VARCHAR LANGUAGE PYTHON RUNTIME_VERSlON=3.8 HANDLER='my_sproc' EXECUTE AS OWNER$ 2. Grant 'USAGE privilege on the database and schema containing the stored procedure to the 'ANALYST role. 3. The 'ANALYST' role does not need any additional privilege if EXECUTE AS OWNER is set, as it's using the owner's access rights.
• C.1. Create the stored procedure using 'CREATE OR REPLACE PROCEDURE GET ROW COUNT(VARCHAR) RETURNS VARCHAR LANGUAGE PYTHON EXECUTE AS CALLER;' 2. Grant 'USAGE privilege on the database and schema containing the stored procedure to the 'ANALYST role. 3. Grant 'SELECT' privilege on all possible tables referenced by 'table_name' to the 'ANALYST' role.
• D.1. Create the stored procedure using 'CREATE OR REPLACE PROCEDURE GET ROW COUNT(VARCHAR) RETURNS VARCHAR LANGUAGE PYTHON IMPORTS-('/path/to/dependencies.zip') EXECUTE AS OWNER;' 2. Grant 'USAGE' privilege on the database and schema containing the stored procedure to the 'ANALYST' role. 3. Grant 'EXECUTE PROCEDURE privilege on the 'GET ROW COUNT' stored procedure to the 'ANALYST role.
• E.1. Create the stored procedure using 'CREATE OR REPLACE PROCEDURE GET ROW COUNT(VARCHAR) RETURNS VARCHAR LANGUAGE PYTHON EXECUTE AS OWNER AS $$ import snowflake.snowpark as snowpark def snowpark.Session, table_name: str) str: df = session.table(table_name) count = df.count() return f" Table {table_name} has {count} rows." $$; 2. Grant 'USAGE privilege on the database and schema containing the stored procedure to the 'ANALYST role. 3. Grant 'EXECUTE PROCEDURE privilege on the 'GET ROW COUNT stored procedure to the 'ANALYST role.

You have a Snowpark DataFrame named with the following schema: 'product_id' (INTEGER), (STRING), 'category' (STRING), 'price' (FLOAT), and 'description' (STRING). You want to perform several data cleaning and transformation steps. Which of the following operations can be efficiently chained together using Snowpark DataFrames to clean null values in 'description', replace special characters in 'product_name' and standardize 'category' values? Select all that apply:

• A.Using the function to remove special characters (e.g., '$', '#, '@') from the 'product_name' column using a regular expression.
• B.Manually iterating through each row of the DataFrame and applying Python string manipulation functions to clean the data. (e.g. row['description'] =
• C.Using the 'coalesce' function to fill null values in 'description' with values from a separate 'backup_description' column (if available).
• D.Using a UDF (User-Defined Function) written in Python to standardize the 'category' column by converting all values to lowercase and removing leading/trailing spaces.
• E.Using the method to replace null values in the 'description' column with a default string 'No description available'.

Consider the following Python code snippet using Snowpark:

Which of the following statements are true regarding this Snowpark code?

• A.The code establishes a connection to Snowflake using the provided credentials.
• B.The code reads data from a table named 'my_table' in Snowflake.
• C.The code calculates the sum of the 'sales' column, grouped by 'category' , and saves the result to a new table named , overwriting it if it exists.
• D.The code uses best practices by explicitly closing the Snowflake session, preventing resource leaks.
• E.The code will fail because password authentication is deprecated and replaced by Key Pair authentication.

You are working with image files stored in a Snowflake internal stage named 'image_stage'. You need to write a Snowpark Python application to resize these images using a Python library called 'PIG. The resizing logic is encapsulated in a function called resize_image(snowflake_file: SnowflakeFile, width: int, height: int) -> bytes. Which of the following code snippets correctly registers he 'resize image' function as a UDF and applies it to the image files?

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