Free COF-R02 Exam Braindumps (page: 21)

Page 20 of 83

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

  1. Via the Snowflake Web Interface (Ul)
  2. Via the data_share=true parameter
  3. Via SQL commands
  4. Via Virtual Warehouses

Answer(s): A,C


Reference:

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



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

  1. True
  2. 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



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

  1. True
  2. 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.



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

  1. The primary cluster in the virtual warehouse
  2. The entire virtual warehouse
  3. The database in which the virtual warehouse resides
  4. 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.






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

COF-R02 Discussions & Posts