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: Feb 19, 2025

Add To Cart

Question 1

Which of the following is true regarding the default role in Snowflake?

Select all that apply

A : A user can not use any other role other than their default role.

B : When a user switches to another role in a session, their user's default role automatically reconfigures to the new role.

C : When users log in, their role is automatically set to their default role.

D : A user can switch their current role if required.

Answer: C,D

Question 2

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

A : Load the data into a CSV file.

B : Load the data into a relational table.

C : Use the VALlDATlON_MODE - SQL statement.

D : Use the validation mode = return rows statement.

Answer: C

Question 3

Which of following File Functions are not provided to access unstructured data files?

A : GET_ABSOLUTE_PATH

B : BUILD_SCOPED_FILE_URL

C : BUILD_PRESIGNED_URL

D : BUILD_STAGE_FILE_URL

Answer: C

Question 4

True or False: A consumer account has created a read-only database on a shared database. The consumer account can further share this database & its tables with other accounts.

A : False

B : True

Answer: A

Question 5

Which Snowflake technique can be used to improve the performance of a query?

A : Clustering

B : Indexing

C : Fragmenting

D : Using INDEX__HINTS

Answer: A

Page: 1 / 382

Total 1910 Questions | Updated On: Feb 19, 2025

Add To Cart