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 23

Question 220

The Snowflake implementation fails its pilot test. Managers in EMEA must see only EMEA customer records from a shared sales table even though all use the same dashboard. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect policy signature, mapping table, CURRENT_ROLE logic and test role results.
  2. Inspect SHOW DATABASE ROLES, database grants and role inheritance results.
  3. Inspect security integration, token scopes, current role and failed unauthorized requests.
  4. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.

Explanation

Correct Answer

A:

Inspect policy signature, mapping table, CURRENT_ROLE logic and test role results. These checks diagnose Row-level regional access. Correct response: Attach an authorized row access policy using region and role-to-region mapping. Expected observation: EMEA and Americas test roles receive only their intended regions from the same SELECT.

Incorrect Answers

B:

Inspect SHOW DATABASE ROLES, database grants and role inheritance results. Those checks would investigate Database role boundaries, not the current Row-level regional access failure. The targeted diagnostic here is: Inspect policy signature, mapping table, CURRENT_ROLE logic and test role results.

C:

Inspect security integration, token scopes, current role and failed unauthorized requests. Those checks would investigate OAuth delegated application tokens, not the current Row-level regional access failure. The targeted diagnostic here is: Inspect policy signature, mapping table, CURRENT_ROLE logic and test role results.

D:

Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds. Those checks would investigate Login history versus access history, not the current Row-level regional access failure. The targeted diagnostic here is: Inspect policy signature, mapping table, CURRENT_ROLE logic and test role results.

Question 221

A Snowflake implementation team encounters this specific requirement: New customer tables repeatedly miss confidential classifications and inconsistent column masking. Which action best addresses it?

  1. Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions.
  2. Use a supported key-pair or OAuth service authentication method and protect or rotate credentials.
  3. Define governed classification tags and supported tag-based masking associations for eligible columns.
  4. Grant the reader role to the reporting role following the approved account role hierarchy.

Explanation

Correct Answer

C:

Define governed classification tags and supported tag-based masking associations for eligible columns. This resolves Tag-driven classification and masking. Underlying reason: Tags can carry semantic classification and participate in supported governance policy assignment. Verify with: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication. Boundary: Tag propagation and supported policy behavior must be tested for the target object types.

Incorrect Answers

A:

Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. That is suitable for a different requirement, Human MFA enforcement, with this separate condition: Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy.

B:

Use a supported key-pair or OAuth service authentication method and protect or rotate credentials. That is suitable for a different requirement, Service user key-pair authentication, with this separate condition: A CI integration currently embeds a reusable plain-text password in its source repository.

D:

Grant the reader role to the reporting role following the approved account role hierarchy. That is suitable for a different requirement, Role hierarchy inheritance, with this separate condition: A reporting role should inherit a narrow reader role but currently needs every SELECT privilege granted repeatedly.

Question 222

After implementing a Snowflake control, the reviewer must prove the business requirement was met. New customer tables repeatedly miss confidential classifications and inconsistent column masking. Which result is the most direct acceptance evidence?

  1. A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.
  2. A newly created eligible table becomes readable under the approved role without manual repeat grants.
  3. Authorized account roles gain the intended database access but not unrelated account-wide rights.
  4. Individual object creators cannot independently regrant protected objects in that managed schema.

Explanation

Correct Answer

A:

A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication. This directly demonstrates success for Tag-driven classification and masking. Implementation: Define governed classification tags and supported tag-based masking associations for eligible columns. Mechanism: Tags can carry semantic classification and participate in supported governance policy assignment.

Incorrect Answers

B:

A newly created eligible table becomes readable under the approved role without manual repeat grants. This outcome is evidence for the separate Future grants for new tables case, not the described Tag-driven classification and masking requirement. For the current context, verify: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

C:

Authorized account roles gain the intended database access but not unrelated account-wide rights. This outcome is evidence for the separate Database role boundaries case, not the described Tag-driven classification and masking requirement. For the current context, verify: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

D:

Individual object creators cannot independently regrant protected objects in that managed schema. This outcome is evidence for the separate Managed access schema grants case, not the described Tag-driven classification and masking requirement. For the current context, verify: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

Question 223

A Snowflake specialist explains why a proposed design works. New customer tables repeatedly miss confidential classifications and inconsistent column masking. Which technical principle is most relevant?

  1. Resource monitors track eligible credit consumption against configured budgets and actions.
  2. Tags can carry semantic classification and participate in supported governance policy assignment.
  3. Service authentication methods can avoid shared user passwords while remaining governed by roles.
  4. Future grants automate privileges for qualifying objects created after the grant is established.

Explanation

Correct Answer

B:

Tags can carry semantic classification and participate in supported governance policy assignment. This explains Tag-driven classification and masking. Correct implementation: Define governed classification tags and supported tag-based masking associations for eligible columns. Acceptance evidence: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

Incorrect Answers

A:

Resource monitors track eligible credit consumption against configured budgets and actions. This mechanism concerns Resource monitor credit threshold. The mechanism specific to Tag-driven classification and masking is: Tags can carry semantic classification and participate in supported governance policy assignment.

C:

Service authentication methods can avoid shared user passwords while remaining governed by roles. This mechanism concerns Service user key-pair authentication. The mechanism specific to Tag-driven classification and masking is: Tags can carry semantic classification and participate in supported governance policy assignment.

D:

Future grants automate privileges for qualifying objects created after the grant is established. This mechanism concerns Future grants for new tables. The mechanism specific to Tag-driven classification and masking is: Tags can carry semantic classification and participate in supported governance policy assignment.

Question 224

The project leaves the described Snowflake requirement unresolved. New customer tables repeatedly miss confidential classifications and inconsistent column masking. Which consequence is most directly related?

  1. Relying on a monthly report alone may detect cost overruns too late.
  2. Revoking ownership casually can unexpectedly alter or remove downstream grants.
  3. Ungoverned tags may create false confidence that sensitive columns are protected automatically.
  4. Password-only privileged access increases account takeover exposure.

Explanation

Correct Answer

C:

Ungoverned tags may create false confidence that sensitive columns are protected automatically. This is the direct exposure if Tag-driven classification and masking is not handled. Recommended protection: Define governed classification tags and supported tag-based masking associations for eligible columns. Validate by: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

Incorrect Answers

A:

Relying on a monthly report alone may detect cost overruns too late. This is an exposure in a separate Resource monitor credit threshold scenario. The direct failure for Tag-driven classification and masking is: Ungoverned tags may create false confidence that sensitive columns are protected automatically.

B:

Revoking ownership casually can unexpectedly alter or remove downstream grants. This is an exposure in a separate Object ownership transfer scenario. The direct failure for Tag-driven classification and masking is: Ungoverned tags may create false confidence that sensitive columns are protected automatically.

D:

Password-only privileged access increases account takeover exposure. This is an exposure in a separate Human MFA enforcement scenario. The direct failure for Tag-driven classification and masking is: Ungoverned tags may create false confidence that sensitive columns are protected automatically.

Question 225

The Snowflake implementation fails its pilot test. New customer tables repeatedly miss confidential classifications and inconsistent column masking. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect the role hierarchy, granted roles and an impersonated access test.
  2. Inspect applied tags, policy references, role evaluation and an untagged control field.
  3. Inspect policy attachment, allowed and blocked rules, login history and effective client IP.
  4. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.

Explanation

Correct Answer

B:

Inspect applied tags, policy references, role evaluation and an untagged control field. These checks diagnose Tag-driven classification and masking. Correct response: Define governed classification tags and supported tag-based masking associations for eligible columns. Expected observation: A correctly tagged sensitive field receives the intended masking behavior without manual per-table policy duplication.

Incorrect Answers

A:

Inspect the role hierarchy, granted roles and an impersonated access test. Those checks would investigate Role hierarchy inheritance, not the current Tag-driven classification and masking failure. The targeted diagnostic here is: Inspect applied tags, policy references, role evaluation and an untagged control field.

C:

Inspect policy attachment, allowed and blocked rules, login history and effective client IP. Those checks would investigate Network policy for trusted admin paths, not the current Tag-driven classification and masking failure. The targeted diagnostic here is: Inspect applied tags, policy references, role evaluation and an untagged control field.

D:

Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds. Those checks would investigate Login history versus access history, not the current Tag-driven classification and masking failure. The targeted diagnostic here is: Inspect applied tags, policy references, role evaluation and an untagged control field.

Question 226

A Snowflake implementation team encounters this specific requirement: Auditors must trace a reported metric back through transformation objects instead of trusting a spreadsheet diagram. Which action best addresses it?

  1. Use a managed access schema and delegate grant administration to the schema owner or suitable MANAGE GRANTS authority.
  2. Correlate login-history evidence with applicable query and access-history views rather than substituting one for another.
  3. Configure scoped future SELECT grants in the intended schema for the reader role.
  4. Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships.

Explanation

Correct Answer

D:

Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships. This resolves Data lineage for regulated transformations. Underlying reason: Lineage metadata represents observed or defined data dependencies for governance analysis. Verify with: A controlled report shows traceable dependencies from source tables to derived reporting objects. Boundary: Coverage and latency vary with feature support and the kinds of objects being traced.

Incorrect Answers

A:

Use a managed access schema and delegate grant administration to the schema owner or suitable MANAGE GRANTS authority. That is suitable for a different requirement, Managed access schema grants, with this separate condition: Object creators in a finance schema grant confidential views to other teams without central review.

B:

Correlate login-history evidence with applicable query and access-history views rather than substituting one for another. That is suitable for a different requirement, Login history versus access history, with this separate condition: Incident responders need to distinguish whether a suspicious identity logged in from a new address versus which tables it later read.

C:

Configure scoped future SELECT grants in the intended schema for the reader role. That is suitable for a different requirement, Future grants for new tables, with this separate condition: A BI reader can access today's curated tables but cannot query new tables created tomorrow in the same approved schema.

Question 227

After implementing a Snowflake control, the reviewer must prove the business requirement was met. Auditors must trace a reported metric back through transformation objects instead of trusting a spreadsheet diagram. Which result is the most direct acceptance evidence?

  1. Deployment succeeds using protected authentication without a password committed to version control.
  2. The reporting role inherits intended reader access without gaining unrelated writer privileges.
  3. A controlled report shows traceable dependencies from source tables to derived reporting objects.
  4. Authorized account roles gain the intended database access but not unrelated account-wide rights.

Explanation

Correct Answer

C:

A controlled report shows traceable dependencies from source tables to derived reporting objects. This directly demonstrates success for Data lineage for regulated transformations. Implementation: Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships. Mechanism: Lineage metadata represents observed or defined data dependencies for governance analysis.

Incorrect Answers

A:

Deployment succeeds using protected authentication without a password committed to version control. This outcome is evidence for the separate Service user key-pair authentication case, not the described Data lineage for regulated transformations requirement. For the current context, verify: A controlled report shows traceable dependencies from source tables to derived reporting objects.

B:

The reporting role inherits intended reader access without gaining unrelated writer privileges. This outcome is evidence for the separate Role hierarchy inheritance case, not the described Data lineage for regulated transformations requirement. For the current context, verify: A controlled report shows traceable dependencies from source tables to derived reporting objects.

D:

Authorized account roles gain the intended database access but not unrelated account-wide rights. This outcome is evidence for the separate Database role boundaries case, not the described Data lineage for regulated transformations requirement. For the current context, verify: A controlled report shows traceable dependencies from source tables to derived reporting objects.

Question 228

A Snowflake specialist explains why a proposed design works. Auditors must trace a reported metric back through transformation objects instead of trusting a spreadsheet diagram. Which technical principle is most relevant?

  1. OWNERSHIP governs object control independently of ordinary SELECT or INSERT privileges.
  2. Lineage metadata represents observed or defined data dependencies for governance analysis.
  3. Roles may inherit privileges of roles granted to them, providing reusable RBAC composition.
  4. Managed access schemas centralize privilege-grant authority separately from object ownership.

Explanation

Correct Answer

B:

Lineage metadata represents observed or defined data dependencies for governance analysis. This explains Data lineage for regulated transformations. Correct implementation: Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships. Acceptance evidence: A controlled report shows traceable dependencies from source tables to derived reporting objects.

Incorrect Answers

A:

OWNERSHIP governs object control independently of ordinary SELECT or INSERT privileges. This mechanism concerns Object ownership transfer. The mechanism specific to Data lineage for regulated transformations is: Lineage metadata represents observed or defined data dependencies for governance analysis.

C:

Roles may inherit privileges of roles granted to them, providing reusable RBAC composition. This mechanism concerns Role hierarchy inheritance. The mechanism specific to Data lineage for regulated transformations is: Lineage metadata represents observed or defined data dependencies for governance analysis.

D:

Managed access schemas centralize privilege-grant authority separately from object ownership. This mechanism concerns Managed access schema grants. The mechanism specific to Data lineage for regulated transformations is: Lineage metadata represents observed or defined data dependencies for governance analysis.

Question 229

The project leaves the described Snowflake requirement unresolved. Auditors must trace a reported metric back through transformation objects instead of trusting a spreadsheet diagram. Which consequence is most directly related?

  1. Revoking ownership casually can unexpectedly alter or remove downstream grants.
  2. Undocumented transformations can hide incorrect data sources or unauthorized downstream usage.
  3. Assigning ACCOUNTADMIN to bypass a missing USAGE grant unnecessarily broadens control.
  4. Relying on a monthly report alone may detect cost overruns too late.

Explanation

Correct Answer

B:

Undocumented transformations can hide incorrect data sources or unauthorized downstream usage. This is the direct exposure if Data lineage for regulated transformations is not handled. Recommended protection: Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships. Validate by: A controlled report shows traceable dependencies from source tables to derived reporting objects.

Incorrect Answers

A:

Revoking ownership casually can unexpectedly alter or remove downstream grants. This is an exposure in a separate Object ownership transfer scenario. The direct failure for Data lineage for regulated transformations is: Undocumented transformations can hide incorrect data sources or unauthorized downstream usage.

C:

Assigning ACCOUNTADMIN to bypass a missing USAGE grant unnecessarily broadens control. This is an exposure in a separate Least privilege with role grants scenario. The direct failure for Data lineage for regulated transformations is: Undocumented transformations can hide incorrect data sources or unauthorized downstream usage.

D:

Relying on a monthly report alone may detect cost overruns too late. This is an exposure in a separate Resource monitor credit threshold scenario. The direct failure for Data lineage for regulated transformations is: Undocumented transformations can hide incorrect data sources or unauthorized downstream usage.

Question 230

The Snowflake implementation fails its pilot test. Auditors must trace a reported metric back through transformation objects instead of trusting a spreadsheet diagram. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect object dependencies, lineage events, query history and metadata availability.
  2. Inspect SAML integration metadata, identity claims, login history and role mapping.
  3. Inspect policy attachment, allowed and blocked rules, login history and effective client IP.
  4. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.

Explanation

Correct Answer

A:

Inspect object dependencies, lineage events, query history and metadata availability. These checks diagnose Data lineage for regulated transformations. Correct response: Use supported Snowflake lineage or access-history metadata to document upstream and downstream object relationships. Expected observation: A controlled report shows traceable dependencies from source tables to derived reporting objects.

Incorrect Answers

B:

Inspect SAML integration metadata, identity claims, login history and role mapping. Those checks would investigate Federated SSO with corporate identity, not the current Data lineage for regulated transformations failure. The targeted diagnostic here is: Inspect object dependencies, lineage events, query history and metadata availability.

C:

Inspect policy attachment, allowed and blocked rules, login history and effective client IP. Those checks would investigate Network policy for trusted admin paths, not the current Data lineage for regulated transformations failure. The targeted diagnostic here is: Inspect object dependencies, lineage events, query history and metadata availability.

D:

Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds. Those checks would investigate Login history versus access history, not the current Data lineage for regulated transformations failure. The targeted diagnostic here is: Inspect object dependencies, lineage events, query history and metadata availability.

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