SOL-C01 Exam Questions

A data engineer is trying to create a new internal stage named in Snowflake using the following command: 'CREATE OR REPLACE STAGE FILE FORMAT = (TYPE = CSV COMPRESSION = GZlP)f. Af...

You need to create a database named 'SALES DB' that is only accessible to users with the 'ACCOUNTADMIN' role. After the database is created, you want to grant the 'USAGE' privilege...

You are tasked with creating an external stage pointing to an Azure Blob Storage container. You need to choose the MOST SECURE method for authentication. Which combination of the f...

What does a "green" cell execution status indicate in Snowflake Notebooks?

When querying semi-structured data in Snowflake, which function extracts a specific field from a JSON document?

What MOST accurately describes Snowflake?

What is the PRIMARY purpose for using the PARSE_DOCUMENT function when using a Cortex LLM?

Which two actions are possible within a single Snowflake Notebook session? (Choose two)

How can a directory table be enabled in Snowflake?

What will occur if a virtual warehouse size is increased from Small to Medium?

A data scientist is using Snowflake Notebooks to analyze sales data. They have encountered a situation where a specific cell containing a complex UDF that calculates customer lifet...

A Snowflake Notebook is being used to train a machine learning model. The notebook contains multiple cells: one to load data, one to perform feature engineering, and one to train t...

You're using a Snowflake Notebook to collaboratively develop a data pipeline. Several team members are working on the same notebook concurrently. One team member accidentally delet...

A Snowflake Notebook is configured to run a series of data processing steps on a schedule using the Snowflake Task feature. One of the steps involves calling an external API to enr...

You are developing a Snowflake Notebook to analyze sales data. You want to create a dynamic SQL query that filters data based on a parameter passed from a user interface element (e...

You have a Snowflake Notebook that performs several complex data transformations. The notebook is taking longer than expected to run, and you need to optimize its performance. Whic...

In a Snowflake Notebook, you're attempting to read data from a Snowflake table named 'CUSTOMER DATA into a Pandas DataFrame for further analysis. The table contains a column named...

You are working with a Snowflake Notebook to process data from an external stage (AWS S3). You need to access the S3 stage using a named stage object and a storage integration conf...

You're building a Snowflake Notebook to automate data quality checks on a daily basis. You have a series of SQL queries, each representing a different quality rule (e.g., checking...

Within a Snowflake Notebook, you have a Python script that performs several data transformations using Pandas DataFrames and then attempts to load the transformed data into a new S...

A data engineer is using Snowflake Notebooks to perform a series of transformations on a large dataset. After executing a cell containing a complex SQL query that includes user-def...

You are working with a Snowflake Notebook and need to execute a series of SQL statements that include both DDL (Data Definition Language) and DML (Data Manipulation Language) opera...

You are developing a data pipeline in Snowflake Notebooks. One cell contains Python code that uses the Snowpark DataFrame API to perform several data transformations. After executi...

You are using Snowflake Notebooks to create a visualization based on data retrieved from a Snowflake table. You have the following code in a cell:

In Snowflake Notebooks, you execute a cell containing a SQL query that retrieves data from a view based on multiple underlying tables. The execution status shows 'Success', but the...

A data engineer is building a Snowflake Notebook to perform some data transformations. The notebook interacts with a Snowflake table named 'SALES DATA' which contains columns like...

You are developing a Streamlit application that visualizes data from a Snowflake table called `CUSTOMER ORDERS. The application needs to display the total order amount for each cus...

A data scientist has developed a Streamlit application within a Snowflake Notebook to perform predictive analytics on customer churn. The application uses a pre-trained machine lea...

You are developing a Snowflake Notebook to perform data transformations using Snowpark. As part of the transformation, you need to filter a DataFrame based on a dynamically generat...

What is the purpose of using the SHOW GRANTS ON SQL command for a specific object?

Which two statements describe Snowflake's elasticity features? (Choose two)

Which task is performed in the Cloud Services layer in the Snowflake architecture?