Question 560
A staging table stores raw JSON text but downstream queries require typed access to nested attributes. Before implementing the planned approach, which prerequisite should be checked most directly?
Explanation
Correct Answer
Validate malformed input, absent keys and type coercion requirements. The condition matters because VARIANT and path expressions support semi-structured navigation, while casts control resulting SQL types.
Incorrect Answers
Confirm connection defaults, the distinct warehouse assignments and baseline credits. That preparatory check belongs to a team's unrelated ad-hoc notebooks repeatedly compete with a critical production API's queries. Here, the decisive check is validate malformed input, absent keys and type coercion requirements.
Confirm SQL eligibility, maintenance cost, and acceptable freshness before creating it. That preparatory check belongs to an aggregate dashboard repeatedly runs an expensive compatible query over slowly changing source data. Here, the decisive check is validate malformed input, absent keys and type coercion requirements.
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 validate malformed input, absent keys and type coercion requirements.





SnowPro Core COF-C03 Practice Tests