Free SnowPro-Core Exam Dumps

Question 106

- (Exam Topic 1)
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A. Customers can change the size of the Warehouse after creation
B. A Warehouse can be resized while running
C. A Warehouse can be configured to suspend after a period of inactivity
D. A Warehouse can be configured to auto-resume when new queries are submitted

Correct Answer:ABCD
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question 107

- (Exam Topic 3)
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
B. The listing is replicated into all selected regions automatically, the data is not.
C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
D. Shares attached to listings in remote regions can be viewed from any account in an organization.
E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Correct Answer:AC

Question 108

- (Exam Topic 2)
Which data type can be used to store geospatial data in Snowflake?

A. Variant
B. Object
C. Geometry
D. Geography

Correct Answer:D
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have SRID=4326.-,Geos

Question 109

- (Exam Topic 2)
Which statement about billing applies to Snowflake credits?

A. Credits are billed per-minute with a 60-minute minimum
B. Credits are used to pay for cloud data storage usage
C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
D. Credits are consumed based on the warehouse size and the time the warehouse is running

Correct Answer:D
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.
https://docs.snowflake.com/en/user-guide/what-are-credits.html

Question 110

- (Exam Topic 3)
When should a multi-cluster warehouse be used in auto-scaling mode?

A. When it is unknown how much compute power is needed
B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C. If the runtime of the executed query is very slow
D. When a large number of concurrent queries are run on the same warehouse

Correct Answer:D