Apply Clustering Keys and the Search Optimization Service DEA-C02 Practice Questions (Page 5)

Questions 21–24

1. 21foundation · easy

   When selecting a clustering key, which factor is most important to consider?

   • AThe column's position in the table definition
   • BThe column's default value and nullability
   • CThe column's data type and whether it is numeric or string
   • DThe column's cardinality and how it aligns with common query predicates
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which SQL command is used to enable the Search Optimization Service on a Snowflake table?

   • AALTER TABLE ... ADD SEARCH OPTIMIZATION
   • BOPTIMIZE TABLE ... ENABLE SEARCH
   • CALTER TABLE ... SET SEARCH_OPTIMIZATION = TRUE
   • DCREATE SEARCH INDEX ON TABLE ...
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A data engineer is considering enabling the Search Optimization Service on a table `customers` with 100 million rows. The table is clustered on `signup_date`. The team frequently runs queries that filter on `email` (a high-cardinality string column) to find a specific customer. These point-lookup queries are currently slow. What is the most important consideration before enabling Search Optimization on `email`?

   • ASearch Optimization requires the table to be clustered on the same column.
   • BSearch Optimization will increase storage and compute costs for maintenance.
   • CThe table must be re-clustered on `email` for Search Optimization to work.
   • DSearch Optimization only works on numeric columns, not string columns.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A data engineer enabled the Search Optimization Service on a large table (`events`, 10 billion rows) to speed up point lookups on `event_id`. After a week, the engineer notices that the table's storage costs have increased by 15%, and the automatic maintenance is consuming significant compute credits. The point-lookup queries are now fast, but the team is concerned about the ongoing cost. What is the most appropriate action to manage the cost while retaining the performance benefit?

   • ADisable Search Optimization entirely to eliminate the storage and compute overhead.
   • BKeep Search Optimization enabled but monitor usage and consider whether the lookup frequency justifies the cost; if not, disable it for the table.
   • CSwitch the table to a smaller warehouse to reduce the compute cost of Search Optimization maintenance.
   • DAdd a clustering key on `event_id` to replace the need for Search Optimization.
   Reveal Solution Discussion Select an answer first