Question 500
A huge event table receives repeated point-lookups on a highly selective identifier. After implementing the approach, which observation best demonstrates the required outcome?
Explanation
Correct Answer
Representative lookup queries show lower scans or latency after the optimization is ready. This demonstrates the outcome for the stated requirement rather than just a saved configuration.
Incorrect Answers
Subsequent scans benefit from data already in the warehouse's cache. That measures a different outcome: a table-scan query runs faster a second time on the same still-running warehouse even though results differ. In this case, verify that representative lookup queries show lower scans or latency after the optimization is ready.
A supported optimization causes a smaller fraction of micro-partitions to be scanned. That measures a different outcome: a query against a billion-row fact table scans nearly every micro-partition despite a selective date filter. In this case, verify that representative lookup queries show lower scans or latency after the optimization is ready.
The result contains exactly the intended latest record per customer. That measures a different outcome: analysts need the latest event per customer without an error-prone nested correlated query. In this case, verify that representative lookup queries show lower scans or latency after the optimization is ready.





SnowPro Core COF-C03 Practice Tests