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

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

Add to Whishlist

List of questions

Question 191

Report Export Collapse

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Become a Premium Member for full access
  Unlock Premium Member

Question 192

Report Export Collapse

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 193

Report Export Collapse

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Become a Premium Member for full access
  Unlock Premium Member

Question 194

Report Export Collapse

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Become a Premium Member for full access
  Unlock Premium Member

Question 195

Report Export Collapse

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 196

Report Export Collapse

How long is the Fail-safe period for temporary and transient tables?

Become a Premium Member for full access
  Unlock Premium Member

Question 197

Report Export Collapse

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Become a Premium Member for full access
  Unlock Premium Member

Question 198

Report Export Collapse

How does Snowflake Fail-safe protect data in a permanent table?

Become a Premium Member for full access
  Unlock Premium Member

Question 199

Report Export Collapse

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

Snowflake COF-R02 image Question 199 74035 09232024004436000000

What action should be taken to address this situation?

Become a Premium Member for full access
  Unlock Premium Member

Question 200

Report Export Collapse

Which minimum Snowflake edition allows for a dedicated metadata store?

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