Study with SPS-C01 Actual Test Questions

Snowflake SPS-C01 Exam Overview:

Snowflake SPS-C01 Exam Syllabus Topics:

Snowflake Certified SnowPro Specialty - Snowpark Sample Questions:

1. 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 D
C) Option B
D) Option A
E) Option C

2. You are tasked with automating the creation of Snowpark sessions using key pair authentication for multiple users. You have a function that retrieves connection parameters (account, user, private key, etc.) for each user from a secure configuration file. The private keys are stored in PEM format. However, some users' private keys are password-protected. Which of the following approaches ensures the secure and correct establishment of Snowpark sessions for all users, including those with password-protected private keys? Assume get_user config(username)' retrieves the user's configuration, including the private key and password (if any).

A)

B) Require all users to remove the password protection from their private keys to simplify the session creation process.
C)

D) Attempt to establish a session without a password. If it fails, prompt the user for the password and retry the session creation using the provided password. Store the password temporarily in memory.
E) Store the password for each user's private key in a separate, encrypted file and retrieve it during session creation.

3. You are developing a Snowpark Python application that reads data from an external stage (AWS S3) and performs several transformations before loading it into a Snowflake table. During testing, you encounter the following error: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: User does not have OWNERSHIP privilege on integration object 'YOUR INTEGRATION NAME". You have confirmed that the user has the 'USAGE privilege on the integration. Besides granting ownership, which of the following actions could resolve this issue in the MOST secure and efficient way?

A) Modify the integration to include a service principal that the Snowpark application will use to authenticate, eliminating the need for user-level privileges.
B) Create a custom role with the 'USAGE privilege on the integration and the 'CREATE TABLE' privilege on the database. Grant this role to the user.
C) Grant the 'CREATE TABLE privilege to the user on the database where the target table resides.
D) Use the 'COPY INTO' command with the 'ON_ERROR = CONTINUE option to bypass the permission error.
E) Grant the ' READ privilege on the external stage to the user.

4. Which of the following statements are correct regarding account identifiers and their usage when creating Snowpark sessions in Python?

A) The account identifier can be specified using either the 'Organization Name-Account Name' format or the legacy account locator, depending on the Snowflake account configuration and the region.
B) Account identifiers are case-sensitive and must be entered exactly as provided by Snowflake.
C) If the account identifier includes the region ID, you do not need to specify the region separately in the connection parameters.
D) Account identifiers can only be used when connecting to Snowflake accounts in the same AWS region.
E) Using the 'Organization Name-Account Name' format for the account identifier is only valid for accounts that have been recently created.

5. You are developing a Snowpark application using Visual Studio Code and the Snowflake VS Code extension. You want to configure the extension to automatically detect and use a specific Anaconda environment for your Snowpark development. Assuming you have already created an Anaconda environment named 'snowpark_env', which configuration setting in the VS Code settings.json file would correctly specify the Python path for the Snowflake extension?

A) "python.pythonPath": "Ipath/to/anaconda3/envs/snowpark_env/bin/python"
B) "snowflake.snowpark.pythonPath": "Ipath/to/anaconda3/envs/snowpark_env/bin/python"
C) "snowflake.python.defaultlnterpreterPath": "Ipath/to/anaconda3/envs/snowpark_env/bin/python"
D) "snowsql.pythonPath": "/path/to/anaconda3/envs/snowpark_env/bin/python"
E) "python.defaultlnterpreterPath": "Ipath/to/anaconda3/envs/snowpark_env/bin/python"

Solutions: