SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 38 of 54, with answer review and explanations.

Question 186

What feature can be used to reorganize a very large table on one or more columns?

  1. Micro-partitions
  2. Clustering keys
  3. Key partitions
  4. Clustered partitions

Question 187

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

  1. The explain plan output is available graphically.
  2. An explain plan can be used to conduct performance analysis without executing a query.
  3. An explain plan will handle queries with temporary tables and the query profiler will not.
  4. An explain plan's output will display automatic data skew optimization information.

Question 188

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

  1. VARIANT
  2. VARRAY
  3. STRUCT
  4. ARRAY
  5. QUEUE

Question 189

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  1. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
  2. Allows a user to import the files in a sequential order
  3. Increases the latency staging and accuracy when loading the data
  4. Allows optimization of parallel operations

Question 190

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  1. Database replication and failover
  2. Automated index management
  3. Customer managed keys (Tri-secret secure)
  4. Extended time travel
  5. Native support for geospatial data