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

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

Question list
Search

Question 261

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 262

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 263

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 264

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 265

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 266

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 267

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 268

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 269

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 270

Report
Export
Collapse

Where is Snowflake metadata stored?

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