Question 250
A huge event table receives repeated point-lookups on a highly selective identifier. The proposed response is: Evaluate Snowflake search optimization on the relevant table and predicates. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
Search optimization adds service storage and compute charges and is not ideal for every full-table scan. It qualifies the proposed action: evaluate Snowflake search optimization on the relevant table and predicates.
Incorrect Answers
A fast cached response is useful to users but does not prove the underlying query plan improved. This is a trade-off for the separate proposal: design a controlled performance comparison that distinguishes execution work from cached results. The proposed choice instead requires acknowledging this risk: search optimization adds service storage and compute charges and is not ideal for every full-table scan.
Compute isolation does not isolate account-wide storage, policy or every cloud-services cost. This is a trade-off for the separate proposal: isolate the workloads onto separate virtual warehouses and tune each independently. The proposed choice instead requires acknowledging this risk: search optimization adds service storage and compute charges and is not ideal for every full-table scan.
A historical telemetry view may not reflect the latest second of activity. This is a trade-off for the separate proposal: analyze supported QUERY_HISTORY account usage information and relevant query identifiers. The proposed choice instead requires acknowledging this risk: search optimization adds service storage and compute charges and is not ideal for every full-table scan.





SnowPro Core COF-C03 Practice Tests