nerdexam
Snowflake

SOL-C01 · Question #287

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

The correct answer is A. Load data into tables B. Execute multiple SQL queries. Snowflake Notebooks support both SQL and Python cells within the same session, making it possible to load data into tables (e.g., using INSERT, COPY INTO, or Python DataFrame writes) and execute multiple SQL queries across different cells. Notebooks are an analytical and developm

Querying and Performance

Question

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

Options

  • ALoad data into tables
  • BExecute multiple SQL queries
  • CManage user roles
  • DCreate database backups

How the community answered

(18 responses)
  • A
    94% (17)
  • D
    6% (1)

Explanation

Snowflake Notebooks support both SQL and Python cells within the same session, making it possible to load data into tables (e.g., using INSERT, COPY INTO, or Python DataFrame writes) and execute multiple SQL queries across different cells. Notebooks are an analytical and development environment, not an administration console - managing user roles (C) requires dedicated GRANT/REVOKE commands run with appropriate privileges outside the notebook workflow, and creating database backups (D) is not a supported notebook operation; Snowflake handles point-in-time recovery automatically through Time Travel and Fail-safe.

Topics

#Snowflake Notebooks#SQL Execution#Data Loading#Data Querying

Community Discussion

No community discussion yet for this question.

Full SOL-C01 Practice