How accurate are the SnowPro Associate Platform SOL-C01 practice questions?

All SnowPro Associate Platform SOL-C01 questions are community-created and reviewed by moderators to align with Snowflake's published exam objectives. The community continuously reports and fixes issues to keep content accurate and up to date.

How should I study for the SnowPro Associate Platform SOL-C01 exam?

Start by browsing practice questions to identify weak areas. Use spaced repetition (Learn Mode) to focus study time on topics you struggle with. Combine practice questions with official Snowflake documentation and hands-on experience for best results.

SnowPro Associate Platform SOL-C01 Practice Exam — Free 65+ Questions

65Practice Questions

3Study Modes

FreeTo Get Started

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Page 1 of 3 • Questions 1-25 of 65

1 2 3

→

Know a question that should be here? Contribute to this exam

What is the SHOW USERS SQL command used for in Snowflake?

A To list all the users in the system
B To list all the privileges granted to a user
C To list all the roles in a Snowflake account
D To list all the privileges granted to the users in the Snowflake account

Consider this SQL command:

SELECT -
weather:station.element

FROM -
weather_data;
What is the name of the column that data is being selected from?

A weather
B station
C element
D weather_data

What are recommended best practices for loading semi-structured data into a Snowflake table? (Choose two.)

A Use the VARIANT data type.
B Use the VARCHAR data type.
C Flatten the data before loading.
D Use the COPY INTO command.
E Use the PUT command.

Which table privilege is required to create and load data into a new table using Snowsight?

A Insert
B Ownership
C Select
D Usage

What is the PRIMARY purpose for using the TRANSLATE function in the Snowflake Cortex LLM?

A Summarize the given input text in one language to another language.
B Analyze the sentiment of input text and provide the results in the specified language.
C Convert the given input text from one supported language into another language.
D Extract selected words in the input text and convert the words from one supported language to another language.

Which SQL statement can be used to create a table?

A CREATE TABLE table_name (column1 NULL, column2 NULL);
B CREATE TABLE table_name (column1 INT, column2 VARCHAR);
C CREATE TABLE table_name (column1 FORMAT, column2 FORMAT);
D CREATE TABLE table_name (INT column1, VARCHAR column2);

What is the output of the SHOW VIEWS command in Snowflake?

A A list of all views in User-Defined Functions (UDFs)
B A list of the schemas that contain a given view
C A list of the tables that contain a given view
D A list all views in the current database schema

What is the ALTER TABLE SQL command used for in Snowflake?

A Insert a new row into an existing table.
B Delete a standard Snowflake table.
C Synchronize the table metadata.
D Modify the structure of an existing table.

What SQL command can be used to list the contents of a named stage called my_table?

A LIST @my_table;
B LIST @%my_table;
C LIST @~my_table;
D LIST %my_table;

What are the benefits of using the Snowsight data loading interface? (Choose two.)

A It will try to detect data types.
B It lets a user merge file rows into the table records.
C It allows a user to optimize data loading into a table.
D It allows a user to insert the records of a supported file into a table.
E It creates permanent file formats that can be used to load data in the future.

What task can be completed using Time Travel?

A Undrop tables that were previously available through a data share.
B Recover and query data that has been recently deleted or updated.
C Undrop a user who was previously dropped and recover all the user’s data.
D Monitor the queries that were run on a virtual warehouse in the last 90 days.

What is a key feature of Snowflake data storage?

A Data is automatically encrypted.
B Stored data is not compressed.
C Snowflake limits the amount of data that can be stored.
D Storing data does not increase the cost of using Snowflake.

What is a key characteristic of Snowflake Secure Data Sharing?

A Data is physically copied to the data consumer’s account.
B Shared data is read-only and no data is copied.
C Data consumers can modify shared data.
D Data sharing requires exporting data files.

What can be used in Snowflake to create a copy of a table without incurring storage costs?

A A transient table
B A directory table
C Time Travel
D A clone

What is the default Time Travel data retention period?

A 1 day
B 7 days
C 45 days
D 90 days

What is the PRIMARY benefit for data consumers using the Snowflake Marketplace?

A Data consumers can access and export shared data using the public internet.
B Data consumers can update tables shared from another Snowflake account.
C Data consumers can purchase and access data from providers who do not have Snowflake accounts
D Shared data is available to data consumers when data providers make changes to the data.

Where can data consumers search for third-party data and services that can be used in a Snowflake account?

A Admin
B App Packages
C Data
D Marketplace

What is the purpose of Time Travel?

A To allow users to access historical data
B To automatically manage timestamp data types
C To facilitate the loading of historical data into Snowflake
D To ensure that users’ data can be recovered at any time

How does query performance of data shared through the Snowflake Marketplace compare to query performance of data shared through a Data Exchange?

A Queries on data shared in the Snowflake Marketplace are much more performant than queries on data shared in a Data Exchange.
B There is no difference in query performance on data shared in the Snowflake Marketplace compared to query performance on data shared in a Data Exchange.
C Queries on data shared in the Snowflake Marketplace will run slightly slower than queries run on data shared in a Data Exchange.
D Queries on data shared through a Data Exchange will be twice as performant as a queries run on data shared through the Snowflake Marketplace.

What is the SHOW TABLES LIKE 'table_name%'; SQL command used for in Snowflake?

A Identify any tables in a schema that include table_name.
B Identify any tables in a schema that start with the words table_name.
C Identify any tables in a schema that contain data that references a table named table_name.
D Identify any Snowflake objects in a schema that are associated with a table named table_name.

What is the purpose of using the SELECT * SQL statement in Snowflake?

A To select all rows from a table
B To select all columns from a table
C To select all queries in a database
D To select the first 10 columns from a table

Which types of worksheets can be created in Snowsight? (Choose two.)

A Java
B Javascript
C Python
D Scala
E SQL

What does a red cell status in a notebook indicate?

A The cell was modified but has not run yet.
B The cell ran in the current session without errors.
C The cell ran in the current session and an error occurred.
D The cell ran in a previous session and results are from the previous session.

What is the purpose of the Start button in the toolbar of Snowflake Notebooks?

A Executes a SQL statement.
B Initiates the capture of logging and tracing information.
C Begins the top-down cell-by-cell execution of the notebook.
D Initiates a notebook session and sets its label to active when ready.

What is the purpose of the USE SCHEMA command in Snowflake?

A To create a new schema in a database
B To set the current schema for a session
C To take ownership of an existing schema
D To modify the schema structure in a session

SnowPro Associate Platform SOL-C01Preview

About the SnowPro Associate Platform SOL-C01 Exam

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

SnowPro Associate Platform SOL-C01Preview

About the SnowPro Associate Platform SOL-C01 Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25