Snowflake SnowPro Associate Platform SOL-C01 - SnowPro Associate Platform SOL-C01 Exam
Page: 3 / 33
Total 162 questions
Question #11 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
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
Answer: B
Question #12 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
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.
Answer: D
Question #13 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
Consider this SQL command:
SELECT
weather:station.element
FROM
weather_data;
What is the name of the column that data is being selected from?
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
Answer: A
Question #14 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
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.
Answer: C
Question #15 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
Which types of worksheets can be created in Snowsight? (Choose two.)
A. Java
B. Javascript
C. Python
D. Scala
E. SQL
Answer: CE
