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 35

Question 340

The Snowflake implementation fails its pilot test. A Snowflake SQL workflow must invoke one approved external HTTPS service, but the team proposes unrestricted outbound access. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect source samples, FIELD_OPTIONALLY_ENCLOSED_BY, NULL_IF and COPY validation errors.
  2. Inspect API integration allowlist, external function definition, cloud gateway and execution errors.
  3. Inspect stage contents, PUT results, stage grants and COPY output.
  4. Review stage URL, storage IAM conditions and attempted forbidden prefix access.

Explanation

Correct Answer

B:

Inspect API integration allowlist, external function definition, cloud gateway and execution errors. These checks diagnose External function integration authentication. Correct response: Configure the supported API integration or external function with scoped endpoint trust and authentication. Expected observation: Only the approved service endpoint is invoked successfully and unrelated domains are unavailable.

Incorrect Answers

A:

Inspect source samples, FIELD_OPTIONALLY_ENCLOSED_BY, NULL_IF and COPY validation errors. Those checks would investigate CSV field and null handling, not the current External function integration authentication failure. The targeted diagnostic here is: Inspect API integration allowlist, external function definition, cloud gateway and execution errors.

C:

Inspect stage contents, PUT results, stage grants and COPY output. Those checks would investigate Internal stage for controlled file import, not the current External function integration authentication failure. The targeted diagnostic here is: Inspect API integration allowlist, external function definition, cloud gateway and execution errors.

D:

Review stage URL, storage IAM conditions and attempted forbidden prefix access. Those checks would investigate External stage prefix scoping, not the current External function integration authentication failure. The targeted diagnostic here is: Inspect API integration allowlist, external function definition, cloud gateway and execution errors.

Question 341

A Snowflake implementation team encounters this specific requirement: An ETL tool establishes a connection but reads a different database than its design because an account-wide default role was assumed. Which action best addresses it?

  1. Set explicit connector account, role, warehouse, database and schema session context with least privilege.
  2. Create a supported Snowflake task graph with explicit predecessor relationships and appropriate compute selection.
  3. Use COPY INTO a governed external stage location with appropriate file format and export permissions.
  4. Use a supported SELECT transform in COPY FROM stage to map desired source fields explicitly.

Explanation

Correct Answer

A:

Set explicit connector account, role, warehouse, database and schema session context with least privilege. This resolves Connector incremental extraction context. Underlying reason: A connector's session identity and current object context govern SQL resolution and access. Verify with: The connector reads exactly the approved source objects and fails on forbidden datasets. Boundary: Connection secrets and role grants must remain governed beyond a successful connectivity test.

Incorrect Answers

B:

Create a supported Snowflake task graph with explicit predecessor relationships and appropriate compute selection. That is suitable for a different requirement, Task DAG for ordered transforms, with this separate condition: A nightly job must load raw events before building a clean dimension and then updating a summary, but separate cron jobs race.

C:

Use COPY INTO a governed external stage location with appropriate file format and export permissions. That is suitable for a different requirement, COPY INTO unload to external files, with this separate condition: A partner requires a daily outbound CSV extract in an approved cloud path instead of direct table access.

D:

Use a supported SELECT transform in COPY FROM stage to map desired source fields explicitly. That is suitable for a different requirement, Selective CSV columns into staging, with this separate condition: A flat file's first field is an irrelevant export identifier and the second and third fields should populate a two-column target.

Question 342

After implementing a Snowflake control, the reviewer must prove the business requirement was met. An ETL tool establishes a connection but reads a different database than its design because an account-wide default role was assumed. Which result is the most direct acceptance evidence?

  1. The connector reads exactly the approved source objects and fails on forbidden datasets.
  2. LIST and COPY reveal only approved log objects from the configured location.
  3. The consumer receives relevant CDC changes and a committed consumption advances the stream offset.
  4. Sample nested keys remain addressable and unknown optional fields do not force an immediate schema migration.

Explanation

Correct Answer

A:

The connector reads exactly the approved source objects and fails on forbidden datasets. This directly demonstrates success for Connector incremental extraction context. Implementation: Set explicit connector account, role, warehouse, database and schema session context with least privilege. Mechanism: A connector's session identity and current object context govern SQL resolution and access.

Incorrect Answers

B:

LIST and COPY reveal only approved log objects from the configured location. This outcome is evidence for the separate External stage prefix scoping case, not the described Connector incremental extraction context requirement. For the current context, verify: The connector reads exactly the approved source objects and fails on forbidden datasets.

C:

The consumer receives relevant CDC changes and a committed consumption advances the stream offset. This outcome is evidence for the separate Streams capture change offsets case, not the described Connector incremental extraction context requirement. For the current context, verify: The connector reads exactly the approved source objects and fails on forbidden datasets.

D:

Sample nested keys remain addressable and unknown optional fields do not force an immediate schema migration. This outcome is evidence for the separate JSON stage data with VARIANT case, not the described Connector incremental extraction context requirement. For the current context, verify: The connector reads exactly the approved source objects and fails on forbidden datasets.

Question 343

A Snowflake specialist explains why a proposed design works. An ETL tool establishes a connection but reads a different database than its design because an account-wide default role was assumed. Which technical principle is most relevant?

  1. Stage locations and cloud IAM jointly limit which object-storage paths can be ingested.
  2. A connector's session identity and current object context govern SQL resolution and access.
  3. COPY validation modes expose parsing or conversion failures without performing a normal data insertion.
  4. VARIANT can hold semi-structured JSON values accessed by path expressions.

Explanation

Correct Answer

B:

A connector's session identity and current object context govern SQL resolution and access. This explains Connector incremental extraction context. Correct implementation: Set explicit connector account, role, warehouse, database and schema session context with least privilege. Acceptance evidence: The connector reads exactly the approved source objects and fails on forbidden datasets.

Incorrect Answers

A:

Stage locations and cloud IAM jointly limit which object-storage paths can be ingested. This mechanism concerns External stage prefix scoping. The mechanism specific to Connector incremental extraction context is: A connector's session identity and current object context govern SQL resolution and access.

C:

COPY validation modes expose parsing or conversion failures without performing a normal data insertion. This mechanism concerns COPY INTO validation mode. The mechanism specific to Connector incremental extraction context is: A connector's session identity and current object context govern SQL resolution and access.

D:

VARIANT can hold semi-structured JSON values accessed by path expressions. This mechanism concerns JSON stage data with VARIANT. The mechanism specific to Connector incremental extraction context is: A connector's session identity and current object context govern SQL resolution and access.

Question 344

The project leaves the described Snowflake requirement unresolved. An ETL tool establishes a connection but reads a different database than its design because an account-wide default role was assumed. Which consequence is most directly related?

  1. Using default parsing for incompatible CSV syntax can silently corrupt downstream amounts.
  2. File-per-record ingestion can create excessive management overhead and latency.
  3. Default-context drift can silently move imports to incorrect datasets.
  4. Granting partner SELECT on internal production tables would exceed the file-exchange requirement.

Explanation

Correct Answer

C:

Default-context drift can silently move imports to incorrect datasets. This is the direct exposure if Connector incremental extraction context is not handled. Recommended protection: Set explicit connector account, role, warehouse, database and schema session context with least privilege. Validate by: The connector reads exactly the approved source objects and fails on forbidden datasets.

Incorrect Answers

A:

Using default parsing for incompatible CSV syntax can silently corrupt downstream amounts. This is an exposure in a separate CSV field and null handling scenario. The direct failure for Connector incremental extraction context is: Default-context drift can silently move imports to incorrect datasets.

B:

File-per-record ingestion can create excessive management overhead and latency. This is an exposure in a separate Snowpipe Streaming for row events scenario. The direct failure for Connector incremental extraction context is: Default-context drift can silently move imports to incorrect datasets.

D:

Granting partner SELECT on internal production tables would exceed the file-exchange requirement. This is an exposure in a separate COPY INTO unload to external files scenario. The direct failure for Connector incremental extraction context is: Default-context drift can silently move imports to incorrect datasets.

Question 345

The Snowflake implementation fails its pilot test. An ETL tool establishes a connection but reads a different database than its design because an account-wide default role was assumed. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect connection settings, CURRENT_ROLE, CURRENT_DATABASE, CURRENT_SCHEMA and query history.
  2. Inspect source samples, FIELD_OPTIONALLY_ENCLOSED_BY, NULL_IF and COPY validation errors.
  3. Inspect stage contents, PUT results, stage grants and COPY output.
  4. Inspect notification wiring, pipe status, file arrival, COPY_HISTORY and errors.

Explanation

Correct Answer

A:

Inspect connection settings, CURRENT_ROLE, CURRENT_DATABASE, CURRENT_SCHEMA and query history. These checks diagnose Connector incremental extraction context. Correct response: Set explicit connector account, role, warehouse, database and schema session context with least privilege. Expected observation: The connector reads exactly the approved source objects and fails on forbidden datasets.

Incorrect Answers

B:

Inspect source samples, FIELD_OPTIONALLY_ENCLOSED_BY, NULL_IF and COPY validation errors. Those checks would investigate CSV field and null handling, not the current Connector incremental extraction context failure. The targeted diagnostic here is: Inspect connection settings, CURRENT_ROLE, CURRENT_DATABASE, CURRENT_SCHEMA and query history.

C:

Inspect stage contents, PUT results, stage grants and COPY output. Those checks would investigate Internal stage for controlled file import, not the current Connector incremental extraction context failure. The targeted diagnostic here is: Inspect connection settings, CURRENT_ROLE, CURRENT_DATABASE, CURRENT_SCHEMA and query history.

D:

Inspect notification wiring, pipe status, file arrival, COPY_HISTORY and errors. Those checks would investigate Snowpipe event-driven file ingestion, not the current Connector incremental extraction context failure. The targeted diagnostic here is: Inspect connection settings, CURRENT_ROLE, CURRENT_DATABASE, CURRENT_SCHEMA and query history.

Question 346

A Snowflake implementation team encounters this specific requirement: A large aggregation slowed after its input doubled and Query Profile shows substantial bytes spilled to remote storage. Which action best addresses it?

  1. Test Query Acceleration Service against the query's supported operators and workload evidence.
  2. Add the correct join predicate or explicitly justified CROSS JOIN with controlled row grain.
  3. Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan.
  4. Evaluate Snowflake Search Optimization Service for the supported point-lookup predicate.

Explanation

Correct Answer

C:

Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan. This resolves Query Profile remote spill diagnosis. Underlying reason: Remote spilling indicates intermediate data exceeded available local processing capacity. Verify with: Equivalent query results complete with less remote spilling and acceptable credits after the change. Boundary: A larger warehouse is only justified when measurement shows enough net benefit.

Incorrect Answers

A:

Test Query Acceleration Service against the query's supported operators and workload evidence. That is suitable for a different requirement, Query acceleration on eligible scan-heavy query, with this separate condition: A long selective aggregation cannot meet latency targets after SQL tuning, and the team wants to offload eligible work without globally resizing.

B:

Add the correct join predicate or explicitly justified CROSS JOIN with controlled row grain. That is suitable for a different requirement, Avoid Cartesian product from missing join condition, with this separate condition: A report joining 100 stores to 12 periods returns far too many rows when a third table is added without its key condition.

D:

Evaluate Snowflake Search Optimization Service for the supported point-lookup predicate. That is suitable for a different requirement, Search optimization for selective lookup, with this separate condition: A large events table frequently looks up one exact transaction ID, but its rows are not naturally clustered by that ID.

Question 347

After implementing a Snowflake control, the reviewer must prove the business requirement was met. A large aggregation slowed after its input doubled and Query Profile shows substantial bytes spilled to remote storage. Which result is the most direct acceptance evidence?

  1. Representative dashboards read the maintained result with lower recurring query cost and correct totals.
  2. The number of output lines matches the array cardinality and retains the correct parent ID.
  3. Equivalent query results complete with less remote spilling and acceptable credits after the change.
  4. Each chosen service improves its targeted workload without unjustified duplicate maintenance cost.

Explanation

Correct Answer

C:

Equivalent query results complete with less remote spilling and acceptable credits after the change. This directly demonstrates success for Query Profile remote spill diagnosis. Implementation: Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan. Mechanism: Remote spilling indicates intermediate data exceeded available local processing capacity.

Incorrect Answers

A:

Representative dashboards read the maintained result with lower recurring query cost and correct totals. This outcome is evidence for the separate Materialized view for repetitive aggregation case, not the described Query Profile remote spill diagnosis requirement. For the current context, verify: Equivalent query results complete with less remote spilling and acceptable credits after the change.

B:

The number of output lines matches the array cardinality and retains the correct parent ID. This outcome is evidence for the separate LATERAL FLATTEN for order arrays case, not the described Query Profile remote spill diagnosis requirement. For the current context, verify: Equivalent query results complete with less remote spilling and acceptable credits after the change.

D:

Each chosen service improves its targeted workload without unjustified duplicate maintenance cost. This outcome is evidence for the separate Clustering versus selective search optimization case, not the described Query Profile remote spill diagnosis requirement. For the current context, verify: Equivalent query results complete with less remote spilling and acceptable credits after the change.

Question 348

A Snowflake specialist explains why a proposed design works. A large aggregation slowed after its input doubled and Query Profile shows substantial bytes spilled to remote storage. Which technical principle is most relevant?

  1. An outer join preserves left-side rows when no right-side match exists.
  2. VARIANT path expressions navigate nested objects without string-searching serialized documents.
  3. Remote spilling indicates intermediate data exceeded available local processing capacity.
  4. FLATTEN expands array elements into rows within a correlated lateral relationship.

Explanation

Correct Answer

C:

Remote spilling indicates intermediate data exceeded available local processing capacity. This explains Query Profile remote spill diagnosis. Correct implementation: Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan. Acceptance evidence: Equivalent query results complete with less remote spilling and acceptable credits after the change.

Incorrect Answers

A:

An outer join preserves left-side rows when no right-side match exists. This mechanism concerns LEFT JOIN preserves unmatched orders. The mechanism specific to Query Profile remote spill diagnosis is: Remote spilling indicates intermediate data exceeded available local processing capacity.

B:

VARIANT path expressions navigate nested objects without string-searching serialized documents. This mechanism concerns VARIANT nested path query. The mechanism specific to Query Profile remote spill diagnosis is: Remote spilling indicates intermediate data exceeded available local processing capacity.

D:

FLATTEN expands array elements into rows within a correlated lateral relationship. This mechanism concerns LATERAL FLATTEN for order arrays. The mechanism specific to Query Profile remote spill diagnosis is: Remote spilling indicates intermediate data exceeded available local processing capacity.

Question 349

The project leaves the described Snowflake requirement unresolved. A large aggregation slowed after its input doubled and Query Profile shows substantial bytes spilled to remote storage. Which consequence is most directly related?

  1. A directory listing alone does not parse PDF content or grant safe document access.
  2. Parsing the array as one long string prevents correct item-level metrics.
  3. Applying all services indiscriminately can cost more than the queries they improve.
  4. Changing result cache settings alone will not solve a memory-heavy execution plan.

Explanation

Correct Answer

D:

Changing result cache settings alone will not solve a memory-heavy execution plan. This is the direct exposure if Query Profile remote spill diagnosis is not handled. Recommended protection: Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan. Validate by: Equivalent query results complete with less remote spilling and acceptable credits after the change.

Incorrect Answers

A:

A directory listing alone does not parse PDF content or grant safe document access. This is an exposure in a separate Unstructured file metadata and extraction scenario. The direct failure for Query Profile remote spill diagnosis is: Changing result cache settings alone will not solve a memory-heavy execution plan.

B:

Parsing the array as one long string prevents correct item-level metrics. This is an exposure in a separate LATERAL FLATTEN for order arrays scenario. The direct failure for Query Profile remote spill diagnosis is: Changing result cache settings alone will not solve a memory-heavy execution plan.

C:

Applying all services indiscriminately can cost more than the queries they improve. This is an exposure in a separate Clustering versus selective search optimization scenario. The direct failure for Query Profile remote spill diagnosis is: Changing result cache settings alone will not solve a memory-heavy execution plan.

Question 350

The Snowflake implementation fails its pilot test. A large aggregation slowed after its input doubled and Query Profile shows substantial bytes spilled to remote storage. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect query pattern, view eligibility, refresh billing and execution profile.
  2. Inspect predicate eligibility, lookup selectivity, maintenance cost and test latency.
  3. Inspect spill bytes, warehouse size, aggregation cardinality and execution operators.
  4. Review GROUP BY keys, conditional predicates and reconciliation to source totals.

Explanation

Correct Answer

C:

Inspect spill bytes, warehouse size, aggregation cardinality and execution operators. These checks diagnose Query Profile remote spill diagnosis. Correct response: Investigate memory pressure and test a suitably sized warehouse or more efficient aggregation plan. Expected observation: Equivalent query results complete with less remote spilling and acceptable credits after the change.

Incorrect Answers

A:

Inspect query pattern, view eligibility, refresh billing and execution profile. Those checks would investigate Materialized view for repetitive aggregation, not the current Query Profile remote spill diagnosis failure. The targeted diagnostic here is: Inspect spill bytes, warehouse size, aggregation cardinality and execution operators.

B:

Inspect predicate eligibility, lookup selectivity, maintenance cost and test latency. Those checks would investigate Search optimization for selective lookup, not the current Query Profile remote spill diagnosis failure. The targeted diagnostic here is: Inspect spill bytes, warehouse size, aggregation cardinality and execution operators.

D:

Review GROUP BY keys, conditional predicates and reconciliation to source totals. Those checks would investigate Conditional aggregation in one scan, not the current Query Profile remote spill diagnosis failure. The targeted diagnostic here is: Inspect spill bytes, warehouse size, aggregation cardinality and execution operators.

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