Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 171

Total 851 Questions | Updated On: Oct 07, 2022

Add To Cart

Question 1

What do temporary and transient tables have m common in Snowflake? (Select TWO).

A : Both tables have no Fail-safe period.

B : Both tables have data retention period maximums of one day.

C : Both tables are visible only to a single user session.

D : For both tables the retention period ends when the tables are dropped.

E : For both tables, the retention period does not end when the session ends

Answer: A,D

Question 2

Which kind of Snowflake table stores file-level metadata for each file in a stage?

A : Directory

B : External

C : Temporary

D : Transient

Answer: A

Question 3

What is the purpose of a Query Profile?

A : To profile how many times a particular query was executed and analyze its u^age statistics over time.

B : To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C : To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D : To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Answer: B

Question 4

Which object allows you to limit the number of credits consumed within a Snowflake account?

Select one.

A : Account usage Tracking

B : Resource Monitor

C : Warehouse Limit Parameter

D : Credit Consumption Tracker

Answer: B

Question 5

Which user object property requires contacting Snowflake Support in order to set a value for it?

A : DISABLED

B : MINS TO BYPASS MFA

C : MINS TO BYPASS NETWORK POLICY

D : MINS TO UNLOCK

Answer: B

Page: 1 / 171

Total 851 Questions | Updated On: Oct 07, 2022

Add To Cart