Question 550
A BI service frequently sees cached responses but an analyst modifies a source table between requests. After implementing the approach, which observation best demonstrates the required outcome?
Explanation
Correct Answer
The subsequent query reflects current committed data rather than an invalid stale result. This demonstrates the outcome for the stated requirement rather than just a saved configuration.
Incorrect Answers
Intermediate row counts shrink while the report retains the expected business totals. That measures a different outcome: a dashboard query returns too many intermediate rows after joining two tables with nonunique keys. In this case, verify that the subsequent query reflects current committed data rather than an invalid stale result.
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 the subsequent query reflects current committed data rather than an invalid stale result.
The single query scans less data and completes faster without adding clusters. That measures a different outcome: a warehouse has high concurrency, but the bottleneck is a single poorly filtered query scanning almost every partition. In this case, verify that the subsequent query reflects current committed data rather than an invalid stale result.





SnowPro Core COF-C03 Practice Tests