Skip to Content

Snowflake SnowPro Core: Which tools connectors could be used to upload file to internal Snowflake stage

By: Author Alex Lim

Posted on

Categories Exam

Question

A user wants to upload a file to an internal Snowflake stage using a PUT command. Which tools and/or connectors could be used to execute this command? (Choose two.)

A. SnowCD
B. SnowSQL
C. SQL API
D. Python connector
E. Snowsight worksheets

Answer

B. SnowSQL
D. Python connector

Explanation

The correct answers are B and D.

B. SnowSQL. This is true because SnowSQL is a command-line client that can be used to connect to Snowflake and execute SQL statements, including the PUT command. SnowSQL supports uploading files to an internal Snowflake stage using the PUT command with the following syntax:

PUT file://<local_file> @<stage_name>

D. Python connector. This is true because the Python connector is a library that can be used to connect to Snowflake and execute SQL statements from Python applications, including the PUT command. The Python connector supports uploading files to an internal Snowflake stage using the PUT command with the following syntax:

cursor.execute("PUT file://<local_file> @<stage_name>")

The other options are incorrect because:

  • A. SnowCD. This is false because SnowCD is a command-line tool that can be used to collect diagnostic information from a local machine and upload it to Snowflake for troubleshooting purposes. SnowCD does not support executing SQL statements or uploading files to an internal Snowflake stage using the PUT command.
  • C. SQL API. This is false because the SQL API is a REST-based API that can be used to connect to Snowflake and execute SQL statements from any programming language that supports HTTP requests, but not the PUT command. The SQL API does not support uploading files to an internal Snowflake stage using the PUT command, as it only accepts JSON payloads in the request body.
  • E. Snowsight worksheets. This is false because Snowsight worksheets are web-based interfaces that can be used to connect to Snowflake and execute SQL statements, but not the PUT command. Snowsight worksheets do not support uploading files to an internal Snowflake stage using the PUT command, as they only allow browsing and selecting files from an existing stage or local machine.

Reference

Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.