Snowflake SnowPro Core Practice Test 22
Question 210
For an original SnowPro Core educational scenario, consider: A team assumes unstructured audio files become relational rows simply by copying them into an internal stage. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Inspect stage file listings, directory table refresh and supported document-processing entry points.
- Change: Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed.
- Change: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
- Store PDF bytes in a staged location and assume SQL SELECT automatically extracts their tables.
- Check: Create a controlled clone, compare initial storage and query results, then modify only the clone.
Explanation
Correct Answer
A:Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows. Acceptance: File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records.
B:Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows. Evidence: Inspect stage file listings, directory table refresh and supported document-processing entry points.
Incorrect Answers
C:Change: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows.
D:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows.
E:Check: Create a controlled clone, compare initial storage and query results, then modify only the clone. Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows.
Question 211
A Snowflake engineer is examining this platform situation: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries. A proposed shortcut is: Move all Iceberg files into a warehouse's ephemeral local disk and bypass table metadata. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
- Move all Iceberg files into a warehouse's ephemeral local disk and bypass table metadata.
- Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
- Model account and region boundaries and plan supported sharing or replication/failover for cross-boundary access.
Explanation
Correct Answer
A:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Applied case: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries.
Incorrect Answers
B:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
C:Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:Model account and region boundaries and plan supported sharing or replication/failover for cross-boundary access. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Question 212
A Snowflake implementation review finds: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries. The team proposes: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
- Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
- Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism.
- Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Explanation
Correct Answer
D:Demonstrable success requires: A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. Applied case: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Dynamic tables for declarative pipelines) rather than the documented Apache Iceberg table architecture decision.
B:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
C:This option addresses a different Snowflake technical topic (Snowflake Cortex AI SQL functions) rather than the documented Apache Iceberg table architecture decision.
Question 213
The data platform team has not yet approved changes. Current evidence indicates: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Check retention settings, query timestamp and a before/after row sample before restoring.
- Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
- Inspect stage file listings, directory table refresh and supported document-processing entry points.
Explanation
Correct Answer
A:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Confirm afterward that: A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
Incorrect Answers
B:Check retention settings, query timestamp and a before/after row sample before restoring. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
C:Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:Inspect stage file listings, directory table refresh and supported document-processing entry points. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Question 214
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries. 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.
- File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records.
- Both interactive and automated users access only the authorized objects through the correct interfaces.
- A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
- Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
Explanation
Correct Answer
C:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
B:Both interactive and automated users access only the authorized objects through the correct interfaces. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:Data remains queryable after one warehouse stops and a different authorized warehouse can process it. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Question 215
An implementation sign-off request identifies the following problem: A lakehouse team must preserve Apache Iceberg table data in its own object storage while permitting Snowflake queries. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Verify: Check table persistence after warehouse suspension and trace a query through authorization, optimization and independent compute.
- 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.
- 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.
Explanation
Correct Answer
D:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. The change is successful only when: A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
Incorrect Answers
A:Change: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
B:Change: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
C:Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields.
Question 216
A Snowflake engineer is examining this platform situation: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table. A proposed shortcut is: Move all Iceberg files into a warehouse's ephemeral local disk and bypass table metadata. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
- Move all Iceberg files into a warehouse's ephemeral local disk and bypass table metadata.
- Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
- Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency.
Explanation
Correct Answer
C:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
B:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Use this instead: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
D:Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Question 217
A Snowflake implementation review finds: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table. The team proposes: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
- Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
- Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings.
Explanation
Correct Answer
C:Demonstrable success requires: A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. This principle explains the proposed technical approach, which is: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
Incorrect Answers
A:UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
B:This option addresses a different Snowflake technical topic (Multi-cluster warehouse concurrency) rather than the documented Apache Iceberg table architecture decision.
D:This option addresses a different Snowflake technical topic (Permanent versus transient table retention) rather than the documented Apache Iceberg table architecture decision.
Question 218
The data platform team has not yet approved changes. Current evidence indicates: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Compare requested time window, privileges, ingestion lag and query history against a sample event.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
- Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
Explanation
Correct Answer
A:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Applied case: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table.
Incorrect Answers
B:Compare requested time window, privileges, ingestion lag and query history against a sample event. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
C:Inspect execution history before and after actions such as collect or write and compare data transfer size. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability. An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table.
Question 219
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table. 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.
- The source remains unchanged and a practical test clone is created without an immediate full physical duplication.
- A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
- Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected.
- Scripts target the intended database.schema.object without cross-environment ambiguity.
Explanation
Correct Answer
B:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. The approved implementation step was: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Zero-copy cloning of database objects) rather than the documented Apache Iceberg table architecture decision.
C:Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:Scripts target the intended database.schema.object without cross-environment ambiguity. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
Question 220
For an original SnowPro Core educational scenario, consider: An architect claims an Iceberg table uses the same Snowflake-controlled internal storage as every native table. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Express supported transformations with Snowpark DataFrames and materialize results using an execution action on Snowflake compute.
- Check: Review warehouse configuration, idle duration and metered credit history around overnight gaps.
- Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
- Move all Iceberg files into a warehouse's ephemeral local disk and bypass table metadata.
- Check: Review catalog choice, external volume, object storage paths and metadata refresh requirements.
Explanation
Correct Answer
C:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Acceptance: A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
E:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Required intervention: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
Incorrect Answers
A:Change: Express supported transformations with Snowpark DataFrames and materialize results using an execution action on Snowflake compute. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
B:Check: Review warehouse configuration, idle duration and metered credit history around overnight gaps. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
D:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
