SOL-C01 · Question #109
SOL-C01 Question #109: Real Exam Question with Answer & Explanation
The correct answer is B: Creating a Search Optimization Service on the table, as this can significantly accelerate point. The Search Optimization Service (SOS) is specifically designed to accelerate point lookup and range queries on large tables. SOS automatically creates and manages search access paths based on common query patterns, making it significantly more efficient than a standard index, whi
Question
You are working with a very large table 'TRANSACTIONS' and need to improve the performance of queries that filter data based on a specific range of transaction timestamps. Which of the following is the MOST appropriate Snowflake feature to optimize these queries, and why?
Options
- AUsing a Snowflake Sequence to generate sequential transaction IDs, as this will automatically
- BCreating a Search Optimization Service on the table, as this can significantly accelerate point
- CCreating a standard B-tree index on the transaction timestamp column.
- DRepartitioning the table daily to ensure even data distribution across micro-partitions.
- EConverting the table to a transient table to reduce metadata overhead.
Explanation
The Search Optimization Service (SOS) is specifically designed to accelerate point lookup and range queries on large tables. SOS automatically creates and manages search access paths based on common query patterns, making it significantly more efficient than a standard index, which Snowflake doesn't directly support. Sequences don't inherently improve query performance. Snowflake doesn't support manual repartitioning. Transient tables affect data recovery, not query performance.
Topics
Community Discussion
No community discussion yet for this question.