Snowflake SnowPro Core Practice Test 9
Question 80
For an original SnowPro Core educational scenario, consider: A design document claims every customer receives identical retention and security capabilities regardless of edition. 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.
- Change: Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior.
- Promise an unsupported Enterprise-only capability in every account without checking its edition.
- Change: Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations.
- Check: Inspect edition, feature availability and limits for the named requirement in an isolated test account.
Explanation
Correct Answer
B:Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation. Evidence: Inspect edition, feature availability and limits for the named requirement in an isolated test account.
E:Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation. Acceptance: The approved design relies only on supported capabilities or explicitly plans the necessary edition change.
Incorrect Answers
A:Check: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases. Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation.
D:Change: Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations. Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation.
Question 81
A Snowflake engineer is examining this platform situation: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately. A proposed shortcut is: Attribute all Snowflake charges solely to elapsed SQL warehouse runtime. 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.
- Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules.
- Attribute all Snowflake charges solely to elapsed SQL warehouse runtime.
- Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
Explanation
Correct Answer
D:Validate the premise using: Compare service-level billing and account usage with warehouse usage for the relevant reporting period. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
B:Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
C:For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 82
A Snowflake implementation review finds: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately. The team proposes: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. 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.
- Resizing generally provides more per-cluster resources for demanding individual queries, whereas multi-cluster scaling primarily addresses concurrency.
- Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
- Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost.
Explanation
Correct Answer
C:Demonstrable success requires: Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components. This principle explains the proposed technical approach, which is: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
Incorrect Answers
A:Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
B:Resizing generally provides more per-cluster resources for demanding individual queries, whereas multi-cluster scaling primarily addresses concurrency. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:Multi-cluster minimum and scaling choices balance response time and credit consumption; maximum clusters alone do not guarantee optimal cost. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 83
The data platform team has not yet approved changes. Current evidence indicates: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
- Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
- Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
- Check retention settings, query timestamp and a before/after row sample before restoring.
Explanation
Correct Answer
C:This check tests the actual data, compute or access boundary before an operationally risky change. Applied case: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately.
Incorrect Answers
A:Inspect execution history before and after actions such as collect or write and compare data transfer size. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
B:Compare table type, data-retention parameter, recovery needs and storage usage before conversion. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:Check retention settings, query timestamp and a before/after row sample before restoring. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 84
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately. 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.
- Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates.
- Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components.
- Target queries finish within agreed latency while extra compute cost remains justified.
Explanation
Correct Answer
C:The approved implementation step was: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. 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-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
B:Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:Target queries finish within agreed latency while extra compute cost remains justified. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 85
An implementation sign-off request identifies the following problem: A budget report attributes every credit to warehouses although significant metadata-intensive activity is billed separately. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- 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: 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.
- Change: Evaluate supported Snowflake Cortex AI functions for text tasks with role access, privacy controls, cost monitoring and output validation. Verify: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
- 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.
Explanation
Correct Answer
B:The change is successful only when: Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components.
Incorrect Answers
A:Change: Use supported Notebooks in Workspaces and verify migration requirements for any legacy notebook assets. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
C:Change: Evaluate supported Snowflake Cortex AI functions for text tasks with role access, privacy controls, cost monitoring and output validation.
D:Change: Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
Question 86
A Snowflake engineer is examining this platform situation: An architect says security checks and query compilation run entirely inside user-selected warehouses. A proposed shortcut is: Attribute all Snowflake charges solely to elapsed SQL warehouse runtime. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
- Attribute all Snowflake charges solely to elapsed SQL warehouse runtime.
- Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements.
Explanation
Correct Answer
A:Validate the premise using: Compare service-level billing and account usage with warehouse usage for the relevant reporting period. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
Incorrect Answers
B:For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
C:Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 87
A Snowflake implementation review finds: An architect says security checks and query compilation run entirely inside user-selected warehouses. The team proposes: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. 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-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
- Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation.
- An idle warehouse can be suspended to stop compute consumption and resumed when authorized work requires it.
Explanation
Correct Answer
B:Demonstrable success requires: Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
Incorrect Answers
A:Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
C:Snowflake editions have different availability and limits for selected features; architectural claims must match the purchased edition and current documentation. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:An idle warehouse can be suspended to stop compute consumption and resumed when authorized work requires it. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 88
The data platform team has not yet approved changes. Current evidence indicates: An architect says security checks and query compilation run entirely inside user-selected warehouses. 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.
- Compare QUERY_HISTORY warehouse identifiers, queued time and load before and after changing session warehouse assignments.
- Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types.
- Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
Explanation
Correct Answer
D:This check tests the actual data, compute or access boundary before an operationally risky change. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
Incorrect Answers
A:Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
B:Compare QUERY_HISTORY warehouse identifiers, queued time and load before and after changing session warehouse assignments. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
C:Compare the job's memory failures, execution time, supported workload requirements and credits on both warehouse types. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 89
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An architect says security checks and query compilation run entirely inside user-selected warehouses. 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.
- A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location.
- Intermediate results are isolated to the working session and durable outputs remain accessible afterward.
- The peak workload completes with reduced queuing while the cluster count contracts after demand subsides.
Explanation
Correct Answer
A:The approved implementation step was: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
Incorrect Answers
B:A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
C:Intermediate results are isolated to the working session and durable outputs remain accessible afterward. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:The peak workload completes with reduced queuing while the cluster count contracts after demand subsides. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Question 90
For an original SnowPro Core educational scenario, consider: An architect says security checks and query compilation run entirely inside user-selected warehouses. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Compare account identifiers, regions, sharing or replication configuration and permitted data paths.
- Check: Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
- Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
- Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window.
- Attribute all Snowflake charges solely to elapsed SQL warehouse runtime.
Explanation
Correct Answer
B:Required intervention: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
C:Evidence: Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
Incorrect Answers
A:Check: Compare account identifiers, regions, sharing or replication configuration and permitted data paths. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
D:Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window. Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
E:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Applied case: An architect says security checks and query compilation run entirely inside user-selected warehouses.
