Free SnowPro Core Exam Braindumps (page: 48)

Page 47 of 287

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

Answer(s): A



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

Answer(s): B



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.

Answer(s): B



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

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

Answer(s): A,D






Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

SnowPro Core Exam Discussions & Posts