QUESTION: 77

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)
Via the data_share=true parameter
Via SQL commands
Via Virtual Warehouses

Answer(s): A,C

Reference:

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

Reveal Solution Next Question

QUESTION: 78

True or False: Fail-safe can be disabled within a Snowflake account.

True
False

Answer(s): B

Explanation:

Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

Reference:

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

Reveal Solution Next Question

QUESTION: 79

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

True
False

Answer(s): A

Explanation:

Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

Reveal Solution Next Question

QUESTION: 80

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse
The entire virtual warehouse
The database in which the virtual warehouse resides
The Queries currently being run on the virtual warehouse

Answer(s): B

Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 21)

QUESTION: 77

Reference:

QUESTION: 78

Explanation:

Reference:

QUESTION: 79

Explanation:

QUESTION: 80

Reference:

COF-R02 Discussions & Posts