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

Questions 11–15

1. 11foundation · easy

   Which statement best describes how automatic clustering operates?

   • AIt runs only when a user manually executes a clustering command
   • BIt only runs during off-peak hours to avoid impacting performance
   • CIt is a background service that continuously monitors and reclusters tables as needed
   • DIt requires the user to schedule clustering jobs using Snowflake tasks
   Reveal Solution Discussion Select an answer first
2. 12expert · hard

   A data architect is designing a clustering strategy for a large `fact_events` table. The table has columns `event_type`, `event_date`, `user_id`, and `session_id`. Queries frequently filter on `event_type` and `event_date`, but `event_type` has only 5 distinct values. Which clustering key should they choose?

   • A`CLUSTER BY (session_id)`
   • B`CLUSTER BY (user_id)`
   • C`CLUSTER BY (event_date, event_type)`
   • D`CLUSTER BY (event_type, event_date)`
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   How does Snowflake maintain the search index for a table with Search Optimization enabled?

   • AIt rebuilds the index only when the table is reclustered
   • BIt requires the user to manually rebuild the index after DML operations
   • CIt disables the index during high-load periods to save costs
   • DIt automatically updates the index as data is inserted, updated, or deleted
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A retail analytics team runs frequent point lookups on a large orders table using queries like `SELECT * FROM orders WHERE order_id = ?`. The table is also regularly filtered by `order_date` for daily reporting. Which optimization should the team apply to best serve both query patterns?

   • AEnable Search Optimization on the orders table.
   • BEnable Search Optimization and set a clustering key on order_date.
   • CSet a clustering key on order_id.
   • DSet a clustering key on order_date.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   When is it more appropriate to use Search Optimization instead of clustering on a Snowflake table?

   • AWhen the table has no clustering key and you want to improve overall query performance
   • BWhen queries frequently perform large range scans on a date column
   • CWhen the table is very large and frequently updated
   • DWhen queries frequently filter on a highly selective column with point lookups
   Reveal Solution Discussion Select an answer first