SKILL BENCHMARK

Snowflake Performance Monitoring Proficiency (Advanced Level)

  • 16m
  • 16 questions
Explore all Skills Benchmarks
The Snowflake Performance Monitoring Proficiency (Advanced Level) benchmark measures your recognition of Snowflake clustering, search optimization, and Iceberg tables. You will be evaluated on your ability to resume clustering after cloning a clustered table, enable and use Snowflake's search optimization feature, and identify usage scenarios for Iceberg tables and views. A learner who scores high on this benchmark demonstrates that they have expertise in advanced Snowflake and can monitor and optimize Snowflake performance.

Topics covered

  • analyze the Search Optimization feature and contrast it with clustering
  • compare query performance on clustered and unclustered tables
  • compare the performance of queries using search optimization, clustering, and no optimization at all
  • create a Google Cloud Platform (GCP) service integration object and assign GCP roles to the associated service account
  • create and query materialized views
  • create an external table connected to an external stage
  • create an Iceberg table and configure appropriate cloud integrations
  • create secure views and contrast them with ordinary views
  • describe and contrast external tables and Iceberg tables in Snowflake
  • evaluate search optimization with IN, AND, and OR clauses
  • implement search optimizations for individual columns for both equality and substring matches
  • leverage search optimization for working with VARIANT, ARRAY, and OBJECT data
  • resume clustering after cloning a clustered table
  • suspend and resume materialized views
  • turn on search optimization for a table and verify that the search access path is fully constructed
  • work with VARIANT, OBJECT, and ARRAY data loaded into a Snowflake table