Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 743

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.)

    Correct Answer: B, D

    To upload a file to an internal Snowflake stage using a PUT command, one can use SnowSQL or the Python connector. SnowSQL is a command-line tool that directly supports the PUT command for uploading files to Snowflake stages. The Python connector, a library that allows connecting to Snowflake from Python, also supports executing SQL commands including the PUT command. The SQL API does not support the PUT command, and the command cannot be executed from Snowsight worksheets. SnowCD is not a recognized tool for this purpose.

Discussion
pvskbrodOptions: BD

https://docs.snowflake.com/en/developer-guide/sql-api/intro#label-sql-api-limitations: The following commands are not supported: The PUT command (in Snowflake SQL) The GET command (in Snowflake SQL) https://docs.snowflake.com/en/sql-reference/sql/put: The command cannot be executed from the Worksheets Worksheet tab page in either Snowflake web interface; instead, use the SnowSQL client or Drivers to upload data files, or check the documentation for a specific Snowflake client to verify support for this command.

JG1984Options: BC

The SQL API is a programmatic interface for connecting to Snowflake. It is the most powerful way to execute SQL commands in Snowflake.(The Python connector is a library that allows you to connect to Snowflake from Python. It can be used to execute SQL commands, but it is not as well-supported as SnowSQL or the SQL API.) Therefore, the two tools that can be used to execute the command are SnowSQL and the SQL API.

MarcusbragaOptions: BD

BD is correct

MultiCloudIronManOptions: BD

Correct