Snowflake SnowPro Core Practice Test 7
Question 60
For an original SnowPro Core educational scenario, consider: An operations team sets the minimum cluster count to peak capacity even during hours without demand. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements.
- Check: Review warehouse configuration, idle duration and metered credit history around overnight gaps.
- Set minimum and maximum clusters to the highest value without observing demand or cost.
- Change: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets.
- Check: Correlate cluster activity, queue lengths and hourly metering with workload peaks and lulls.
Explanation
Correct Answer
A:Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost. Acceptance: Clusters grow for meaningful demand and shrink when the service target permits without sustaining idle peak capacity.
E:Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost. Required intervention: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements.
Incorrect Answers
B:Check: Review warehouse configuration, idle duration and metered credit history around overnight gaps. Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost.
D:Change: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost.
Question 61
A Snowflake engineer is examining this platform situation: A Python Snowpark workload processes large intermediate model objects and repeatedly exceeds ordinary warehouse memory expectations. A proposed shortcut is: Switch every SQL reporting workload to specialized compute because the word optimized appears in the name. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
- Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed.
- Switch every SQL reporting workload to specialized compute because the word optimized appears in the name.
- Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Explanation
Correct Answer
A:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
B:Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
C:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
D:Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 62
A Snowflake implementation review finds: A Python Snowpark workload processes large intermediate model objects and repeatedly exceeds ordinary warehouse memory expectations. The team proposes: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
- Resizing generally provides more per-cluster resources for demanding individual queries, whereas multi-cluster scaling primarily addresses concurrency.
- Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
- Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics.
Explanation
Correct Answer
A:Relevant validation before approval: Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types. This principle explains the proposed technical approach, which is: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
Incorrect Answers
B:This option addresses a different Snowflake technical topic (Warehouse resizing for resource-intensive queries) rather than the documented Snowpark-optimized warehouse selection decision.
C:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
D:Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 63
The data platform team has not yet approved changes. Current evidence indicates: A Python Snowpark workload processes large intermediate model objects and repeatedly exceeds ordinary warehouse memory expectations. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types.
- Reproduce creation, querying and session close using two independent connections.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
- Compare access pattern, index availability, concurrency, constraint enforcement and compute cost.
Explanation
Correct Answer
A:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. If confirmed, the proportionate intervention is: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
Incorrect Answers
B:Reproduce creation, querying and session close using two independent connections. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
C:This option addresses a different Snowflake technical topic (Snowpark DataFrame execution) rather than the documented Snowpark-optimized warehouse selection decision.
D:Compare access pattern, index availability, concurrency, constraint enforcement and compute cost. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 64
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A Python Snowpark workload processes large intermediate model objects and repeatedly exceeds ordinary warehouse memory expectations. 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.
- 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.
- The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
- Approved use cases generate useful drafts without bypassing classification or uncritically treating model output as factual truth.
Explanation
Correct Answer
C:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. The approved implementation step was: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
Incorrect Answers
A:A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
B:Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
D:This option addresses a different Snowflake technical topic (Snowflake Cortex AI SQL functions) rather than the documented Snowpark-optimized warehouse selection decision.
Question 65
An implementation sign-off request identifies the following problem: A Python Snowpark workload processes large intermediate model objects and repeatedly exceeds ordinary warehouse memory expectations. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Verify: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
- Change: Set workload-suitable AUTO_SUSPEND and AUTO_RESUME values and validate startup behavior and billing. Verify: Review warehouse configuration, idle duration and metered credit history around overnight gaps.
- 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: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. Verify: Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
Explanation
Correct Answer
C:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. The change is successful only when: The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
Incorrect Answers
A:Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
B:Change: Set workload-suitable AUTO_SUSPEND and AUTO_RESUME values and validate startup behavior and billing. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
D:Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 66
A Snowflake engineer is examining this platform situation: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need. A proposed shortcut is: Switch every SQL reporting workload to specialized compute because the word optimized appears in the name. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window.
- Switch every SQL reporting workload to specialized compute because the word optimized appears in the name.
- Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
- Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed.
Explanation
Correct Answer
C:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Applied case: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
Incorrect Answers
A:Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
B:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Use this instead: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
D:Create appropriate streams to expose change data and give independently checkpointed consumers their own streams when needed. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 67
A Snowflake implementation review finds: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need. The team proposes: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
- Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
- Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics.
Explanation
Correct Answer
C:Relevant validation before approval: Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types. Applied case: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
Incorrect Answers
A:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
B:Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
D:Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics. A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
Question 68
The data platform team has not yet approved changes. Current evidence indicates: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Reproduce creation, querying and session close using two independent connections.
- Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak.
- Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types.
- Inspect partition statistics and query profile scans before and after relevant data layout changes.
Explanation
Correct Answer
C:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Confirm afterward that: The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
Incorrect Answers
A:Reproduce creation, querying and session close using two independent connections. A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
B:Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
D:Inspect partition statistics and query profile scans before and after relevant data layout changes. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 69
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need. 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 targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
- Batch workloads no longer consume the interactive warehouse's slots while both read consistent shared tables.
- A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
- Operational lookups and constraints behave as required while bulk analytics use fit-for-purpose storage.
Explanation
Correct Answer
A:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. The result must be validated using the documented dataset or access context.
Incorrect Answers
B:Batch workloads no longer consume the interactive warehouse's slots while both read consistent shared tables. A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
C:A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
D:Operational lookups and constraints behave as required while bulk analytics use fit-for-purpose storage. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
Question 70
For an original SnowPro Core educational scenario, consider: A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session.
- Change: Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed.
- Switch every SQL reporting workload to specialized compute because the word optimized appears in the name.
- Change: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
- Check: Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types.
Explanation
Correct Answer
D:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Acceptance: The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
E:Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting. Required intervention: Evaluate Snowpark-optimized warehouse configurations only for supported memory-intensive Snowpark operations with measured benefit.
Incorrect Answers
A:Check: Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session. A BI dashboard is moved to a Snowpark-optimized warehouse without a demonstrated memory need.
B:Change: Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
