Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 194

Total 970 Questions | Updated On: Oct 07, 2022

Add To Cart

Question 1

When would creating and using a standard view be preferable to using a materialized view?

A : The underlying query of the view takes a lot of time to run.

B : The underlying query of the view is resource-intensive.

C : The underlying query of the view is run on large data sets.

D : The view results change often.

Answer: D

Question 2

What feature can be used to reorganize a very large table on one or more columns?

A : Micro-partitions

B : Clustering keys

C : Key partitions

D : Clustered partitions

Answer: B

Question 3

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 4

Which view will show the MOST recent information about table-level storage utilization?

A : The TABLE_STORAGE_METRICS view in a Snowflake data share

B : The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema

C : The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA

D : The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA

Answer: B

Question 5

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

A : A defined level of access to an object

B : An entity in which access can be granted

C : Each object has an owner, who can in turn grail access to that object.

D : Access privileges are assigned to roles. which are in turn assigned to use's

Answer: D

Page: 1 / 194

Total 970 Questions | Updated On: Oct 07, 2022

Add To Cart