ExamGecko
Home / Snowflake / COF-R02 / List of questions
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 9

Add to Whishlist

List of questions

Question 81

Report Export Collapse

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 82

Report Export Collapse

Which of the following conditions must be met in order to return results from the results cache?

(Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 83

Report Export Collapse

Which of the following are benefits of micro-partitioning? (Select TWO)

Become a Premium Member for full access
  Unlock Premium Member

Question 84

Report Export Collapse

What is the minimum Snowflake edition required to create a materialized view?

Become a Premium Member for full access
  Unlock Premium Member

Question 85

Report Export Collapse

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Become a Premium Member for full access
  Unlock Premium Member

Question 86

Report Export Collapse

Which feature is only available in the Enterprise or higher editions of Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 87

Report Export Collapse

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Become a Premium Member for full access
  Unlock Premium Member

Question 88

Report Export Collapse

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Become a Premium Member for full access
  Unlock Premium Member

Question 89

Report Export Collapse

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 90

Report Export Collapse

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Become a Premium Member for full access
  Unlock Premium Member
Total 330 questions
Go to page: of 33