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 24

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.

Question 231

A Snowflake implementation team encounters this specific requirement: A data owner plans to share a wide customer table but has not classified sensitive fields in several new columns. Which action best addresses it?

  1. Attach a correctly configured resource monitor and threshold actions to supported warehouse resources.
  2. Run supported sensitive-data classification and review policy bindings before publishing a consumer view.
  3. Configure supported OAuth security integration and application role mapping with carefully scoped tokens.
  4. Configure scoped future SELECT grants in the intended schema for the reader role.

Explanation

Correct Answer

B:

Run supported sensitive-data classification and review policy bindings before publishing a consumer view. This resolves Sensitive data discovery before sharing. Underlying reason: Automated classification suggests sensitive data categories, while policy and human review decide exposure. Verify with: The review finds protected columns and the shared projection excludes or masks disallowed data. Boundary: Classification accuracy is not proof of lawful disclosure authorization.

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:

Configure supported OAuth security integration and application role mapping with carefully scoped tokens. That is suitable for a different requirement, OAuth delegated application tokens, with this separate condition: A web analytics service needs scoped delegated access without handling employees' primary passwords.

D:

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 232

After implementing a Snowflake control, the reviewer must prove the business requirement was met. A data owner plans to share a wide customer table but has not classified sensitive fields in several new columns. Which result is the most direct acceptance evidence?

  1. The app receives access for authorized scopes and unauthorized Snowflake objects remain protected.
  2. A controlled near-threshold test produces the expected notification or suspend action when applicable.
  3. The review finds protected columns and the shared projection excludes or masks disallowed data.
  4. Allowed test clients connect while a verified unapproved source address is denied.

Explanation

Correct Answer

C:

The review finds protected columns and the shared projection excludes or masks disallowed data. This directly demonstrates success for Sensitive data discovery before sharing. Implementation: Run supported sensitive-data classification and review policy bindings before publishing a consumer view. Mechanism: Automated classification suggests sensitive data categories, while policy and human review decide exposure.

Incorrect Answers

A:

The app receives access for authorized scopes and unauthorized Snowflake objects remain protected. This outcome is evidence for the separate OAuth delegated application tokens case, not the described Sensitive data discovery before sharing requirement. For the current context, verify: The review finds protected columns and the shared projection excludes or masks disallowed data.

B:

A controlled near-threshold test produces the expected notification or suspend action when applicable. This outcome is evidence for the separate Resource monitor credit threshold case, not the described Sensitive data discovery before sharing requirement. For the current context, verify: The review finds protected columns and the shared projection excludes or masks disallowed data.

D:

Allowed test clients connect while a verified unapproved source address is denied. This outcome is evidence for the separate Network policy for trusted admin paths case, not the described Sensitive data discovery before sharing requirement. For the current context, verify: The review finds protected columns and the shared projection excludes or masks disallowed data.

Question 233

A Snowflake specialist explains why a proposed design works. A data owner plans to share a wide customer table but has not classified sensitive fields in several new columns. Which technical principle is most relevant?

  1. Authentication telemetry and data-access telemetry record different phases of user activity.
  2. Automated classification suggests sensitive data categories, while policy and human review decide exposure.
  3. Database roles group privileges scoped to a database and are assigned through account-role inheritance paths.
  4. Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization.

Explanation

Correct Answer

B:

Automated classification suggests sensitive data categories, while policy and human review decide exposure. This explains Sensitive data discovery before sharing. Correct implementation: Run supported sensitive-data classification and review policy bindings before publishing a consumer view. Acceptance evidence: The review finds protected columns and the shared projection excludes or masks disallowed data.

Incorrect Answers

A:

Authentication telemetry and data-access telemetry record different phases of user activity. This mechanism concerns Login history versus access history. The mechanism specific to Sensitive data discovery before sharing is: Automated classification suggests sensitive data categories, while policy and human review decide exposure.

C:

Database roles group privileges scoped to a database and are assigned through account-role inheritance paths. This mechanism concerns Database role boundaries. The mechanism specific to Sensitive data discovery before sharing is: Automated classification suggests sensitive data categories, while policy and human review decide exposure.

D:

Federation separates enterprise authentication assertions from subsequent Snowflake RBAC authorization. This mechanism concerns Federated SSO with corporate identity. The mechanism specific to Sensitive data discovery before sharing is: Automated classification suggests sensitive data categories, while policy and human review decide exposure.

Question 234

The project leaves the described Snowflake requirement unresolved. A data owner plans to share a wide customer table but has not classified sensitive fields in several new columns. Which consequence is most directly related?

  1. Assuming every column is safe because no tag exists can disclose personal information.
  2. Revoking ownership casually can unexpectedly alter or remove downstream grants.
  3. Duplicating grants on every team role produces entitlement drift and difficult revocation.
  4. Broad public ingress with weak identity controls expands the account's attack surface.

Explanation

Correct Answer

A:

Assuming every column is safe because no tag exists can disclose personal information. This is the direct exposure if Sensitive data discovery before sharing is not handled. Recommended protection: Run supported sensitive-data classification and review policy bindings before publishing a consumer view. Validate by: The review finds protected columns and the shared projection excludes or masks disallowed data.

Incorrect Answers

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 Sensitive data discovery before sharing is: Assuming every column is safe because no tag exists can disclose personal information.

C:

Duplicating grants on every team role produces entitlement drift and difficult revocation. This is an exposure in a separate Role hierarchy inheritance scenario. The direct failure for Sensitive data discovery before sharing is: Assuming every column is safe because no tag exists can disclose personal information.

D:

Broad public ingress with weak identity controls expands the account's attack surface. This is an exposure in a separate Network policy for trusted admin paths scenario. The direct failure for Sensitive data discovery before sharing is: Assuming every column is safe because no tag exists can disclose personal information.

Question 235

The Snowflake implementation fails its pilot test. A data owner plans to share a wide customer table but has not classified sensitive fields in several new columns. Which evidence should be inspected first to isolate the likely cause?

  1. Inspect classification output, sample false positives, tags and consumer access tests.
  2. Inspect the role hierarchy, granted roles and an impersonated access test.
  3. Inspect effective authentication policy, identity provider behavior and login history.
  4. Compare LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY and timestamps or retention bounds.

Explanation

Correct Answer

A:

Inspect classification output, sample false positives, tags and consumer access tests. These checks diagnose Sensitive data discovery before sharing. Correct response: Run supported sensitive-data classification and review policy bindings before publishing a consumer view. Expected observation: The review finds protected columns and the shared projection excludes or masks disallowed data.

Incorrect Answers

B:

Inspect the role hierarchy, granted roles and an impersonated access test. Those checks would investigate Role hierarchy inheritance, not the current Sensitive data discovery before sharing failure. The targeted diagnostic here is: Inspect classification output, sample false positives, tags and consumer access tests.

C:

Inspect effective authentication policy, identity provider behavior and login history. Those checks would investigate Human MFA enforcement, not the current Sensitive data discovery before sharing failure. The targeted diagnostic here is: Inspect classification output, sample false positives, tags and consumer access tests.

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 Sensitive data discovery before sharing failure. The targeted diagnostic here is: Inspect classification output, sample false positives, tags and consumer access tests.

Question 236

A Snowflake implementation team encounters this specific requirement: An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail. Which action best addresses it?

  1. Attach a context-aware masking policy to the sensitive column using supported role conditions.
  2. Use a managed access schema and delegate grant administration to the schema owner or suitable MANAGE GRANTS authority.
  3. Configure scoped future SELECT grants in the intended schema for the reader role.
  4. Attach a correctly configured resource monitor and threshold actions to supported warehouse resources.

Explanation

Correct Answer

D:

Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. This resolves Resource monitor credit threshold. Underlying reason: Resource monitors track eligible credit consumption against configured budgets and actions. Verify with: A controlled near-threshold test produces the expected notification or suspend action when applicable. Boundary: Not all Snowflake credit categories are governed by warehouse resource monitors.

Incorrect Answers

A:

Attach a context-aware masking policy to the sensitive column using supported role conditions. That is suitable for a different requirement, Dynamic column masking, with this separate condition: Support engineers can troubleshoot transactions but should see redacted account numbers unless specifically approved.

B:

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.

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 237

After implementing a Snowflake control, the reviewer must prove the business requirement was met. An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail. Which result is the most direct acceptance evidence?

  1. A protected human session requires the expected additional factor and authentication logs reflect the method.
  2. A controlled near-threshold test produces the expected notification or suspend action when applicable.
  3. A session using that role reads the target table but cannot access unrelated tables.
  4. An ordinary role sees masked values and an approved role sees permitted clear data.

Explanation

Correct Answer

B:

A controlled near-threshold test produces the expected notification or suspend action when applicable. This directly demonstrates success for Resource monitor credit threshold. Implementation: Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. Mechanism: Resource monitors track eligible credit consumption against configured budgets and actions.

Incorrect Answers

A:

A protected human session requires the expected additional factor and authentication logs reflect the method. This outcome is evidence for the separate Human MFA enforcement case, not the described Resource monitor credit threshold requirement. For the current context, verify: A controlled near-threshold test produces the expected notification or suspend action when applicable.

C:

A session using that role reads the target table but cannot access unrelated tables. This outcome is evidence for the separate Least privilege with role grants case, not the described Resource monitor credit threshold requirement. For the current context, verify: A controlled near-threshold test produces the expected notification or suspend action when applicable.

D:

An ordinary role sees masked values and an approved role sees permitted clear data. This outcome is evidence for the separate Dynamic column masking case, not the described Resource monitor credit threshold requirement. For the current context, verify: A controlled near-threshold test produces the expected notification or suspend action when applicable.

Question 238

A Snowflake specialist explains why a proposed design works. An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail. Which technical principle is most relevant?

  1. Snowflake access checks applicable privileges on the object and its containing namespaces.
  2. OAuth delegates authorization using scoped tokens subject to Snowflake role privileges.
  3. Roles may inherit privileges of roles granted to them, providing reusable RBAC composition.
  4. Resource monitors track eligible credit consumption against configured budgets and actions.

Explanation

Correct Answer

D:

Resource monitors track eligible credit consumption against configured budgets and actions. This explains Resource monitor credit threshold. Correct implementation: Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. Acceptance evidence: A controlled near-threshold test produces the expected notification or suspend action when applicable.

Incorrect Answers

A:

Snowflake access checks applicable privileges on the object and its containing namespaces. This mechanism concerns Least privilege with role grants. The mechanism specific to Resource monitor credit threshold is: Resource monitors track eligible credit consumption against configured budgets and actions.

B:

OAuth delegates authorization using scoped tokens subject to Snowflake role privileges. This mechanism concerns OAuth delegated application tokens. The mechanism specific to Resource monitor credit threshold is: Resource monitors track eligible credit consumption against configured budgets and actions.

C:

Roles may inherit privileges of roles granted to them, providing reusable RBAC composition. This mechanism concerns Role hierarchy inheritance. The mechanism specific to Resource monitor credit threshold is: Resource monitors track eligible credit consumption against configured budgets and actions.

Question 239

The project leaves the described Snowflake requirement unresolved. An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail. Which consequence is most directly related?

  1. Relying on a monthly report alone may detect cost overruns too late.
  2. A leaked hard-coded password can enable unauthorized access until revoked.
  3. Treating SSO as a replacement for object grants can leave broad or denied data access.
  4. Copying long-lived human credentials into an app bypasses token lifecycle controls.

Explanation

Correct Answer

A:

Relying on a monthly report alone may detect cost overruns too late. This is the direct exposure if Resource monitor credit threshold is not handled. Recommended protection: Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. Validate by: A controlled near-threshold test produces the expected notification or suspend action when applicable.

Incorrect Answers

B:

A leaked hard-coded password can enable unauthorized access until revoked. This is an exposure in a separate Service user key-pair authentication scenario. The direct failure for Resource monitor credit threshold is: Relying on a monthly report alone may detect cost overruns too late.

C:

Treating SSO as a replacement for object grants can leave broad or denied data access. This is an exposure in a separate Federated SSO with corporate identity scenario. The direct failure for Resource monitor credit threshold is: Relying on a monthly report alone may detect cost overruns too late.

D:

Copying long-lived human credentials into an app bypasses token lifecycle controls. This is an exposure in a separate OAuth delegated application tokens scenario. The direct failure for Resource monitor credit threshold is: Relying on a monthly report alone may detect cost overruns too late.

Question 240

The Snowflake implementation fails its pilot test. An ad hoc warehouse consumes far more credits than allocated and the team wants an automated spending guardrail. 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. Inspect resource monitor scope, usage totals, threshold actions and suspension events.
  4. Inspect applied tags, policy references, role evaluation and an untagged control field.

Explanation

Correct Answer

C:

Inspect resource monitor scope, usage totals, threshold actions and suspension events. These checks diagnose Resource monitor credit threshold. Correct response: Attach a correctly configured resource monitor and threshold actions to supported warehouse resources. Expected observation: A controlled near-threshold test produces the expected notification or suspend action when applicable.

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 Resource monitor credit threshold failure. The targeted diagnostic here is: Inspect resource monitor scope, usage totals, threshold actions and suspension events.

B:

Inspect classification output, sample false positives, tags and consumer access tests. Those checks would investigate Sensitive data discovery before sharing, not the current Resource monitor credit threshold failure. The targeted diagnostic here is: Inspect resource monitor scope, usage totals, threshold actions and suspension events.

D:

Inspect applied tags, policy references, role evaluation and an untagged control field. Those checks would investigate Tag-driven classification and masking, not the current Resource monitor credit threshold failure. The targeted diagnostic here is: Inspect resource monitor scope, usage totals, threshold actions and suspension events.

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