Snowflake SnowPro Core Practice Test 1
Question 1
A Snowflake engineer is examining this platform situation: A new architect assumes the virtual warehouse holds the permanent customer tables and expects data to disappear after suspension. A proposed shortcut is: Keep the only copy of production records on a warehouse's ephemeral execution cache. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use temporary tables only for intermediate data confined to a session and persist required results in durable table types.
- Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
- Keep the only copy of production records on a warehouse's ephemeral execution cache.
- Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans.
Explanation
Correct Answer
B:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Use temporary tables only for intermediate data confined to a session and persist required results in durable table types. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
D:Evaluate hybrid tables for supported transactional, index-based row workloads and standard tables for large-scale analytic scans. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 2
A Snowflake implementation review finds: A new architect assumes the virtual warehouse holds the permanent customer tables and expects data to disappear after suspension. The team proposes: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
- Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
- Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
- An idle warehouse can be suspended to stop compute consumption and resumed when authorized work requires it.
Explanation
Correct Answer
B:Demonstrable success requires: Data remains queryable after one warehouse stops and a different authorized warehouse can process it. This principle explains the proposed technical approach, which is: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
Incorrect Answers
A:Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:An idle warehouse can be suspended to stop compute consumption and resumed when authorized work requires it. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 3
The data platform team has not yet approved changes. Current evidence indicates: A new architect assumes the virtual warehouse holds the permanent customer tables and expects data to disappear after suspension. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Check table persistence after warehouse suspension and trace a query through authorization, optimization and independent compute.
- Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
- Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
Explanation
Correct Answer
A:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Confirm afterward that: Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
Incorrect Answers
B:Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:Inspect execution history before and after actions such as collect or write and compare data transfer size. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 4
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A new architect assumes the virtual warehouse holds the permanent customer tables and expects data to disappear after suspension. 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.
- Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
- Computation executes on the selected Snowflake environment and minimizes unnecessary local transfers.
- 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.
Explanation
Correct Answer
A:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. The result must be validated using the documented dataset or access context.
Incorrect Answers
B:Computation executes on the selected Snowflake environment and minimizes unnecessary local transfers. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:The source remains unchanged and a practical test clone is created without an immediate full physical duplication. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:A governed Iceberg table can be queried with supported capabilities while its files remain in the configured external location. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 5
An implementation sign-off request identifies the following problem: A new architect assumes the virtual warehouse holds the permanent customer tables and expects data to disappear after suspension. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements. Verify: Correlate cluster activity, queue lengths and hourly metering with workload peaks and lulls.
- 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: 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.
- Change: Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed. Verify: Inspect stage file listings, directory table refresh and supported document-processing entry points.
Explanation
Correct Answer
B:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. The change is successful only when: Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
Incorrect Answers
A:Change: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:Change: Use supported Time Travel AT or BEFORE query and restore patterns within the object's applicable retention window.
D:Change: Use appropriate staged file storage, directory metadata and supported unstructured file references or processing functions as needed.
Question 6
A Snowflake engineer is examining this platform situation: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses. A proposed shortcut is: Keep the only copy of production records on a warehouse's ephemeral execution cache. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Keep the only copy of production records on a warehouse's ephemeral execution cache.
- Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
- Let Snowflake manage compressed columnar micro-partitions for native table data and use pruning-aware design where necessary.
- Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations.
Explanation
Correct Answer
B:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Applied case: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses.
Incorrect Answers
A:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Use this instead: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
C:Let Snowflake manage compressed columnar micro-partitions for native table data and use pruning-aware design where necessary. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 7
A Snowflake implementation review finds: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses. The team proposes: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
- Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
- Specialized warehouse types provide different memory-to-compute characteristics and cost profiles; they are not universally preferable for SQL reporting.
- Standard Snowflake table storage is automatically organized into immutable columnar micro-partitions and their metadata rather than manually managed warehouse files.
Explanation
Correct Answer
B:Demonstrable success requires: Data remains queryable after one warehouse stops and a different authorized warehouse can process it. Applied case: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses.
Incorrect Answers
A:Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C: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.
D:Standard Snowflake table storage is automatically organized into immutable columnar micro-partitions and their metadata rather than manually managed warehouse files. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 8
The data platform team has not yet approved changes. Current evidence indicates: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses. 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.
- Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session.
- Check table persistence after warehouse suspension and trace a query through authorization, optimization and independent compute.
- Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
Explanation
Correct Answer
C:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Review catalog choice, external volume, object storage paths and metadata refresh requirements. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
B:Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 9
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple 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.
- Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates.
- File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records.
- Batch workloads no longer consume the interactive warehouse's slots while both read consistent shared tables.
- Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
Explanation
Correct Answer
D:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. The approved implementation step was: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
Incorrect Answers
A:Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
B:File inventory and authorized downstream processing work without misrepresenting staged objects as parsed records. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
C:Batch workloads no longer consume the interactive warehouse's slots while both read consistent shared tables. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
Question 10
For an original SnowPro Core educational scenario, consider: A migration team places account authentication inside a compute cluster diagram and cannot explain how queries run on multiple warehouses. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
- Keep the only copy of production records on a warehouse's ephemeral execution cache.
- Check: Check table persistence after warehouse suspension and trace a query through authorization, optimization and independent compute.
- Check: Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
- Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption.
Explanation
Correct Answer
A:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Acceptance: Data remains queryable after one warehouse stops and a different authorized warehouse can process it.
C:Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work. Required intervention: Separate persistent cloud storage from independently provisioned warehouse compute and Snowflake-managed cloud services when designing the architecture.
Incorrect Answers
B:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
D:Check: Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
E:Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. Snowflake persists managed data outside a particular warehouse while cloud services coordinate authentication, metadata and optimization and warehouses execute work.
