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

True or False: Snowpipe via REST API can only reference External Stages as source.

    Correct Answer: B

    The statement is false. Snowpipe via REST API can reference both internal and external stages as sources. Internal stages are Snowflake-managed locations within the user's account, while external stages refer to storage locations such as Amazon S3, Google Cloud Storage, or Microsoft Azure. Therefore, it is not restricted to only referencing external stages.

Discussion
TapsinhaOption: B

Statement is False. Answer B is correct. Snowpipe via rest API can refer both external as well as internal stages. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-overview.html

StrStudyOption: B

answer is false

learnazureportalOption: B

The correct answer is B.

[Removed]Option: A

Went to https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-overview.html . The process flow chart clearly shows internal and external sources being used. The answer is A

Mallikharjuna452Option: B

B.False

deeshubhOption: A

This statement is true because Snowflake, as a cloud-based data warehouse, requires a specific driver to establish a connection. While third-party tools that support standard JDBC (Java Database Connectivity) or ODBC (Open Database Connectivity) protocols theoretically could connect to Snowflake, without a Snowflake-specific driver, they would not be able to establish a connection successfully. Snowflake's architecture and features require a driver that is specifically designed to work with its unique system. Therefore, a third-party tool lacking a Snowflake-specific driver would indeed be unable to connect to Snowflake.

_yyuktaOption: B

B is correct

lischrisOption: B

False: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-gs#step-4-stage-data-files Snowpipe supports loading from the following stage types: Named internal (Snowflake) or external (Amazon S3, Google Cloud Storage, or Microsoft Azure) stages Table stages

snehav112Option: B

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-load B) Stage your data files: Internal stage: Use the PUT command to stage your files. External stage: Use the client tools provided by the cloud provider to copy your files to the stage location (Amazon S3, Google Cloud Storage, or Microsoft Azure).

Mayuri917233Option: B

B is correct

sidyndiayeOption: B

Answer will be false

Tapasgup007Option: B

B is correct

[Removed]Option: B

Correction. The answer is B.

San2Option: B

REST API supports both internal and external but SNOWPIPE AUTO INGEST only support external. so the answer is B

mayur1234Option: B

Answer is B. Snowpipe via rest API can refer both external as well as internal stages. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-overview.html

arpit_dataguyOption: A

The statement is TRUE.