Snowflake COF-R02 Practice Test - Questions Answers, Page 22
List of questions
Question 211
Which SQL commands, when committed, will consume a stream and advance the stream offset?
(Choose two.)
Question 212
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Question 213
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Question 214
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Question 215
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Question 216
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Question 217
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Question 218
What is the default file size when unloading data from Snowflake using the COPY command?
Question 219
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Question 220
Which Snowflake layer is always leveraged when accessing a query from the result cache?
Question