Snowpro Core · Free Practice Question Medium
Question 18
Which of the following statements is true about Snowflake’s Search Optimization Service?
-
A
It can be applied to only one specific column per table
-
B
It is a serverless feature that incurs additional compute and storage costs
-
C
It requires a running virtual warehouse to function
-
D
It does not support regular expression searches in variant columns
Reveal correct answer
Correct answer: B
A.
The service can be applied to specific columns or to an entire table, depending on the requirements.
B.
The Search Optimization Service is a serverless feature in Snowflake, which incurs additional compute and storage costs as it maintains search access paths for optimized querying.
C.
The service does not require a running virtual warehouse as it operates serverlessly.
D.
The service supports regular expression searches, making it beneficial for queries involving variant columns.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
