QUESTION: 57

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

True
False

Answer(s): A

Explanation:

Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

Reveal Solution Next Question

QUESTION: 58

Which of the following statements is true of Snowflake?

It was built specifically for the cloud
It was built as an on-premises solution and then ported to the cloud
It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
It was built for Hadoop architecture
It's based on an Oracle Architecture

Answer(s): A

Reference:

https://www.stitchdata.com/resources/snowflake/

Reveal Solution Next Question

QUESTION: 59

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Standard
Premier
Enterprise
Business Critical Edition

Answer(s): C

Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html

Reveal Solution Next Question

QUESTION: 60

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases
A Database may contain one or more Schemas
A Schema is a logical grouping of Database Objects
Each Schema is contained within a Warehouse

Answer(s): B,C

Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 16)

QUESTION: 57

Explanation:

QUESTION: 58

Reference:

QUESTION: 59

Reference:

QUESTION: 60

Reference:

COF-R02 Discussions & Posts