Question

An analytics team runs a dashboard against a 4 TB events table. The most common query filters on a single high-cardinality column (session_id) using equality predicates, and the workload consists of many small, selective point-lookup queries scattered across the table. Natural load order does not correlate with session_id, so pruning is poor. Which optimization feature is the MOST appropriate to accelerate these selective point-lookup queries?

Accepted Answer

Add the search optimization service to the table for the session_id column

Answer

Define a clustering key on session_id to physically reorder the micro-partitions

Answer

Create a materialized view that pre-aggregates the events by session_id

Answer

Enable the query acceleration service on the warehouse running the dashboard