Snowflake SnowPro Core Practice Test 14
Question 130
For an original SnowPro Core educational scenario, consider: An audit dataset is moved to a transient table merely to save storage despite needing the strongest available recovery options. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
- Check: Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak.
- Change: Use permanent tables for durable recovery requirements and transient tables for suitable short-lived data with reduced recovery guarantees.
- Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window.
- Convert all regulated production tables to transient to eliminate recovery storage.
Explanation
Correct Answer
A:Acceptance: Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection. Applied case: An audit dataset is moved to a transient table merely to save storage despite needing the strongest available recovery options.
C:Acceptance: Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection. Evidence: Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
Incorrect Answers
B:Check: Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak. Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings.
D:Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings.
E:Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings. Distinguish the two approaches by checking: Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
Question 131
A Snowflake engineer is examining this platform situation: An ETL session creates a temporary work table and another session cannot find it after the first connection closes. A proposed shortcut is: Use a temporary table as the only surviving warehouse record for an annual audit. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Use a temporary table as the only surviving warehouse record for an annual audit.
- Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency.
- Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements.
Explanation
Correct Answer
A:Temporary tables exist only for their creating session and are removed when the session ends. Applied case: An ETL session creates a temporary work table and another session cannot find it after the first connection closes.
Incorrect Answers
B:Temporary tables exist only for their creating session and are removed when the session ends. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
C:Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. Temporary tables exist only for their creating session and are removed when the session ends.
D:Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements. Temporary tables exist only for their creating session and are removed when the session ends.
Question 132
A Snowflake implementation review finds: An ETL session creates a temporary work table and another session cannot find it after the first connection closes. The team proposes: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- FLATTEN is a table function that expands elements of semi-structured arrays into rows.
- An idle warehouse can be suspended to stop compute consumption and resumed when authorized work requires it.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
- Temporary tables exist only for their creating session and are removed when the session ends.
Explanation
Correct Answer
D:Demonstrable success requires: Intermediate results are isolated to the working session and durable outputs remain accessible afterward. This principle explains the proposed technical approach, which is: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Incorrect Answers
A:FLATTEN is a table function that expands elements of semi-structured arrays into rows. Temporary tables exist only for their creating session and are removed when the session ends.
B:This option addresses a different Snowflake technical topic (Warehouse auto-suspend and auto-resume) rather than the documented Session-scoped temporary tables decision.
C:This option addresses a different Snowflake technical topic (Multi-cluster warehouse concurrency) rather than the documented Session-scoped temporary tables decision.
Question 133
The data platform team has not yet approved changes. Current evidence indicates: An ETL session creates a temporary work table and another session cannot find it after the first connection closes. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
- Reproduce creation, querying and session close using two independent connections.
- Inspect partition statistics and query profile scans before and after relevant data layout changes.
- Examine task graph history, predecessor states, warehouse permissions and failure handling.
Explanation
Correct Answer
B:Temporary tables exist only for their creating session and are removed when the session ends. If confirmed, the proportionate intervention is: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Incorrect Answers
A:Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples. Temporary tables exist only for their creating session and are removed when the session ends.
C:Inspect partition statistics and query profile scans before and after relevant data layout changes. Temporary tables exist only for their creating session and are removed when the session ends.
D:Examine task graph history, predecessor states, warehouse permissions and failure handling. Temporary tables exist only for their creating session and are removed when the session ends.
Question 134
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An ETL session creates a temporary work table and another session cannot find it after the first connection closes. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection.
- The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
- The prior valid state is inspected or restored without overwriting unrelated current records.
- Intermediate results are isolated to the working session and durable outputs remain accessible afterward.
Explanation
Correct Answer
D:Temporary tables exist only for their creating session and are removed when the session ends. The approved implementation step was: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Incorrect Answers
A:Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection. Temporary tables exist only for their creating session and are removed when the session ends.
B:The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure. Temporary tables exist only for their creating session and are removed when the session ends.
C:The prior valid state is inspected or restored without overwriting unrelated current records. Temporary tables exist only for their creating session and are removed when the session ends.
Question 135
An implementation sign-off request identifies the following problem: An ETL session creates a temporary work table and another session cannot find it after the first connection closes. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Verify: Reproduce creation, querying and session close using two independent connections.
- Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. Verify: Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Change: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. Verify: Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types.
- Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Verify: Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
Explanation
Correct Answer
A:Temporary tables exist only for their creating session and are removed when the session ends. The change is successful only when: Intermediate results are isolated to the working session and durable outputs remain accessible afterward.
Incorrect Answers
B:Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. Temporary tables exist only for their creating session and are removed when the session ends.
C:Change: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
D:Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Temporary tables exist only for their creating session and are removed when the session ends.
Question 136
A Snowflake engineer is examining this platform situation: A team stores important month-end balances in a temporary table and expects them to survive application restart. A proposed shortcut is: Use a temporary table as the only surviving warehouse record for an annual audit. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Use Snowflake tasks with explicit predecessors and monitored task graph behavior for supported SQL or procedure workflows.
- Express supported transformations with Snowpark DataFrames and materialize results using an execution action on Snowflake compute.
- Use a temporary table as the only surviving warehouse record for an annual audit.
Explanation
Correct Answer
A:Temporary tables exist only for their creating session and are removed when the session ends. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
B:Use Snowflake tasks with explicit predecessors and monitored task graph behavior for supported SQL or procedure workflows. Temporary tables exist only for their creating session and are removed when the session ends.
C:This option addresses a different Snowflake technical topic (Snowpark DataFrame execution) rather than the documented Session-scoped temporary tables decision.
D:Temporary tables exist only for their creating session and are removed when the session ends. Use this instead: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Question 137
A Snowflake implementation review finds: A team stores important month-end balances in a temporary table and expects them to survive application restart. The team proposes: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Temporary tables exist only for their creating session and are removed when the session ends.
- Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
- Tables and views live in schemas within databases; session context determines resolution of unqualified object names.
- Historical data versions remain queryable within Time Travel retention, which depends on object type, settings and edition.
Explanation
Correct Answer
A:Demonstrable success requires: Intermediate results are isolated to the working session and durable outputs remain accessible afterward. Applied case: A team stores important month-end balances in a temporary table and expects them to survive application restart.
Incorrect Answers
B:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Temporary tables exist only for their creating session and are removed when the session ends.
C:Tables and views live in schemas within databases; session context determines resolution of unqualified object names. Temporary tables exist only for their creating session and are removed when the session ends.
D:Historical data versions remain queryable within Time Travel retention, which depends on object type, settings and edition. Temporary tables exist only for their creating session and are removed when the session ends.
Question 138
The data platform team has not yet approved changes. Current evidence indicates: A team stores important month-end balances in a temporary table and expects them to survive application restart. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect edition, feature availability and limits for the named requirement in an isolated test account.
- Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Compare account identifiers, regions, sharing or replication configuration and permitted data paths.
- Reproduce creation, querying and session close using two independent connections.
Explanation
Correct Answer
D:Temporary tables exist only for their creating session and are removed when the session ends. Applied case: A team stores important month-end balances in a temporary table and expects them to survive application restart.
Incorrect Answers
A:Inspect edition, feature availability and limits for the named requirement in an isolated test account. Temporary tables exist only for their creating session and are removed when the session ends.
B:Review catalog choice, external volume, object storage paths and metadata refresh requirements. Temporary tables exist only for their creating session and are removed when the session ends.
C:Compare account identifiers, regions, sharing or replication configuration and permitted data paths. Temporary tables exist only for their creating session and are removed when the session ends.
Question 139
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A team stores important month-end balances in a temporary table and expects them to survive application restart. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- Monitoring reports show expected data at the promised freshness and scope without misinterpreting latency as absence.
- Intermediate results are isolated to the working session and durable outputs remain accessible afterward.
- The recovery runbook specifies the correct mechanism and realistic timing for historical incidents.
- Analysts can create and maintain notebooks in the supported current experience with governed data access.
Explanation
Correct Answer
B:Temporary tables exist only for their creating session and are removed when the session ends. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Monitoring reports show expected data at the promised freshness and scope without misinterpreting latency as absence. Temporary tables exist only for their creating session and are removed when the session ends.
C:The recovery runbook specifies the correct mechanism and realistic timing for historical incidents. Temporary tables exist only for their creating session and are removed when the session ends.
D:Analysts can create and maintain notebooks in the supported current experience with governed data access. Temporary tables exist only for their creating session and are removed when the session ends.
Question 140
For an original SnowPro Core educational scenario, consider: A team stores important month-end balances in a temporary table and expects them to survive application restart. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Evaluate supported Snowflake Cortex AI functions for text tasks with role access, privacy controls, cost monitoring and output validation.
- Use a temporary table as the only surviving warehouse record for an annual audit.
- Check: Compare requested time window, privileges, ingestion lag and query history against a sample event.
- Change: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Check: Reproduce creation, querying and session close using two independent connections.
Explanation
Correct Answer
D:Temporary tables exist only for their creating session and are removed when the session ends. Evidence: Reproduce creation, querying and session close using two independent connections.
E:Temporary tables exist only for their creating session and are removed when the session ends. Required intervention: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Snowflake Cortex AI SQL functions) rather than the documented Session-scoped temporary tables decision.
B:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Temporary tables exist only for their creating session and are removed when the session ends.
C:Check: Compare requested time window, privileges, ingestion lag and query history against a sample event. Temporary tables exist only for their creating session and are removed when the session ends.
