Snowflake SnowPro-Core Exam Practice Test Instant Access

Question 1

True or False: Fail-safe can be disabled within a Snowflake account.

ATrue

BFalse

Answer : A

Question 2

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

AVia the Snowflake Web Interface (Ul)

BVia the data_share=true parameter

CVia SQL commands

DVia Virtual Warehouses

Answer : A, C

Question 3

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

ATrue

BFalse

Answer : B

Question 4

True or False: A Virtual Warehouse can be resized while suspended.

ATrue

BFalse

Answer : A

Question 5

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium

Warehouse?

B16

C32

D128

Answer : A

Question 6

Which of the following statements are true of Snowflake releases: (Choose two.)

AThey happen approximately weekly

BThey roll up and release approximately monthly, but customers can request early release application

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

DA customer is assigned a 30 minute window (that can be moved anytime within a week) during which the
system will be unavailable and customer is upgraded

Answer : C, D

Question 7

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication

with Snowflake Support to help troubleshoot issues.

ATrue

BFalse

Answer : B

Snowflake SnowPro Core Certification Exam Practice Test

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7