Question 610
After the approved change, engineers revisit: An application developer assumes an external Iceberg catalog table is administered identically to a native Snowflake-managed table. Which result establishes the intended state?
Explanation
Correct Answer
A sample metadata refresh or write follows the chosen catalog ownership and supported permissions. This validates the relevant action: Verify Iceberg integration mode, catalog responsibility and storage credentials before choosing table lifecycle commands. The underlying Snowflake behavior is: Open table formats and catalog integrations have control boundaries distinct from ordinary managed tables.
Incorrect Answers
A test query resolves the intended object using the documented naming convention. This evidence tests a DIFFERENT situation: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. The correction required in this case is: Verify Iceberg integration mode, catalog responsibility and storage credentials before choosing table lifecycle commands.
A UDF call returns an expression value while the controlled procedure performs its intended procedural workflow. This evidence tests a DIFFERENT situation: A SQL reporting team mixes SQL UDFs and stored procedures as though both have identical invocation and side effects. The correction required in this case is: Verify Iceberg integration mode, catalog responsibility and storage credentials before choosing table lifecycle commands.
A representative feature calculation runs against permitted Snowflake data with fewer uncontrolled exports. This evidence tests a DIFFERENT situation: A retailer builds an ML feature pipeline by copying full source datasets to laptops every day. The correction required in this case is: Verify Iceberg integration mode, catalog responsibility and storage credentials before choosing table lifecycle commands.