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

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

Add to Whishlist

List of questions

Question 151

Report Export Collapse

Users are responsible for data storage costs until what occurs?

Become a Premium Member for full access
  Unlock Premium Member

Question 152

Report Export Collapse

What affects whether the query results cache can be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 153

Report Export Collapse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Become a Premium Member for full access
  Unlock Premium Member

Question 154

Report Export Collapse

How many days is load history for Snowpipe retained?

Become a Premium Member for full access
  Unlock Premium Member

Question 155

Report Export Collapse

How can a row access policy be applied to a table or a view? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 156

Report Export Collapse

Which command can be used to load data files into a Snowflake stage?

Become a Premium Member for full access
  Unlock Premium Member

Question 157

Report Export Collapse

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 158

Report Export Collapse

What is the maximum Time Travel retention period for a temporary Snowflake table?

Become a Premium Member for full access
  Unlock Premium Member

Question 159

Report Export Collapse

When should a multi-cluster warehouse be used in auto-scaling mode?

Become a Premium Member for full access
  Unlock Premium Member

Question 160

Report Export Collapse

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

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).