Pass Snowflake SnowPro Core Exam in First Attempt Easily
Real Snowflake SnowPro Core Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
3 products

You save $69.98

SnowPro Core Premium Bundle

  • Premium File 703 Questions & Answers
  • Last Update: Nov 22, 2026
  • Training Course 92 Lectures
  • Study Guide 413 Pages
$79.99 $149.97

Purchase Individually

  • Premium File

    703 Questions & Answers
    Last Update: Nov 22, 2026

    $76.99
    $69.99
  • Training Course

    92 Lectures

    $43.99
    $39.99
  • Study Guide

    413 Pages

    $43.99
    $39.99

SnowPro Core Practice Test 2

Question 10

The Snowflake implementation fails its pilot test. An analyst worries that suspending a reporting warehouse will delete tables populated by a different ETL warehouse. Which evidence should be inspected first to isolate the likely cause?

  1. Check table type, session identity, object listing and behavior after session termination.
  2. Inspect dynamic table refresh history, TARGET_LAG, supported query operators and dependencies.
  3. Check table existence, storage usage, warehouse state and successful queries after resume.
  4. Inspect view type, granted roles, projected fields and metadata visibility from a consumer role.

Explanation

Correct Answer

C:

Check table existence, storage usage, warehouse state and successful queries after resume. These checks diagnose Independent storage and compute. Correct response: Keep the persistent tables in Snowflake storage and independently suspend or resume the reporting compute. Expected observation: The reporting warehouse can stop and restart while previously committed table data remains accessible.

Incorrect Answers

A:

Check table type, session identity, object listing and behavior after session termination. Those checks would investigate Session-scoped temporary table, not the current Independent storage and compute failure. The targeted diagnostic here is: Check table existence, storage usage, warehouse state and successful queries after resume.

B:

Inspect dynamic table refresh history, TARGET_LAG, supported query operators and dependencies. Those checks would investigate Dynamic table declarative refresh, not the current Independent storage and compute failure. The targeted diagnostic here is: Check table existence, storage usage, warehouse state and successful queries after resume.

D:

Inspect view type, granted roles, projected fields and metadata visibility from a consumer role. Those checks would investigate Secure view for controlled data projection, not the current Independent storage and compute failure. The targeted diagnostic here is: Check table existence, storage usage, warehouse state and successful queries after resume.

Question 11

A Snowflake implementation team encounters this specific requirement: An orders table has billions of rows but a date predicate may need only a narrow range of storage partitions. Which action best addresses it?

  1. Use Snowflake Scripting blocks or a supported stored procedure with explicit permissions and error handling.
  2. Check Snowflake edition eligibility and choose an authorized upgrade or supported alternative before deployment.
  3. Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size.
  4. Express supported transformations through Snowpark DataFrames so operations execute in Snowflake when actions are invoked.

Explanation

Correct Answer

C:

Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size. This resolves Metadata-driven micro-partition pruning. Underlying reason: Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped. Verify with: The same exact result scans far fewer micro-partitions with an appropriate date restriction. Boundary: Not every expression or data layout supports the same amount of pruning.

Incorrect Answers

A:

Use Snowflake Scripting blocks or a supported stored procedure with explicit permissions and error handling. That is suitable for a different requirement, SQL scripting procedural control, with this separate condition: An operations job requires branching around a validation count and controlled exception handling inside Snowflake rather than exporting results to a shell script.

B:

Check Snowflake edition eligibility and choose an authorized upgrade or supported alternative before deployment. That is suitable for a different requirement, Enterprise edition feature requirements, with this separate condition: An administrator plans an extended historical retention setting on a lower-edition account and assumes every advanced feature is included.

D:

Express supported transformations through Snowpark DataFrames so operations execute in Snowflake when actions are invoked. That is suitable for a different requirement, Snowpark computation locality, with this separate condition: Data scientists download large regulated tables to local Python for filtering and joining despite an approved Snowflake environment.

Question 12

After implementing a Snowflake control, the reviewer must prove the business requirement was met. An orders table has billions of rows but a date predicate may need only a narrow range of storage partitions. Which result is the most direct acceptance evidence?

  1. The same exact result scans far fewer micro-partitions with an appropriate date restriction.
  2. The representative workload scans fewer partitions at acceptable automatic clustering credit consumption.
  3. A heavy loader no longer consumes the dashboard warehouse's active compute capacity.
  4. Users reach data only through deliberately configured region-compatible mechanisms and grants.

Explanation

Correct Answer

A:

The same exact result scans far fewer micro-partitions with an appropriate date restriction. This directly demonstrates success for Metadata-driven micro-partition pruning. Implementation: Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size. Mechanism: Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped.

Incorrect Answers

B:

The representative workload scans fewer partitions at acceptable automatic clustering credit consumption. This outcome is evidence for the separate Clustering key on a large fact table case, not the described Metadata-driven micro-partition pruning requirement. For the current context, verify: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

C:

A heavy loader no longer consumes the dashboard warehouse's active compute capacity. This outcome is evidence for the separate Separate ETL and BI compute case, not the described Metadata-driven micro-partition pruning requirement. For the current context, verify: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

D:

Users reach data only through deliberately configured region-compatible mechanisms and grants. This outcome is evidence for the separate Cross-region account context case, not the described Metadata-driven micro-partition pruning requirement. For the current context, verify: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

Question 13

A Snowflake specialist explains why a proposed design works. An orders table has billions of rows but a date predicate may need only a narrow range of storage partitions. Which technical principle is most relevant?

  1. Clustering organizes micro-partition overlap to improve pruning for suitable repeated access patterns.
  2. Snowflake Scripting adds procedural control flow around SQL statements within supported execution contexts.
  3. Independent warehouses isolate compute resources even when both read or write shared tables.
  4. Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped.

Explanation

Correct Answer

D:

Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped. This explains Metadata-driven micro-partition pruning. Correct implementation: Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size. Acceptance evidence: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

Incorrect Answers

A:

Clustering organizes micro-partition overlap to improve pruning for suitable repeated access patterns. This mechanism concerns Clustering key on a large fact table. The mechanism specific to Metadata-driven micro-partition pruning is: Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped.

B:

Snowflake Scripting adds procedural control flow around SQL statements within supported execution contexts. This mechanism concerns SQL scripting procedural control. The mechanism specific to Metadata-driven micro-partition pruning is: Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped.

C:

Independent warehouses isolate compute resources even when both read or write shared tables. This mechanism concerns Separate ETL and BI compute. The mechanism specific to Metadata-driven micro-partition pruning is: Snowflake maintains micro-partition statistics that can allow unneeded partitions to be skipped.

Question 14

The project leaves the described Snowflake requirement unresolved. An orders table has billions of rows but a date predicate may need only a narrow range of storage partitions. Which consequence is most directly related?

  1. A warehouse with auto-suspend disabled can consume credits during long periods without work.
  2. Using a plain unrestricted view can expose more of a sensitive transformation than intended.
  3. Increasing warehouse size alone can waste credits when a query scans unnecessary partitions.
  4. Persisting sensitive temporary data unnecessarily increases exposure and cleanup burden.

Explanation

Correct Answer

C:

Increasing warehouse size alone can waste credits when a query scans unnecessary partitions. This is the direct exposure if Metadata-driven micro-partition pruning is not handled. Recommended protection: Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size. Validate by: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

Incorrect Answers

A:

A warehouse with auto-suspend disabled can consume credits during long periods without work. This is an exposure in a separate Auto-suspend for intermittent analytics scenario. The direct failure for Metadata-driven micro-partition pruning is: Increasing warehouse size alone can waste credits when a query scans unnecessary partitions.

B:

Using a plain unrestricted view can expose more of a sensitive transformation than intended. This is an exposure in a separate Secure view for controlled data projection scenario. The direct failure for Metadata-driven micro-partition pruning is: Increasing warehouse size alone can waste credits when a query scans unnecessary partitions.

D:

Persisting sensitive temporary data unnecessarily increases exposure and cleanup burden. This is an exposure in a separate Session-scoped temporary table scenario. The direct failure for Metadata-driven micro-partition pruning is: Increasing warehouse size alone can waste credits when a query scans unnecessary partitions.

Question 15

The Snowflake implementation fails its pilot test. An orders table has billions of rows but a date predicate may need only a narrow range of storage partitions. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect Query Profile spilling, concurrent query count, warehouse size and total credits.
  2. Inspect app execution role, privileges, compute and query history while testing access.
  3. Inspect function access, model availability, request volume and output quality on a known sample.
  4. Examine partitions scanned versus total, predicate expressions and clustering characteristics in Query Profile.

Explanation

Correct Answer

D:

Examine partitions scanned versus total, predicate expressions and clustering characteristics in Query Profile. These checks diagnose Metadata-driven micro-partition pruning. Correct response: Use selective predicates on stored columns and inspect pruning evidence before changing warehouse size. Expected observation: The same exact result scans far fewer micro-partitions with an appropriate date restriction.

Incorrect Answers

A:

Inspect Query Profile spilling, concurrent query count, warehouse size and total credits. Those checks would investigate Scale up for heavy individual queries, not the current Metadata-driven micro-partition pruning failure. The targeted diagnostic here is: Examine partitions scanned versus total, predicate expressions and clustering characteristics in Query Profile.

B:

Inspect app execution role, privileges, compute and query history while testing access. Those checks would investigate Streamlit in Snowflake app, not the current Metadata-driven micro-partition pruning failure. The targeted diagnostic here is: Examine partitions scanned versus total, predicate expressions and clustering characteristics in Query Profile.

C:

Inspect function access, model availability, request volume and output quality on a known sample. Those checks would investigate Cortex AI SQL function use, not the current Metadata-driven micro-partition pruning failure. The targeted diagnostic here is: Examine partitions scanned versus total, predicate expressions and clustering characteristics in Query Profile.

Question 16

A Snowflake implementation team encounters this specific requirement: A reporting query sits in the compilation phase before the warehouse runs any data scan, and operations wants to diagnose the delay. Which action best addresses it?

  1. Define supported Snowflake Notebook access and execution configuration with explicit role and warehouse requirements.
  2. Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse.
  3. Evaluate Streamlit in Snowflake with scoped roles, warehouse configuration and supported deployment.
  4. Evaluate a carefully chosen clustering key only after Query Profile and query-frequency evidence justify maintenance cost.

Explanation

Correct Answer

B:

Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse. This resolves Query compilation versus execution. Underlying reason: Cloud services prepare and coordinate queries while warehouses process execution work. Verify with: Query history distinguishes compilation or planning delay from actual execution and queue time. Boundary: Metadata complexity and plan generation can dominate some queries even on a large warehouse.

Incorrect Answers

A:

Define supported Snowflake Notebook access and execution configuration with explicit role and warehouse requirements. That is suitable for a different requirement, Notebook execution context, with this separate condition: A team shares a notebook whose queries fail for colleagues because its author assumed the same current role and warehouse.

C:

Evaluate Streamlit in Snowflake with scoped roles, warehouse configuration and supported deployment. That is suitable for a different requirement, Streamlit in Snowflake app, with this separate condition: A finance unit wants a governed interactive dashboard backed by Snowflake data without hosting a separate application database.

D:

Evaluate a carefully chosen clustering key only after Query Profile and query-frequency evidence justify maintenance cost. That is suitable for a different requirement, Clustering key on a large fact table, with this separate condition: A multi-terabyte fact table is repeatedly filtered on account and recent date, and pruning stays poor as new rows arrive.

Question 17

After implementing a Snowflake control, the reviewer must prove the business requirement was met. A reporting query sits in the compilation phase before the warehouse runs any data scan, and operations wants to diagnose the delay. Which result is the most direct acceptance evidence?

  1. The report labels data freshness and reconciles with later finalized consumption history.
  2. Query history distinguishes compilation or planning delay from actual execution and queue time.
  3. The consumer sees only intended query results and cannot retrieve protected implementation details through ordinary metadata paths.
  4. The derived table refreshes under Snowflake-managed scheduling toward its declared freshness objective.

Explanation

Correct Answer

B:

Query history distinguishes compilation or planning delay from actual execution and queue time. This directly demonstrates success for Query compilation versus execution. Implementation: Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse. Mechanism: Cloud services prepare and coordinate queries while warehouses process execution work.

Incorrect Answers

A:

The report labels data freshness and reconciles with later finalized consumption history. This outcome is evidence for the separate Account usage reporting latency case, not the described Query compilation versus execution requirement. For the current context, verify: Query history distinguishes compilation or planning delay from actual execution and queue time.

C:

The consumer sees only intended query results and cannot retrieve protected implementation details through ordinary metadata paths. This outcome is evidence for the separate Secure view for controlled data projection case, not the described Query compilation versus execution requirement. For the current context, verify: Query history distinguishes compilation or planning delay from actual execution and queue time.

D:

The derived table refreshes under Snowflake-managed scheduling toward its declared freshness objective. This outcome is evidence for the separate Dynamic table declarative refresh case, not the described Query compilation versus execution requirement. For the current context, verify: Query history distinguishes compilation or planning delay from actual execution and queue time.

Question 18

A Snowflake specialist explains why a proposed design works. A reporting query sits in the compilation phase before the warehouse runs any data scan, and operations wants to diagnose the delay. Which technical principle is most relevant?

  1. CLI connections and scripted SQL make execution repeatable while Snowflake permissions still govern each action.
  2. Scaling up changes resources available to an individual query or execution workload.
  3. Cloud services prepare and coordinate queries while warehouses process execution work.
  4. Cortex functions expose managed AI capabilities to Snowflake SQL workflows subject to eligibility.

Explanation

Correct Answer

C:

Cloud services prepare and coordinate queries while warehouses process execution work. This explains Query compilation versus execution. Correct implementation: Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse. Acceptance evidence: Query history distinguishes compilation or planning delay from actual execution and queue time.

Incorrect Answers

A:

CLI connections and scripted SQL make execution repeatable while Snowflake permissions still govern each action. This mechanism concerns Snowflake CLI automated deployment. The mechanism specific to Query compilation versus execution is: Cloud services prepare and coordinate queries while warehouses process execution work.

B:

Scaling up changes resources available to an individual query or execution workload. This mechanism concerns Scale up for heavy individual queries. The mechanism specific to Query compilation versus execution is: Cloud services prepare and coordinate queries while warehouses process execution work.

D:

Cortex functions expose managed AI capabilities to Snowflake SQL workflows subject to eligibility. This mechanism concerns Cortex AI SQL function use. The mechanism specific to Query compilation versus execution is: Cloud services prepare and coordinate queries while warehouses process execution work.

Question 19

The project leaves the described Snowflake requirement unresolved. A reporting query sits in the compilation phase before the warehouse runs any data scan, and operations wants to diagnose the delay. Which consequence is most directly related?

  1. Treating every model call as free or unrestricted can violate data and spending policy.
  2. Economy mode can retain higher latency when throughput is sacrificed for spending reduction.
  3. Treating every elapsed second as insufficient warehouse CPU can lead to unnecessary compute spending.
  4. Building a separate unrestricted API just for dashboard queries introduces needless exposure.

Explanation

Correct Answer

C:

Treating every elapsed second as insufficient warehouse CPU can lead to unnecessary compute spending. This is the direct exposure if Query compilation versus execution is not handled. Recommended protection: Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse. Validate by: Query history distinguishes compilation or planning delay from actual execution and queue time.

Incorrect Answers

A:

Treating every model call as free or unrestricted can violate data and spending policy. This is an exposure in a separate Cortex AI SQL function use scenario. The direct failure for Query compilation versus execution is: Treating every elapsed second as insufficient warehouse CPU can lead to unnecessary compute spending.

B:

Economy mode can retain higher latency when throughput is sacrificed for spending reduction. This is an exposure in a separate Standard versus Economy multi-cluster policy scenario. The direct failure for Query compilation versus execution is: Treating every elapsed second as insufficient warehouse CPU can lead to unnecessary compute spending.

D:

Building a separate unrestricted API just for dashboard queries introduces needless exposure. This is an exposure in a separate Streamlit in Snowflake app scenario. The direct failure for Query compilation versus execution is: Treating every elapsed second as insufficient warehouse CPU can lead to unnecessary compute spending.

Question 20

The Snowflake implementation fails its pilot test. A reporting query sits in the compilation phase before the warehouse runs any data scan, and operations wants to diagnose the delay. Which evidence should be inspected first to isolate the likely cause?

  1. Read query history timings, compilation details, warehouse queue and execution profile.
  2. Inspect Query Profile spilling, concurrent query count, warehouse size and total credits.
  3. Inspect integration permissions, repository origin, refresh behavior and revision history.
  4. Inspect view type, granted roles, projected fields and metadata visibility from a consumer role.

Explanation

Correct Answer

A:

Read query history timings, compilation details, warehouse queue and execution profile. These checks diagnose Query compilation versus execution. Correct response: Inspect cloud-services planning time separately from warehouse execution rather than immediately resizing the warehouse. Expected observation: Query history distinguishes compilation or planning delay from actual execution and queue time.

Incorrect Answers

B:

Inspect Query Profile spilling, concurrent query count, warehouse size and total credits. Those checks would investigate Scale up for heavy individual queries, not the current Query compilation versus execution failure. The targeted diagnostic here is: Read query history timings, compilation details, warehouse queue and execution profile.

C:

Inspect integration permissions, repository origin, refresh behavior and revision history. Those checks would investigate Git repository integration, not the current Query compilation versus execution failure. The targeted diagnostic here is: Read query history timings, compilation details, warehouse queue and execution profile.

D:

Inspect view type, granted roles, projected fields and metadata visibility from a consumer role. Those checks would investigate Secure view for controlled data projection, not the current Query compilation versus execution failure. The targeted diagnostic here is: Read query history timings, compilation details, warehouse queue and execution profile.

SnowPro Core Practice Tests

Purchase Individually

  • Premium File

    703 Questions & Answers
    Last Update: Nov 22, 2026

    $76.99
    $69.99
  • Training Course

    92 Lectures

    $43.99
    $39.99
  • Study Guide

    413 Pages

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports