Use Clustering and the Search Optimization Service COF-C03 Practice Questions (Page 5)

Questions 21–24

1. 21foundation · easy

   Which SQL command is used to manually define a clustering key on a Snowflake table?

   • ACREATE CLUSTERING KEY ON TABLE ... (column1, column2)
   • BALTER TABLE ... ADD CLUSTERING KEY (column1, column2)
   • CCREATE INDEX ... ON TABLE ... (column1, column2)
   • DALTER TABLE ... CLUSTER BY (column1, column2)
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the effect of running ALTER TABLE ... ADD SEARCH OPTIMIZATION on a table?

   • AIt immediately improves query performance for all queries on the table
   • BIt creates a search index that Snowflake maintains to speed up point lookups
   • CIt requires the table to have a clustering key defined
   • DIt drops the existing clustering key on the table
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A data engineer is evaluating the clustering health of a large `transactions` table. They run a query to check the clustering depth and find it is high. What does this indicate?

   • AThe table is poorly clustered, and queries may scan more micro-partitions than necessary.
   • BThe table is too large and needs to be partitioned.
   • CThe table has too many micro-partitions.
   • DThe table is well-clustered and queries will be fast.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A company has a large `users` table that is queried with exact-match lookups on `email`. The table is updated frequently. The team wants to enable Search Optimization. Which command should they run?

   • A`ALTER TABLE users ADD SEARCH OPTIMIZATION;`
   • B`ALTER TABLE users ENABLE SEARCH OPTIMIZATION;`
   • C`ALTER TABLE users CLUSTER BY (email);`
   • D`CREATE SEARCH INDEX ON users (email);`
   Reveal Solution Discussion Select an answer first