Snowflake COF-R02 Practice Test - Questions Answers, Page 27
List of questions
Related questions
Question 261

What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Question 262

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

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

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

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

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

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

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?
Question 269

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

Where is Snowflake metadata stored?
Question