Snowflake SnowPro Core Practice Test 25
Question 240
For an original SnowPro Core educational scenario, consider: A team expects a dynamic table with a ten-minute target lag to guarantee every row is visible exactly ten minutes after insertion under all conditions. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Use dynamic tables with target lag, supported refresh mode and dependency monitoring for declarative transformations.
- Treat a target lag declaration as an unconditional guarantee of per-row instantaneous propagation.
- Change: Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules.
- Check: Inspect refresh history, dependencies, actual lag and warehouse or serverless resource configuration.
- Check: Verify table type, historical retention expiration and documented support/recovery process before planning restoration.
Explanation
Correct Answer
A:Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA. Evidence: Inspect refresh history, dependencies, actual lag and warehouse or serverless resource configuration.
D:Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA. Required intervention: Use dynamic tables with target lag, supported refresh mode and dependency monitoring for declarative transformations.
Incorrect Answers
B:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
C:Change: Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
E:Check: Verify table type, historical retention expiration and documented support/recovery process before planning restoration. Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
Question 241
A Snowflake engineer is examining this platform situation: A CDC consumer rereads a billion-row table daily to find a few changed orders. A proposed shortcut is: Treat a stream as an unlimited append-only event archive that multiple pipelines can consume without offset coordination. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
- Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans.
- Model account and region boundaries and plan supported sharing or replication/failover for cross-boundary access.
- Treat a stream as an unlimited append-only event archive that multiple pipelines can consume without offset coordination.
Explanation
Correct Answer
A:The required acceptance condition is: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
B:Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
C:Model account and region boundaries and plan supported sharing or replication/failover for cross-boundary access. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
D:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 242
A Snowflake implementation review finds: A CDC consumer rereads a billion-row table daily to find a few changed orders. The team proposes: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows.
- Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
- Temporary tables exist only for their creating session and are removed when the session ends.
- Resizing generally provides more per-cluster resources for demanding individual queries, whereas multi-cluster scaling primarily addresses concurrency.
Explanation
Correct Answer
B:Demonstrable success requires: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. This principle explains the proposed technical approach, which is: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
Incorrect Answers
A:Stages store files and directory tables expose metadata; a file's existence alone does not transform its contents into structured table rows. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
C:Temporary tables exist only for their creating session and are removed when the session ends. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
D:Resizing generally provides more per-cluster resources for demanding individual queries, whereas multi-cluster scaling primarily addresses concurrency. A CDC consumer rereads a billion-row table daily to find a few changed orders.
Question 243
The data platform team has not yet approved changes. Current evidence indicates: A CDC consumer rereads a billion-row table daily to find a few changed orders. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
- Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
- Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
- Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
Explanation
Correct Answer
A:Confirm afterward that: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Applied case: A CDC consumer rereads a billion-row table daily to find a few changed orders.
Incorrect Answers
B:Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records. A CDC consumer rereads a billion-row table daily to find a few changed orders.
C:Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
D:Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples. A CDC consumer rereads a billion-row table daily to find a few changed orders.
Question 244
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A CDC consumer rereads a billion-row table daily to find a few changed orders. 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.
- Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components.
- Each consumer processes only its authorized new changes without missing events due to another consumer's offset.
- Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected.
- File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records.
Explanation
Correct Answer
B:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
C:Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected. A CDC consumer rereads a billion-row table daily to find a few changed orders.
D:File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
Question 245
An implementation sign-off request identifies the following problem: A CDC consumer rereads a billion-row table daily to find a few changed orders. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- 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: 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: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed. Verify: Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
- Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. Verify: Check retention settings, query timestamp and a before/after row sample before restoring.
Explanation
Correct Answer
C:The change is successful only when: Each consumer processes only its authorized new changes without missing events due to another consumer's offset.
Incorrect Answers
A:Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. A CDC consumer rereads a billion-row table daily to find a few changed orders.
B:Change: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. A CDC consumer rereads a billion-row table daily to find a few changed orders.
D:Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. A CDC consumer rereads a billion-row table daily to find a few changed orders.
Question 246
A Snowflake engineer is examining this platform situation: Two independent downstream consumers share one stream object and one consumes changes before the other processes them. A proposed shortcut is: Treat a stream as an unlimited append-only event archive that multiple pipelines can consume without offset coordination. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans.
- Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Treat a stream as an unlimited append-only event archive that multiple pipelines can consume without offset coordination.
- Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
Explanation
Correct Answer
D:The required acceptance condition is: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Applied case: Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Incorrect Answers
A:Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans. Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
B:Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
C:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. Applied case: Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Question 247
A Snowflake implementation review finds: Two independent downstream consumers share one stream object and one consumes changes before the other processes them. The team proposes: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
- Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
- 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
A:Demonstrable success requires: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Applied case: Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Incorrect Answers
B:This option addresses a different Snowflake technical topic (Dynamic tables for declarative pipelines) rather than the documented Streams for change data capture decision.
C:Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
D:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
Question 248
The data platform team has not yet approved changes. Current evidence indicates: Two independent downstream consumers share one stream object and one consumes changes before the other processes them. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
- Verify client driver version, role, database, warehouse, authentication and query history for a representative operation.
- Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
Explanation
Correct Answer
A:Confirm afterward that: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Applied case: Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Incorrect Answers
B:Verify client driver version, role, database, warehouse, authentication and query history for a representative operation. Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
C:Review catalog choice, external volume, object storage paths and metadata refresh requirements. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
D:Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases. Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Question 249
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: Two independent downstream consumers share one stream object and one consumes changes before the other processes them. 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.
- Only authorized cross-boundary data is accessible and recovery assumptions match configured replication behavior.
- Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection.
- Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components.
- Each consumer processes only its authorized new changes without missing events due to another consumer's offset.
Explanation
Correct Answer
D:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. The approved implementation step was: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
Incorrect Answers
A:Only authorized cross-boundary data is accessible and recovery assumptions match configured replication behavior. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
B:Staging data meets low-cost lifecycle goals while critical source-of-record data retains required recovery protection. Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
C:Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components. Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
Question 250
For an original SnowPro Core educational scenario, consider: Two independent downstream consumers share one stream object and one consumes changes before the other processes them. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
- Change: Use supported CLONE operations for a point-in-time logical snapshot and treat later changes to source and clone as separate.
- Check: Check table persistence after warehouse suspension and trace a query through authorization, optimization and independent compute.
- Treat a stream as an unlimited append-only event archive that multiple pipelines can consume without offset coordination.
- Check: Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
Explanation
Correct Answer
A:Acceptance: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Applied case: Two independent downstream consumers share one stream object and one consumes changes before the other processes them.
E:Acceptance: Each consumer processes only its authorized new changes without missing events due to another consumer's offset. Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
Incorrect Answers
B:This option addresses a different Snowflake technical topic (Zero-copy cloning of database objects) rather than the documented Streams for change data capture decision.
C:This option addresses a different Snowflake technical topic (Three-layer Snowflake architecture) rather than the documented Streams for change data capture decision.
D:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. Use this instead: Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
