SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 7

- (Exam Topic 3)
A virtual warehouse is created using the following command:
Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60 auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
SnowPro-Core dumps exhibit
What action should be taken to address this situation?

A. Increase the warehouse size from Medium to 2XL.

B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C. Configure the warehouse to a multi-cluster warehouse.

D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Correct Answer:B

Question 8

- (Exam Topic 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;

Correct Answer:D

Question 9

- (Exam Topic 1)
Which of the following statements are true of Snowflake releases: (Choose two.)

A. They happen approximately weekly

B. They roll up and release approximately monthly, but customers can request early release application

C. During a release, new customer requests/queries/connections transparently move over to the newer version

D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which thesystem will be unavailable and customer is upgraded

Correct Answer:AC
https://docs.snowflake.com/en/user-guide/intro-releases.html

Question 10

- (Exam Topic 1)
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

A. True

B. False

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

Question 11

- (Exam Topic 1)
True or False: Snowflake supports federated authentication in all editions.

A. True

B. False

Correct Answer:A
Reference:
https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions

Question 12

- (Exam Topic 3)
Network policies can be set at which Snowflake levels? (Choose two.)

A. Role

B. Schema

C. User

D. Database

E. Account

F. Tables

Correct Answer:CE
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

START SnowPro-Core EXAM