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

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

Add to Whishlist

List of questions

Question 221

Report Export Collapse

How many resource monitors can be assigned at the account level?

Become a Premium Member for full access
  Unlock Premium Member

Question 222

Report Export Collapse

How would a user execute a series of SQL statements using a task?

Become a Premium Member for full access
  Unlock Premium Member

Question 223

Report Export Collapse

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Become a Premium Member for full access
  Unlock Premium Member

Question 224

Report Export Collapse

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Become a Premium Member for full access
  Unlock Premium Member

Question 225

Report Export Collapse

What is cached during a query on a virtual warehouse?

Become a Premium Member for full access
  Unlock Premium Member

Question 226

Report Export Collapse

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 227

Report Export Collapse

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called 'CONSUMER'

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Become a Premium Member for full access
  Unlock Premium Member

Question 228

Report Export Collapse

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 229

Report Export Collapse

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Become a Premium Member for full access
  Unlock Premium Member

Question 230

Report Export Collapse

Which formats does Snowflake store unstructured data in? (Choose two.)

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