Palo Alto Networks

Free COF-C02 Exam Braindumps
SnowPro Core Questions 61–65 (page: 14)

Updated On: 10-Feb-2026

Viewing Page 14 of 221 pages.

Download PDF version with 1300 Questions

QUESTION: 61

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

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

Answer(s): D

Reference:

https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

Show Answer Next Question

QUESTION: 62

Which of the following terms best describes Snowflake's database architecture?

Columnar shared nothing
Shared disk
Multi-cluster, shared data
Cloud-native shared memory

Answer(s): C

Show Answer Next Question

QUESTION: 63

Which of the following are options when creating a Virtual Warehouse? (Choose two.)

Auto-drop
Auto-resize
Auto-resume
Auto-suspend

Answer(s): C,D

Reference:

https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse

Show Answer Next Question

QUESTION: 64

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

The primary cluster in the Virtual Warehouse
The entire Virtual Warehouse
The database the Virtual Warehouse resides in
The queries currently being run by the Virtual Warehouse

Answer(s): B

Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Show Answer Next Question

QUESTION: 65

Fail-safe is unavailable on which table types? (Choose two.)

Temporary
Transient
Provisional
Permanent

Answer(s): A,B

Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

Show Answer Next Question

10
…
12
13
14
15
16
…
20
30

Download PDF Next Page

Viewing page 14 of 221
Viewing questions 66 - 70 out of 1300 questions

Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

Comments:

Name:

AI Tutor

AI Tutor 👋 I’m here to help!