Free SnowPro-Core Exam Dumps

Question 61

- (Exam Topic 1)
True or False: A single database can exist in more than one Snowflake account.

A. True
B. False

Correct Answer:B
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Question 62

- (Exam Topic 3)
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
* 1. Runs a query that takes 3 minutes to complete
* 2. Leaves for 15 minutes
* 3. Returns and runs a query that takes 10 seconds to complete
* 4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?

A. 4 minutes
B. 10 minutes
C. 14 minutes
D. 24 minutes

Correct Answer:C

Question 63

- (Exam Topic 3)
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the target table for 14 days
B. In the metadata of the pipe for 14 days
C. In the metadata of the target table for 64 days
D. In the metadata of the pipe for 64 days

Correct Answer:A

Question 64

- (Exam Topic 1)
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A. Configure the Maximum Clusters setting to “Auto-Scale”
B. Set the Warehouse type to “Auto”
C. Set the Minimum Clusters and Maximum Clusters settings to the same value
D. Set the Minimum Clusters and Maximum Clusters settings to the different values

Correct Answer:D
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

Question 65

- (Exam Topic 1)
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

A. True
B. False

Correct Answer:B
Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/