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 20

Question 190

The Snowflake implementation fails its pilot test. A CI integration currently embeds a reusable plain-text password in its source repository. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect object dependencies, lineage events, query history and metadata availability.
  2. Inspect classification output, sample false positives, tags and consumer access tests.
  3. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.
  4. Inspect user type, public key metadata, authentication logs and secret storage.

Explanation

Correct Answer

D:

Inspect user type, public key metadata, authentication logs and secret storage. These checks diagnose Service user key-pair authentication. Correct response: Use a supported key-pair or OAuth service authentication method and protect or rotate credentials. Expected observation: Deployment succeeds using protected authentication without a password committed to version control.

Incorrect Answers

A:

Inspect object dependencies, lineage events, query history and metadata availability. Those checks would investigate Data lineage for regulated transformations, not the current Service user key-pair authentication failure. The targeted diagnostic here is: Inspect user type, public key metadata, authentication logs and secret storage.

B:

Inspect classification output, sample false positives, tags and consumer access tests. Those checks would investigate Sensitive data discovery before sharing, not the current Service user key-pair authentication failure. The targeted diagnostic here is: Inspect user type, public key metadata, authentication logs and secret storage.

C:

Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds. Those checks would investigate Login history versus access history, not the current Service user key-pair authentication failure. The targeted diagnostic here is: Inspect user type, public key metadata, authentication logs and secret storage.

Question 191

A Snowflake implementation team encounters this specific requirement: Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy. Which action best addresses it?

  1. Define governed classification tags and supported tag-based masking associations for eligible columns.
  2. Correlate login-history evidence with applicable query and access-history views rather than substituting one for another.
  3. Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions.
  4. Use a managed access schema and delegate grant administration to the schema owner or suitable MANAGE GRANTS authority.

Explanation

Correct Answer

C:

Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. This resolves Human MFA enforcement. Underlying reason: Authentication policies constrain allowed login mechanisms separately from object authorization. Verify with: A protected human session requires the expected additional factor and authentication logs reflect the method. Boundary: Rollout may differ by user type, exception class and current Snowflake enforcement phases.

Incorrect Answers

A:

Define governed classification tags and supported tag-based masking associations for eligible columns. That is suitable for a different requirement, Tag-driven classification and masking, with this separate condition: New customer tables repeatedly miss confidential classifications and inconsistent column masking.

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.

D:

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.

Question 192

After implementing a Snowflake control, the reviewer must prove the business requirement was met. Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy. Which result is the most direct acceptance evidence?

  1. The incident timeline separately identifies authentication and subsequent object-access events.
  2. The replacement owner performs authorized DDL and existing authorized consumers are not accidentally stranded.
  3. A protected human session requires the expected additional factor and authentication logs reflect the method.
  4. A controlled report shows traceable dependencies from source tables to derived reporting objects.

Explanation

Correct Answer

C:

A protected human session requires the expected additional factor and authentication logs reflect the method. This directly demonstrates success for Human MFA enforcement. Implementation: Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. Mechanism: Authentication policies constrain allowed login mechanisms separately from object authorization.

Incorrect Answers

A:

The incident timeline separately identifies authentication and subsequent object-access events. This outcome is evidence for the separate Login history versus access history case, not the described Human MFA enforcement requirement. For the current context, verify: A protected human session requires the expected additional factor and authentication logs reflect the method.

B:

The replacement owner performs authorized DDL and existing authorized consumers are not accidentally stranded. This outcome is evidence for the separate Object ownership transfer case, not the described Human MFA enforcement requirement. For the current context, verify: A protected human session requires the expected additional factor and authentication logs reflect the method.

D:

A controlled report shows traceable dependencies from source tables to derived reporting objects. This outcome is evidence for the separate Data lineage for regulated transformations case, not the described Human MFA enforcement requirement. For the current context, verify: A protected human session requires the expected additional factor and authentication logs reflect the method.

Question 193

A Snowflake specialist explains why a proposed design works. Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy. Which technical principle is most relevant?

  1. Managed access schemas centralize privilege-grant authority separately from object ownership.
  2. Authentication policies constrain allowed login mechanisms separately from object authorization.
  3. Masking policies transform or restrict column values at query time according to policy context.
  4. Automated classification suggests sensitive data categories, while policy and human review decide exposure.

Explanation

Correct Answer

B:

Authentication policies constrain allowed login mechanisms separately from object authorization. This explains Human MFA enforcement. Correct implementation: Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. Acceptance evidence: A protected human session requires the expected additional factor and authentication logs reflect the method.

Incorrect Answers

A:

Managed access schemas centralize privilege-grant authority separately from object ownership. This mechanism concerns Managed access schema grants. The mechanism specific to Human MFA enforcement is: Authentication policies constrain allowed login mechanisms separately from object authorization.

C:

Masking policies transform or restrict column values at query time according to policy context. This mechanism concerns Dynamic column masking. The mechanism specific to Human MFA enforcement is: Authentication policies constrain allowed login mechanisms separately from object authorization.

D:

Automated classification suggests sensitive data categories, while policy and human review decide exposure. This mechanism concerns Sensitive data discovery before sharing. The mechanism specific to Human MFA enforcement is: Authentication policies constrain allowed login mechanisms separately from object authorization.

Question 194

The project leaves the described Snowflake requirement unresolved. Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy. Which consequence is most directly related?

  1. Applying broad future grants at account scope can unintentionally expose new sensitive datasets.
  2. Separate dashboards alone do not prevent ad hoc SQL from reading other regions.
  3. Granting table SELECT without column protection can disclose sensitive financial identifiers.
  4. Password-only privileged access increases account takeover exposure.

Explanation

Correct Answer

D:

Password-only privileged access increases account takeover exposure. This is the direct exposure if Human MFA enforcement is not handled. Recommended protection: Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. Validate by: A protected human session requires the expected additional factor and authentication logs reflect the method.

Incorrect Answers

A:

Applying broad future grants at account scope can unintentionally expose new sensitive datasets. This is an exposure in a separate Future grants for new tables scenario. The direct failure for Human MFA enforcement is: Password-only privileged access increases account takeover exposure.

B:

Separate dashboards alone do not prevent ad hoc SQL from reading other regions. This is an exposure in a separate Row-level regional access scenario. The direct failure for Human MFA enforcement is: Password-only privileged access increases account takeover exposure.

C:

Granting table SELECT without column protection can disclose sensitive financial identifiers. This is an exposure in a separate Dynamic column masking scenario. The direct failure for Human MFA enforcement is: Password-only privileged access increases account takeover exposure.

Question 195

The Snowflake implementation fails its pilot test. Human users still authenticate with only a password to a privileged Snowflake account, despite organizational MFA policy. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect effective authentication policy, identity provider behavior and login history.
  2. Inspect object dependencies, lineage events, query history and metadata availability.
  3. Inspect SHOW DATABASE ROLES, database grants and role inheritance results.
  4. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.

Explanation

Correct Answer

A:

Inspect effective authentication policy, identity provider behavior and login history. These checks diagnose Human MFA enforcement. Correct response: Apply current Snowflake-supported strong authentication and MFA policy for human identities with approved exceptions. Expected observation: A protected human session requires the expected additional factor and authentication logs reflect the method.

Incorrect Answers

B:

Inspect object dependencies, lineage events, query history and metadata availability. Those checks would investigate Data lineage for regulated transformations, not the current Human MFA enforcement failure. The targeted diagnostic here is: Inspect effective authentication policy, identity provider behavior and login history.

C:

Inspect SHOW DATABASE ROLES, database grants and role inheritance results. Those checks would investigate Database role boundaries, not the current Human MFA enforcement failure. The targeted diagnostic here is: Inspect effective authentication policy, identity provider behavior and login history.

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 Human MFA enforcement failure. The targeted diagnostic here is: Inspect effective authentication policy, identity provider behavior and login history.

Question 196

A Snowflake implementation team encounters this specific requirement: A company wants employees to authenticate using its corporate identity provider instead of local passwords. Which action best addresses it?

  1. Attach a correctly configured resource monitor and threshold actions to supported warehouse resources.
  2. Configure supported SAML federation and validate identity attribute mappings and login routing.
  3. Attach an authorized row access policy using region and role-to-region mapping.
  4. Grant the reader role to the reporting role following the approved account role hierarchy.

Explanation

Correct Answer

B:

Configure supported SAML federation and validate identity attribute mappings and login routing. This resolves Federated SSO with corporate identity. Underlying reason: Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization. Verify with: A test user signs in through the approved IdP and receives the intended Snowflake identity. Boundary: IdP availability and account recovery paths need a documented contingency.

Incorrect Answers

A:

Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. That is suitable for a different requirement, Resource monitor credit threshold, with this separate condition: An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail.

C:

Attach an authorized row access policy using region and role-to-region mapping. That is suitable for a different requirement, Row-level regional access, with this separate condition: Managers in EMEA must see only EMEA customer records from a shared sales table even though all use the same dashboard.

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 197

After implementing a Snowflake control, the reviewer must prove the business requirement was met. A company wants employees to authenticate using its corporate identity provider instead of local passwords. Which result is the most direct acceptance evidence?

  1. EMEA and Americas test roles receive only their intended regions from the same SELECT.
  2. A test user signs in through the approved IdP and receives the intended Snowflake identity.
  3. Representative queries contain the expected application labels in query history.
  4. A controlled report shows traceable dependencies from source tables to derived reporting objects.

Explanation

Correct Answer

B:

A test user signs in through the approved IdP and receives the intended Snowflake identity. This directly demonstrates success for Federated SSO with corporate identity. Implementation: Configure supported SAML federation and validate identity attribute mappings and login routing. Mechanism: Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.

Incorrect Answers

A:

EMEA and Americas test roles receive only their intended regions from the same SELECT. This outcome is evidence for the separate Row-level regional access case, not the described Federated SSO with corporate identity requirement. For the current context, verify: A test user signs in through the approved IdP and receives the intended Snowflake identity.

C:

Representative queries contain the expected application labels in query history. This outcome is evidence for the separate Query tagging for audit trail case, not the described Federated SSO with corporate identity requirement. For the current context, verify: A test user signs in through the approved IdP and receives the intended Snowflake identity.

D:

A controlled report shows traceable dependencies from source tables to derived reporting objects. This outcome is evidence for the separate Data lineage for regulated transformations case, not the described Federated SSO with corporate identity requirement. For the current context, verify: A test user signs in through the approved IdP and receives the intended Snowflake identity.

Question 198

A Snowflake specialist explains why a proposed design works. A company wants employees to authenticate using its corporate identity provider instead of local passwords. Which technical principle is most relevant?

  1. Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.
  2. Authentication telemetry and data-access telemetry record different phases of user activity.
  3. Tags can carry semantic classification and participate in supported governance policy assignment.
  4. OWNERSHIP governs object control independently of ordinary SELECT or INSERT privileges.

Explanation

Correct Answer

A:

Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization. This explains Federated SSO with corporate identity. Correct implementation: Configure supported SAML federation and validate identity attribute mappings and login routing. Acceptance evidence: A test user signs in through the approved IdP and receives the intended Snowflake identity.

Incorrect Answers

B:

Authentication telemetry and data-access telemetry record different phases of user activity. This mechanism concerns Login history versus access history. The mechanism specific to Federated SSO with corporate identity is: Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.

C:

Tags can carry semantic classification and participate in supported governance policy assignment. This mechanism concerns Tag-driven classification and masking. The mechanism specific to Federated SSO with corporate identity is: Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.

D:

OWNERSHIP governs object control independently of ordinary SELECT or INSERT privileges. This mechanism concerns Object ownership transfer. The mechanism specific to Federated SSO with corporate identity is: Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.

Question 199

The project leaves the described Snowflake requirement unresolved. A company wants employees to authenticate using its corporate identity provider instead of local passwords. Which consequence is most directly related?

  1. Revoking ownership casually can unexpectedly alter or remove downstream grants.
  2. Using one global administrative role for every database creates unnecessary reachability.
  3. Treating SSO as a replacement for object grants can leave broad or denied data access.
  4. Separate dashboards alone do not prevent ad hoc SQL from reading other regions.

Explanation

Correct Answer

C:

Treating SSO as a replacement for object grants can leave broad or denied data access. This is the direct exposure if Federated SSO with corporate identity is not handled. Recommended protection: Configure supported SAML federation and validate identity attribute mappings and login routing. Validate by: A test user signs in through the approved IdP and receives the intended Snowflake identity.

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 Federated SSO with corporate identity is: Treating SSO as a replacement for object grants can leave broad or denied data access.

B:

Using one global administrative role for every database creates unnecessary reachability. This is an exposure in a separate Database role boundaries scenario. The direct failure for Federated SSO with corporate identity is: Treating SSO as a replacement for object grants can leave broad or denied data access.

D:

Separate dashboards alone do not prevent ad hoc SQL from reading other regions. This is an exposure in a separate Row-level regional access scenario. The direct failure for Federated SSO with corporate identity is: Treating SSO as a replacement for object grants can leave broad or denied data access.

Question 200

The Snowflake implementation fails its pilot test. A company wants employees to authenticate using its corporate identity provider instead of local passwords. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect object dependencies, lineage events, query history and metadata availability.
  2. Inspect applied tags, policy references, role evaluation and an untagged control field.
  3. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.
  4. Inspect SAML integration metadata, identity claims, login history and role mapping.

Explanation

Correct Answer

D:

Inspect SAML integration metadata, identity claims, login history and role mapping. These checks diagnose Federated SSO with corporate identity. Correct response: Configure supported SAML federation and validate identity attribute mappings and login routing. Expected observation: A test user signs in through the approved IdP and receives the intended Snowflake identity.

Incorrect Answers

A:

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

B:

Inspect applied tags, policy references, role evaluation and an untagged control field. Those checks would investigate Tag-driven classification and masking, not the current Federated SSO with corporate identity failure. The targeted diagnostic here is: Inspect SAML integration metadata, identity claims, login history and role mapping.

C:

Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds. Those checks would investigate Login history versus access history, not the current Federated SSO with corporate identity failure. The targeted diagnostic here is: Inspect SAML integration metadata, identity claims, login history and role mapping.

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