Question 650
A test plan evaluates: An engineer creates a dynamic table with a SELECT query and assumes it behaves like a normal manually written snapshot table. Which evidence should be required before release?
Explanation
Correct Answer
The table refreshes toward the declared lag rather than requiring the team to rerun a one-time insert. This validates the relevant action: Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement. The underlying Snowflake behavior is: Dynamic tables maintain query-defined results through Snowflake refresh management.
Incorrect Answers
A sample metadata refresh or write follows the chosen catalog ownership and supported permissions. This evidence tests a DIFFERENT situation: An application developer assumes an external Iceberg catalog table is administered identically to a native Snowflake-managed table. The correction required in this case is: Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement.
Representative varied JSON payloads load without adding a column for each optional key. This evidence tests a DIFFERENT situation: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. The correction required in this case is: Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement.
A test natural-language query retrieves relevant approved passages rather than just lexical file-name matches. This evidence tests a DIFFERENT situation: An AI team expects an enterprise search feature to be built by sorting all documents by their file names. The correction required in this case is: Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement.