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

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

Add to Whishlist

List of questions

Question 191

Report Export Collapse

In a Snowflake role hierarchy, what is the top-level role?

Become a Premium Member for full access
  Unlock Premium Member

Question 192

Report Export Collapse

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Become a Premium Member for full access
  Unlock Premium Member

Question 193

Report Export Collapse

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Become a Premium Member for full access
  Unlock Premium Member

Question 194

Report Export Collapse

Where is Snowflake metadata stored?

Become a Premium Member for full access
  Unlock Premium Member

Question 195

Report Export Collapse

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 196

Report Export Collapse

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 197

Report Export Collapse

Which statement MOST accurately describes clustering in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 198

Report Export Collapse

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Become a Premium Member for full access
  Unlock Premium Member

Question 199

Report Export Collapse

How often are the Account and Table master keys automatically rotated by Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 200

Report Export Collapse

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (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).