Free Snowflake SnowPro-Core Exam Questions

Become Snowflake Certified with updated SnowPro-Core exam questions and correct answers

Page: 1 / 184

Total 917 Questions | Updated On: Jun 26, 2025

Add To Cart

Question 1

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A : An FTP server with TLS encryption

B : An HTTPS server with WebDAV

C : A Google Cloud storage bucket

D : A Windows server file share on Azure

Answer: D

Question 2

Which of the following can be used when unloading data from Snowflake? (Choose two.)

A : When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B : Use the ENCODING file format option to change the encoding from the default UTF-8.

C : The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D : By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E : Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Answer: C,D

Question 3

Which file function gives a user or application access to download unstructured data from a Snowflake stage?

Answer:

Question 4

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A : The user has the appropriate privileges on the objects associated with the query

B : Micro-partitions have been reclustered since the query was last run

C : The new query is run using the same virtual warehouse as the previous query

D : The query includes a User Defined Function (UDF)

E : The query has been run within 24 hours of the previously-run query

Answer: A,E

Question 5

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

A : Reorder the rows in a relational table and then unload the rows into a file

B : Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

C : Reorder the data columns according to a target table definition and then unload the rows into the table.

D : Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Answer: B

Page: 1 / 184

Total 917 Questions | Updated On: Jun 26, 2025

Add To Cart