Snowflake SnowPro Core Practice Test 29
Question 280
For an original SnowPro Core educational scenario, consider: A data steward assumes generative AI responses are guaranteed accurate and safe to store as audited facts without evaluation. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
- Check: Inspect refresh history, dependencies, actual lag and warehouse or serverless resource configuration.
- Mark all Cortex-generated text as verified business records without checking its content.
- Change: Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations.
- Change: Evaluate supported Snowflake Cortex AI functions for text tasks with role access, privacy controls, cost monitoring and output validation.
Explanation
Correct Answer
A:Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism. Acceptance: Approved use cases generate useful drafts without bypassing classification or uncritically treating model output as factual truth.
E:Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism. Evidence: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
Incorrect Answers
B:Check: Inspect refresh history, dependencies, actual lag and warehouse or serverless resource configuration. Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism.
D:This option addresses a different Snowflake technical topic (Database, schema and object hierarchy) rather than the documented Snowflake Cortex AI SQL functions decision.
Question 281
A Snowflake engineer is examining this platform situation: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface. A proposed shortcut is: Depend on creating new legacy notebooks in accounts where that feature is no longer available. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use Time Travel for self-service history and regard Fail-safe on eligible permanent objects as a limited Snowflake-assisted recovery mechanism.
- Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
- Use supported CLONE operations for a point-in-time logical snapshot and treat later changes to source and clone as separate.
- Depend on creating new legacy notebooks in accounts where that feature is no longer available.
Explanation
Correct Answer
B:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Applied case: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Fail-safe purpose and operational limits) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
C:This option addresses a different Snowflake technical topic (Zero-copy cloning of database objects) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
D:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 282
A Snowflake implementation review finds: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface. The team proposes: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
- Snowflake separates account-specific resources and regions; cross-account data access and disaster recovery require supported configuration.
- Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
- Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Explanation
Correct Answer
A:Demonstrable success requires: Analysts can create and maintain notebooks in the supported current experience with governed data access. Applied case: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface.
Incorrect Answers
B:Snowflake separates account-specific resources and regions; cross-account data access and disaster recovery require supported configuration. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:This option addresses a different Snowflake technical topic (Snowpark-optimized warehouse selection) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
D:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
Question 283
The data platform team has not yet approved changes. Current evidence indicates: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Compare requested time window, privileges, ingestion lag and query history against a sample event.
- Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
- Examine task graph history, predecessor states, warehouse permissions and failure handling.
- Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session.
Explanation
Correct Answer
B:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Confirm afterward that: Analysts can create and maintain notebooks in the supported current experience with governed data access.
Incorrect Answers
A:Compare requested time window, privileges, ingestion lag and query history against a sample event. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:Examine task graph history, predecessor states, warehouse permissions and failure handling. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
D:This option addresses a different Snowflake technical topic (Database, schema and object hierarchy) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
Question 284
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface. 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 approved design relies only on supported capabilities or explicitly plans the necessary edition change.
- Each consumer processes only its authorized new changes without missing events due to another consumer's offset.
- Batch workloads no longer consume the interactive warehouse's slots while both read consistent shared tables.
- Analysts can create and maintain notebooks in the supported current experience with governed data access.
Explanation
Correct Answer
D:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:The approved design relies only on supported capabilities or explicitly plans the necessary edition change. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
B:This option addresses a different Snowflake technical topic (Streams for change data capture) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
C:This option addresses a different Snowflake technical topic (Independent virtual warehouse workload isolation) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
Question 285
An implementation sign-off request identifies the following problem: A new 2026 account cannot create a legacy notebook yet the training material instructs the team to use the old interface. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access. Verify: Verify client driver version, role, database, warehouse, authentication and query history for a representative operation.
- Change: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. Verify: Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
- Change: Use dynamic tables with target lag, supported refresh mode and dependency monitoring for declarative transformations. Verify: Inspect refresh history, dependencies, actual lag and warehouse or serverless resource configuration.
- Change: Configure and evaluate an appropriate multi-cluster warehouse and scaling policy to absorb concurrent sessions. Verify: Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak.
Explanation
Correct Answer
B:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. The change is successful only when: Analysts can create and maintain notebooks in the supported current experience with governed data access.
Incorrect Answers
A:Change: Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:This option addresses a different Snowflake technical topic (Dynamic tables for declarative pipelines) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
D:Change: Configure and evaluate an appropriate multi-cluster warehouse and scaling policy to absorb concurrent sessions. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
Question 286
A Snowflake engineer is examining this platform situation: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control. A proposed shortcut is: Depend on creating new legacy notebooks in accounts where that feature is no longer available. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior.
- Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
- Depend on creating new legacy notebooks in accounts where that feature is no longer available.
- Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
Explanation
Correct Answer
D:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
B:Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Use this instead: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
Question 287
A Snowflake implementation review finds: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control. The team proposes: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. 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.
- Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
- Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics.
Explanation
Correct Answer
B:Demonstrable success requires: Analysts can create and maintain notebooks in the supported current experience with governed data access. This principle explains the proposed technical approach, which is: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
Incorrect Answers
A:UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
D:Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
Question 288
The data platform team has not yet approved changes. Current evidence indicates: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
- Compare account identifiers, regions, sharing or replication configuration and permitted data paths.
- Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
- Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
Explanation
Correct Answer
C:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Applied case: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control.
Incorrect Answers
A:Compare table type, data-retention parameter, recovery needs and storage usage before conversion. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
B:Compare account identifiers, regions, sharing or replication configuration and permitted data paths. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
D:Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
Question 289
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control. 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.
- Analysts can create and maintain notebooks in the supported current experience with governed data access.
- The peak workload completes with reduced queuing while the cluster count contracts after demand subsides.
- A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
- The prior valid state is inspected or restored without overwriting unrelated current records.
Explanation
Correct Answer
A:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. The approved implementation step was: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
Incorrect Answers
B:The peak workload completes with reduced queuing while the cluster count contracts after demand subsides. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
C:This option addresses a different Snowflake technical topic (Apache Iceberg table architecture) rather than the documented Notebooks in Workspaces versus legacy notebooks decision.
D:The prior valid state is inspected or restored without overwriting unrelated current records. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
Question 290
For an original SnowPro Core educational scenario, consider: A Python analyst wants collaborative SQL and Python exploration with modern workspace integration and version control. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
- Change: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
- Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
- Depend on creating new legacy notebooks in accounts where that feature is no longer available.
- Check: Correlate cluster activity, queue lengths and hourly metering with workload peaks and lulls.
Explanation
Correct Answer
A:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Acceptance: Analysts can create and maintain notebooks in the supported current experience with governed data access.
B:Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation. Evidence: Compare the account's notebook navigation, supported runtimes, role access and legacy migration capability.
Incorrect Answers
C:Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
D:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
E:Check: Correlate cluster activity, queue lengths and hourly metering with workload peaks and lulls. Snowflake's legacy notebook experience is being superseded by Notebooks in Workspaces; availability and workflows depend on account rollout and current documentation.
