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

Questions 6–10

1. 6foundation · easy

   What does the clustering depth metric indicate about a table in Snowflake?

   • AThe number of columns in the clustering key
   • BThe amount of storage used by the table's clustering metadata
   • CThe total number of micro-partitions in the table
   • DThe number of micro-partitions that overlap for a given clustering key value
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   How does Snowflake maintain clustering on a table over time as new data is inserted?

   • AIt requires the user to manually run ALTER TABLE ... RECLUSTER after each load
   • BIt automatically reclusters the table in the background when needed, using compute resources
   • CIt does not maintain clustering; the user must recreate the table periodically
   • DIt sorts new data at insert time and merges it into existing micro-partitions
   Reveal Solution Discussion Select an answer first
4. 8expert · medium

   A media streaming company has a table `viewing_history` with 20 billion rows. The table is clustered on `view_date`. The team frequently runs two types of queries: (1) range scans on `view_date` to analyze viewing trends over a month, and (2) point lookups on `user_id` to retrieve a specific user's viewing history. The `user_id` column has very high cardinality (500 million distinct values). The team wants to optimize both query patterns. The table is large, and the team is concerned about the cost of adding both clustering and Search Optimization. What is the most appropriate strategy?

   • AKeep the clustering key on `view_date` and enable Search Optimization on `user_id`.
   • BAdd a composite clustering key on `view_date` and `user_id` to support both query patterns.
   • CDrop the clustering key and enable Search Optimization on both `view_date` and `user_id`.
   • DEnable Search Optimization on `view_date` and add a clustering key on `user_id`.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   How does Snowflake manage the maintenance of the Search Optimization Service?

   • AIt only updates the search index during query execution
   • BIt runs in the background automatically, using compute resources from the account
   • CIt uses a separate serverless compute pool that is free of charge
   • DIt requires the user to manually run a maintenance job after each data load
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A financial services company has a table `transactions` with 500 million rows. The table is clustered on `transaction_date`. Analysts frequently run point-lookup queries that filter on `transaction_id` (a unique UUID column) to retrieve a single transaction. These lookups are slow because the `transaction_id` column is not part of the clustering key. The company wants to accelerate these specific point lookups without changing the existing clustering strategy. Which approach should they take?

   • AAdd `transaction_id` as a secondary clustering key to the table.
   • BCreate a materialized view on `transaction_id` and query the view instead.
   • CRe-cluster the table manually on `transaction_id` and drop the existing clustering key.
   • DEnable the Search Optimization Service on the `transactions` table.
   Reveal Solution Discussion Select an answer first