Skip to Content

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

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.

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.