ExamGecko
Login
Home / Snowflake / COF-C02 / List of questions
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 19

Add to Whishlist

List of questions

Question 181

Report Export Collapse

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Become a Premium Member for full access
  Unlock Premium Member

Question 182

Report Export Collapse

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 183

Report Export Collapse

Which statement is true about running tasks in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 184

Report Export Collapse

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Become a Premium Member for full access
  Unlock Premium Member

Question 185

Report Export Collapse

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Become a Premium Member for full access
  Unlock Premium Member

Question 186

Report Export Collapse

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 187

Report Export Collapse

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Become a Premium Member for full access
  Unlock Premium Member

Question 188

Report Export Collapse

What are common issues found by using the Query Profile? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 189

Report Export Collapse

What happens to historical data when the retention period for an object ends?

Become a Premium Member for full access
  Unlock Premium Member

Question 190

Report Export Collapse

By default, which Snowflake role is required to create a share?

Become a Premium Member for full access
  Unlock Premium Member
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).