Snowflake COF-R02 Practice Test - Questions Answers, Page 27
List of 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