Question 140
A developer assumes all query metadata must be recomputed from the raw object files on every compilation. Before implementing the planned approach, which prerequisite should be checked most directly?
Explanation
Correct Answer
Inspect object statistics and cloud services behavior before assigning all work to warehouses. The condition matters because metadata about partitions and objects helps the service plan work without reading every data byte.
Incorrect Answers
Confirm the predicate is selective, type-compatible and not unnecessarily wrapped in functions. That preparatory check belongs to a query against a billion-row fact table scans nearly every micro-partition despite a selective date filter. Here, the decisive check is inspect object statistics and cloud services behavior before assigning all work to warehouses.
Check whether the join keys are unique or whether a missing predicate causes fan-out. That preparatory check belongs to a dashboard query returns too many intermediate rows after joining two tables with nonunique keys. Here, the decisive check is inspect object statistics and cloud services behavior before assigning all work to warehouses.
Check which clients selected the warehouse and whether shared workloads confound attribution. That preparatory check belongs to finOps needs evidence that a specific BI workload, not a batch load, caused a compute spike. Here, the decisive check is inspect object statistics and cloud services behavior before assigning all work to warehouses.





SnowPro Core COF-C03 Practice Tests