QUESTION: 45

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: 46

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

Explanation:

Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.

Reference:

https://www.snowflake.com/product/architecture/

Show Answer Next Question

QUESTION: 47

Which of the following objects is not covered by Time Travel?

Tables
Schemas
Databases
Stages

Answer(s): D

Reference:

https://docs.snowflake.com/en/user-guide/data-time-travel.html

Show Answer Next Question

QUESTION: 48

When can a Virtual Warehouse start running queries?

12am-5am
Only during administrator defined time slots
When its provisioning is complete
After replication

Answer(s): C

Reference:

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

Show Answer Next Question

Free Snowflake COF-R02 Exam Braindumps (page: 13)

QUESTION: 45

Reference:

QUESTION: 46

Explanation:

Reference:

QUESTION: 47

Reference:

QUESTION: 48

Reference:

COF-R02 Exam Discussions & Posts