Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 382

Total 1910 Questions | Updated On: Nov 12, 2024

Add To Cart

Question 1

Which of the following are not supported by Search Optimization?

Select three answers.

A : Materialized Views

B : External Tables

C : Date Columns

D : Integer Columns

E : Cast on table columns

Answer: A,B,E

Question 2

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

A : list @mytable;

B : list @%raytable;

C : list @ %m.ystage;

D : list @mystage;

Answer: D

Question 3

Which statements are true regarding Worksheets in Snowsight?

A : Each worksheet acts as a different session.

B : All worksheets share the same session.

C : You can set a different context (role, warehouse, schema, and database) for each worksheet.

D : You can not change the context (role, warehouse, schema, and database) for any worksheet.

Answer: A,C

Question 4

What are the Snowflake product offerings for data sharing that utilize Snowflake Secure Data Sharing to connect Data Providers with multiple consumers?

A : Direct Share

B : Snowflake Data Marketplace

C : Data Exchange

D : Reader Share

Answer: A,B,C

Question 5

What are benefits of using Snowpark with Snowflake? (Select TWO).

A : Snowpark uses a Spark engine to generate optimized SQL query plans.

B : Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C : Snowpark does not require that a separate cluster be running outside of Snowflake.

D : Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E : Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Answer: C,D

Page: 1 / 382

Total 1910 Questions | Updated On: Nov 12, 2024

Add To Cart