SnowPro Core Recertification

SnowPro Core Recertification practice questions, page 3 of 3, with answer review and explanations.

Question 11

What type of function returns one value for each invocation?

  1. Aggregate
  2. Scalar
  3. Table
  4. Window

Question 12

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

  1. Micro-partitions
  2. Clustering keys
  3. Equality searches
  4. Search access paths