cert
cert-1
cert-2

Pass Snowflake SnowPro Core Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
SnowPro Core Exam - Verified By Experts
SnowPro Core Premium Bundle
$29.98

SnowPro Core Premium Bundle

$79.99
$109.97
  • Premium File 703 Questions & Answers. Last update: Nov 02, 2026
  • Training Course 92 Video Lectures
  • Study Guide 413 Pages
 
$109.97
$79.99
accept 17 downloads in last 7 days
block-screenshots
Purchase Snowflake SnowPro Core Exam Training Products Individually
Snowflake SnowPro Core Premium File
Premium File 703 Q&A
$76.99$69.99
Snowflake SnowPro Core Video Training Course
Training Course 92 Lectures
$21.99 $19.99
Snowflake SnowPro Core PDF Study Guide
Study Guide 413 Pages
$21.99 $19.99
Snowflake SnowPro Core Practice Test 48

Question 470

For an original SnowPro Core educational scenario, consider: A data engineer cannot read a new S3 bucket because its IAM trust and allowed location do not match the storage integration. Select TWO complementary steps: the targeted correction and its strongest prechange validation.

  1. Paste permanent cloud administrator access keys into every external stage definition.
  2. Change: Plan a controlled GRANT OWNERSHIP transfer with documented handling of existing grants and post-transfer validation.
  3. Check: Check integration grants, cloud IAM role trust, allowed prefixes and controlled stage listing.
  4. Check: Test identical queries under representative roles and verify permitted and denied row counts.
  5. Change: Use supported storage integrations tied to narrowly scoped cloud IAM permissions and approved external locations.

Explanation

Correct Answer

C:

Storage integrations delegate external cloud access through controlled identity relationships, reducing exposure from embedded static credentials. Acceptance: The approved bucket is reachable without exposing personal credentials or unrelated cloud paths.

E:

Storage integrations delegate external cloud access through controlled identity relationships, reducing exposure from embedded static credentials. Evidence: Check integration grants, cloud IAM role trust, allowed prefixes and controlled stage listing.

Incorrect Answers

A:

Storage integrations delegate external cloud access through controlled identity relationships, reducing exposure from embedded static credentials. Use this instead: Use supported storage integrations tied to narrowly scoped cloud IAM permissions and approved external locations.

B:

Change: Plan a controlled GRANT OWNERSHIP transfer with documented handling of existing grants and post-transfer validation. Storage integrations delegate external cloud access through controlled identity relationships, reducing exposure from embedded static credentials.

D:

Check: Test identical queries under representative roles and verify permitted and denied row counts. Storage integrations delegate external cloud access through controlled identity relationships, reducing exposure from embedded static credentials.

Question 471

A Snowflake engineer is examining this platform situation: A shared development warehouse consumes far more credits during a load test than the monthly team allowance. A proposed shortcut is: Ignore serverless credits because one warehouse resource monitor is enabled. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.

  1. Ignore serverless credits because one warehouse resource monitor is enabled.
  2. Define appropriate supported authentication policies and client-type restrictions per user population, testing changes before enforcement.
  3. Plan a controlled GRANT OWNERSHIP transfer with documented handling of existing grants and post-transfer validation.
  4. Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.

Explanation

Correct Answer

D:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. This targeted change addresses the stated technical or governance gap without discarding necessary controls.

Incorrect Answers

A:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.

B:

Define appropriate supported authentication policies and client-type restrictions per user population, testing changes before enforcement. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

C:

Plan a controlled GRANT OWNERSHIP transfer with documented handling of existing grants and post-transfer validation. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 472

A Snowflake implementation review finds: A shared development warehouse consumes far more credits during a load test than the monthly team allowance. The team proposes: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage. Which platform principle most strongly supports the recommended response? Select ONE best answer.

  1. Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
  2. Query authorization can consider active primary and secondary roles, while CREATE object ownership and required creation privileges follow primary-role semantics.
  3. Identity federation centralizes authentication while Snowflake role authorization remains a separate explicit layer.
  4. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Explanation

Correct Answer

D:

Demonstrable success requires: The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges. This principle explains the proposed technical approach, which is: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.

Incorrect Answers

A:

Time Travel retention limits vary by table class and edition, and historical storage contributes to cost. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

B:

Query authorization can consider active primary and secondary roles, while CREATE object ownership and required creation privileges follow primary-role semantics. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

C:

Identity federation centralizes authentication while Snowflake role authorization remains a separate explicit layer. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 473

The data platform team has not yet approved changes. Current evidence indicates: A shared development warehouse consumes far more credits during a load test than the monthly team allowance. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.

  1. Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage.
  2. Compare ownership and dependent grants before and after transfer using SHOW GRANTS.
  3. Record source IP addresses, policy precedence, login failures and emergency recovery path under safe testing.
  4. Test selected ACCOUNT_USAGE views under a read-only audit role and verify available columns and latency.

Explanation

Correct Answer

A:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. Confirm afterward that: The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges.

Incorrect Answers

B:

Compare ownership and dependent grants before and after transfer using SHOW GRANTS. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

C:

Record source IP addresses, policy precedence, login failures and emergency recovery path under safe testing. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

Test selected ACCOUNT_USAGE views under a read-only audit role and verify available columns and latency. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 474

A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A shared development warehouse consumes far more credits during a load test than the monthly team allowance. 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.

  1. Authorized employees sign in securely and removed employees cannot retain access through stale credentials.
  2. Authorized roles receive appropriate values while other users see safe masked representations.
  3. The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges.
  4. The pipeline authenticates securely without depending on an individual's privileged interactive credentials.

Explanation

Correct Answer

C:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. The result must be validated using the documented dataset or access context.

Incorrect Answers

A:

Authorized employees sign in securely and removed employees cannot retain access through stale credentials. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

B:

Authorized roles receive appropriate values while other users see safe masked representations. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

The pipeline authenticates securely without depending on an individual's privileged interactive credentials. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 475

An implementation sign-off request identifies the following problem: A shared development warehouse consumes far more credits during a load test than the monthly team allowance. Which paired technical change and validation should close the implementation review? Select ONE best answer.

  1. Change: Set the correct primary role and authorized secondary-role configuration, remembering that object creation ownership uses the primary role. Verify: Compare CURRENT_ROLE, CURRENT_SECONDARY_ROLES and attempted SQL with each role mode.
  2. Change: Define appropriate FUTURE grants on the intended database or schema in addition to any existing-object grants. Verify: Create a controlled new table after configuring grants and verify permissions separately from an old table.
  3. Change: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage. Verify: Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage.
  4. Change: Apply account- or user-scope network policy with accurate allowed sources and tested break-glass access. Verify: Record source IP addresses, policy precedence, login failures and emergency recovery path under safe testing.

Explanation

Correct Answer

C:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. The change is successful only when: The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges.

Incorrect Answers

A:

Change: Set the correct primary role and authorized secondary-role configuration, remembering that object creation ownership uses the primary role. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

B:

Change: Define appropriate FUTURE grants on the intended database or schema in addition to any existing-object grants. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

Change: Apply account- or user-scope network policy with accurate allowed sources and tested break-glass access. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 476

A Snowflake engineer is examining this platform situation: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically. A proposed shortcut is: Ignore serverless credits because one warehouse resource monitor is enabled. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.

  1. Use supported access-history, object-dependency and audit metadata with appropriate retention and access controls.
  2. Ignore serverless credits because one warehouse resource monitor is enabled.
  3. Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.
  4. Use a managed access schema and delegate grant decisions to the schema owner or a role with MANAGE GRANTS.

Explanation

Correct Answer

C:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. Applied case: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically.

Incorrect Answers

A:

Use supported access-history, object-dependency and audit metadata with appropriate retention and access controls. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

B:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. Use this instead: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.

D:

This option addresses a different Snowflake technical topic (Managed access schema privilege ownership) rather than the documented Resource monitors and credit limits decision.

Question 477

A Snowflake implementation review finds: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically. The team proposes: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage. Which platform principle most strongly supports the recommended response? Select ONE best answer.

  1. Query authorization can consider active primary and secondary roles, while CREATE object ownership and required creation privileges follow primary-role semantics.
  2. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.
  3. Row access policies provide centralized row-level access decisions that do not depend on every consuming SQL author remembering a filter.
  4. Masking policies transform values exposed to queries based on policy context without requiring separate duplicated source tables for every audience.

Explanation

Correct Answer

B:

Demonstrable success requires: The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges. Applied case: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically.

Incorrect Answers

A:

Query authorization can consider active primary and secondary roles, while CREATE object ownership and required creation privileges follow primary-role semantics. Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically.

C:

This option addresses a different Snowflake technical topic (Row access policies for jurisdictional filtering) rather than the documented Resource monitors and credit limits decision.

D:

Masking policies transform values exposed to queries based on policy context without requiring separate duplicated source tables for every audience. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 478

The data platform team has not yet approved changes. Current evidence indicates: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.

  1. Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage.
  2. Inspect SHOW GRANTS, role hierarchy and active session role for the target object and user.
  3. Create a controlled new table after configuring grants and verify permissions separately from an old table.
  4. Check SHOW GRANTS for database, schema, table and selected warehouse on the active role.

Explanation

Correct Answer

A:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. This check tests the actual data, compute or access boundary before an operationally risky change.

Incorrect Answers

B:

Inspect SHOW GRANTS, role hierarchy and active session role for the target object and user. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

C:

Create a controlled new table after configuring grants and verify permissions separately from an old table. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

Check SHOW GRANTS for database, schema, table and selected warehouse on the active role. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

Question 479

A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically. 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.

  1. Auditors obtain the required evidence without permanent global account administration.
  2. The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges.
  3. The new steward manages objects while approved consumers retain their intended privileges.
  4. Authorized employees sign in securely and removed employees cannot retain access through stale credentials.

Explanation

Correct Answer

B:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. The approved implementation step was: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.

Incorrect Answers

A:

Auditors obtain the required evidence without permanent global account administration. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

C:

The new steward manages objects while approved consumers retain their intended privileges. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

Authorized employees sign in securely and removed employees cannot retain access through stale credentials. Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically.

Question 480

For an original SnowPro Core educational scenario, consider: Finance assumes that setting a resource monitor cap prevents every kind of serverless service charge automatically. Select TWO complementary steps: the targeted correction and its strongest prechange validation.

  1. Change: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.
  2. Check: Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage.
  3. Check: Compare ownership and dependent grants before and after transfer using SHOW GRANTS.
  4. Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles.
  5. Ignore serverless credits because one warehouse resource monitor is enabled.

Explanation

Correct Answer

A:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. Acceptance: The watched warehouse raises alerts or suspends as configured without claiming to cap unrelated charges.

B:

Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services. Required intervention: Configure suitable warehouse resource monitor thresholds and supported notifications or suspension actions; separately monitor serverless usage.

Incorrect Answers

C:

Check: Compare ownership and dependent grants before and after transfer using SHOW GRANTS. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

D:

Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

E:

For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Resource monitors govern supported warehouse credit consumption and are not a universal spending cap for all Snowflake services.

SnowPro Core Practice Tests