McAfee-Secured Website

Exam Bundle

Exam Code: SnowPro Core

Exam Name SnowPro Core

Certification Provider: Snowflake

Corresponding Certification: SnowPro Core

Snowflake SnowPro Core Bundle $44.99

100% Snowflake SnowPro Core Guaranteed Success With Testking Training Materials

Get Real SnowPro Core Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    SnowPro Core Questions & Answers

    703 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual SnowPro Core exam while allowing you to hone and measure every aspect of your test-taking ability.

  • SnowPro Core Video Course

    SnowPro Core Video Course

    92 Video Lectures

    SnowPro Core Video Course is developed by Snowflake Professionals to help you pass the SnowPro Core exam.

    Description

    This course will improve your knowledge and skills required to pass SnowPro Core exam.
  • Study Guide

    SnowPro Core Study Guide

    413 PDF Pages

    Developed by industry experts, this 413-page guide spells out in painstaking detail all of the information you need to ace SnowPro Core exam.

SnowPro Core Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    703 Questions

    $124.99
  • SnowPro Core Video Course

    Video Course

    92 Video Lectures

    $39.99
  • Study Guide

    Study Guide

    413 PDF Pages

    $29.99

Snowflake SnowPro Core Practice Test 12

Question 110

For a global logistics company, the original problem was: A regional sales analyst can read rows for every country despite having permission only for their own region. What observation confirms success?

  1. Two test roles see only their permitted country rows while a governed admin test gets its required scope.
  2. Newly tagged sensitive test columns inherit the intended masking behavior where supported.
  3. The affected identity cannot read the restricted view through any remaining authorized role chain.
  4. The report shows an explicit freshness indicator and reconciles delayed cost rows later.

Explanation

Correct Answer

A:

Two test roles see only their permitted country rows while a governed admin test gets its required scope. This validates the relevant action: Attach a row access policy using approved role/entitlement logic to filter visible records. The underlying Snowflake behavior is: Row access policies restrict result rows dynamically as SQL is executed.

Incorrect Answers

B:

Newly tagged sensitive test columns inherit the intended masking behavior where supported. This evidence tests a DIFFERENT situation: An enterprise classifies PII in columns but ignores data classification tags when assigning masking rules. The correction required in this case is: Attach a row access policy using approved role/entitlement logic to filter visible records.

C:

The affected identity cannot read the restricted view through any remaining authorized role chain. This evidence tests a DIFFERENT situation: A data steward revokes a user's role but their previous worksheet continues to query an authorized view under a different active role. The correction required in this case is: Attach a row access policy using approved role/entitlement logic to filter visible records.

D:

The report shows an explicit freshness indicator and reconciles delayed cost rows later. This evidence tests a DIFFERENT situation: A cost dashboard immediately queries ACCOUNT_USAGE views after a warehouse change and declares telemetry missing. The correction required in this case is: Attach a row access policy using approved role/entitlement logic to filter visible records.

Question 111

In a case affecting a global logistics company, this issue appears: A regional sales analyst can read rows for every country despite having permission only for their own region. What explains it?

  1. Tags can carry governance metadata and support policy-based control design.
  2. Row access policies restrict result rows dynamically as SQL is executed.
  3. Data-governance policy must account for execution and external integration boundaries, not only UI views.
  4. Repeated updates can create retained micro-partition versions billed during recovery windows.

Explanation

Correct Answer

B:

Row access policies restrict result rows dynamically as SQL is executed. This explains the condition: A regional sales analyst can read rows for every country despite having permission only for their own region. The corrective response is: Attach a row access policy using approved role/entitlement logic to filter visible records.

Incorrect Answers

A:

Tags can carry governance metadata and support policy-based control design. That mechanism explains a DIFFERENT Snowflake problem: An enterprise classifies PII in columns but ignores data classification tags when assigning masking rules. Here the relevant mechanism instead is: Row access policies restrict result rows dynamically as SQL is executed.

C:

Data-governance policy must account for execution and external integration boundaries, not only UI views. That mechanism explains a DIFFERENT Snowflake problem: An analyst creates an external function that exports restricted data even though its normal table queries are masked. Here the relevant mechanism instead is: Row access policies restrict result rows dynamically as SQL is executed.

D:

Repeated updates can create retained micro-partition versions billed during recovery windows. That mechanism explains a DIFFERENT Snowflake problem: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. Here the relevant mechanism instead is: Row access policies restrict result rows dynamically as SQL is executed.

Question 112

After remediating the Snowflake issue, the team reviews: A regional sales analyst can read rows for every country despite having permission only for their own region. Which recurring control is most targeted?

  1. Review view security properties before sharing sensitive transformation logic.
  2. Test layered access with both allowed and denied user cases.
  3. Revalidate entitlement mapping after organizational restructures.
  4. Audit highly privileged roles and replace convenience grants with scoped functional roles.

Explanation

Correct Answer

C:

Revalidate entitlement mapping after organizational restructures. This reduces recurrence of: Row access policies restrict result rows dynamically as SQL is executed. The verification should demonstrate: Two test roles see only their permitted country rows while a governed admin test gets its required scope.

Incorrect Answers

A:

Review view security properties before sharing sensitive transformation logic. That safeguard is aimed at ANOTHER risk: A contractor is granted a secure view but its definition reveals an underlying protected calculation when copied into an ordinary view. It is less targeted than the control for: Row access policies restrict result rows dynamically as SQL is executed.

B:

Test layered access with both allowed and denied user cases. That safeguard is aimed at ANOTHER risk: A security team thinks a masking policy can replace both network controls and database RBAC for a regulated dataset. It is less targeted than the control for: Row access policies restrict result rows dynamically as SQL is executed.

D:

Audit highly privileged roles and replace convenience grants with scoped functional roles. That safeguard is aimed at ANOTHER risk: A junior analyst is made ACCOUNTADMIN solely to query a departmental reporting table. It is less targeted than the control for: Row access policies restrict result rows dynamically as SQL is executed.

Question 113

At a subscription SaaS business, a Snowflake implementation review finds: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. Which action best addresses this requirement?

  1. Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified.
  2. Create approved query tags and resource ownership conventions, then analyze query and metering telemetry appropriately.
  3. Inspect query profile and warehouse cache behavior before implementing aggressive resizes.
  4. Review supported SSO federation settings and login-name/user mapping for the chosen identity provider.

Explanation

Correct Answer

A:

Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified. This directly addresses the described Snowflake condition: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. The mechanism is: Repeated updates can create retained micro-partition versions billed during recovery windows. Verify success using: Storage reports distinguish active data from historical retention usage for a representative changed table.

Incorrect Answers

B:

Create approved query tags and resource ownership conventions, then analyze query and metering telemetry appropriately. That is suitable for a DIFFERENT Snowflake situation: A finance report groups all usage by account and cannot assign cost to engineering projects sharing a warehouse. It does not directly resolve the current requirement: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates.

C:

Inspect query profile and warehouse cache behavior before implementing aggressive resizes. That is suitable for a DIFFERENT Snowflake situation: A daily report triggers many cache-missing queries after the warehouse is resized every few minutes. It does not directly resolve the current requirement: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates.

D:

Review supported SSO federation settings and login-name/user mapping for the chosen identity provider. That is suitable for a DIFFERENT Snowflake situation: A user from a federated identity provider can authenticate, but Snowflake cannot map the sign-in to the intended account user. It does not directly resolve the current requirement: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates.

Question 114

After the approved change, engineers revisit: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. Which result establishes the intended state?

  1. The warehouse stops consuming idle compute credits but retained tables still contribute to storage.
  2. Storage reports distinguish active data from historical retention usage for a representative changed table.
  3. The monitor records the designated warehouse's consumption and triggers alerts or actions at test thresholds.
  4. Test queries enforce required column protections and disallow unapproved data export paths.

Explanation

Correct Answer

B:

Storage reports distinguish active data from historical retention usage for a representative changed table. This validates the relevant action: Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified. The underlying Snowflake behavior is: Repeated updates can create retained micro-partition versions billed during recovery windows.

Incorrect Answers

A:

The warehouse stops consuming idle compute credits but retained tables still contribute to storage. This evidence tests a DIFFERENT situation: A team thinks suspending a warehouse eliminates storage and file-stage charges for inactive datasets. The correction required in this case is: Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified.

C:

The monitor records the designated warehouse's consumption and triggers alerts or actions at test thresholds. This evidence tests a DIFFERENT situation: An analyst runs many costly ad hoc queries, but no team is notified when warehouse credits exceed a monthly cap. The correction required in this case is: Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified.

D:

Test queries enforce required column protections and disallow unapproved data export paths. This evidence tests a DIFFERENT situation: An analyst creates an external function that exports restricted data even though its normal table queries are masked. The correction required in this case is: Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified.

Question 115

A root-cause investigation considers: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. What is the most applicable explanation?

  1. Resource monitors track eligible warehouse credits, not every category of Snowflake charge.
  2. Warehouse suspension does not delete persisted data or eliminate unrelated storage charges.
  3. Repeated updates can create retained micro-partition versions billed during recovery windows.
  4. Role grants create inherited privilege relationships that flow through the role hierarchy.

Explanation

Correct Answer

C:

Repeated updates can create retained micro-partition versions billed during recovery windows. This explains the condition: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. The corrective response is: Inspect storage usage including Time Travel and Fail-safe historical versions and adjust retention policy where justified.

Incorrect Answers

A:

Resource monitors track eligible warehouse credits, not every category of Snowflake charge. That mechanism explains a DIFFERENT Snowflake problem: An analyst runs many costly ad hoc queries, but no team is notified when warehouse credits exceed a monthly cap. Here the relevant mechanism instead is: Repeated updates can create retained micro-partition versions billed during recovery windows.

B:

Warehouse suspension does not delete persisted data or eliminate unrelated storage charges. That mechanism explains a DIFFERENT Snowflake problem: A team thinks suspending a warehouse eliminates storage and file-stage charges for inactive datasets. Here the relevant mechanism instead is: Repeated updates can create retained micro-partition versions billed during recovery windows.

D:

Role grants create inherited privilege relationships that flow through the role hierarchy. That mechanism explains a DIFFERENT Snowflake problem: A manager grants SELECT to a child role and expects a parent role to automatically lose that permission. Here the relevant mechanism instead is: Repeated updates can create retained micro-partition versions billed during recovery windows.

Question 116

During operational handoff for this problem: A department thinks all storage cost comes from active table bytes and ignores historical retained data from updates. Which guardrail should be included?

  1. Label telemetry recency and use validated time windows in chargeback reports.
  2. Review all billing components before claiming a workload is cost-free.
  3. Audit tag changes and the identities allowed to mutate classification metadata.
  4. Track data churn, retention and recoverability before tuning storage costs.

Explanation

Correct Answer

D:

Track data churn, retention and recoverability before tuning storage costs. This reduces recurrence of: Repeated updates can create retained micro-partition versions billed during recovery windows. The verification should demonstrate: Storage reports distinguish active data from historical retention usage for a representative changed table.

Incorrect Answers

A:

Label telemetry recency and use validated time windows in chargeback reports. That safeguard is aimed at ANOTHER risk: A cost dashboard immediately queries ACCOUNT_USAGE views after a warehouse change and declares telemetry missing. It is less targeted than the control for: Repeated updates can create retained micro-partition versions billed during recovery windows.

B:

Review all billing components before claiming a workload is cost-free. That safeguard is aimed at ANOTHER risk: A team thinks suspending a warehouse eliminates storage and file-stage charges for inactive datasets. It is less targeted than the control for: Repeated updates can create retained micro-partition versions billed during recovery windows.

C:

Audit tag changes and the identities allowed to mutate classification metadata. That safeguard is aimed at ANOTHER risk: An enterprise needs a reliable inventory of who owns sensitive schemas, but its governance tags are edited without review. It is less targeted than the control for: Repeated updates can create retained micro-partition versions billed during recovery windows.

Question 117

A data-platform team must resolve: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. Which technical change most directly solves it?

  1. Scope the stage path or filename pattern to the correct feed and verify expected input candidates.
  2. Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data.
  3. Stage the local file through a supported PUT-to-internal-stage or equivalent approved upload workflow first.
  4. Set SINGLE or equivalent supported output controls only when necessary and understand its size/throughput trade-offs.

Explanation

Correct Answer

B:

Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data. This directly addresses the described Snowflake condition: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. The mechanism is: CSV parsing depends on the declared file format, not just a .csv extension. Verify success using: A representative record maps its fields and header correctly without column shifts.

Incorrect Answers

A:

Scope the stage path or filename pattern to the correct feed and verify expected input candidates. That is suitable for a DIFFERENT Snowflake situation: A staged directory contains many unrelated feeds and COPY loads data intended for another department. It does not directly resolve the current requirement: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract.

C:

Stage the local file through a supported PUT-to-internal-stage or equivalent approved upload workflow first. That is suitable for a DIFFERENT Snowflake situation: An ingestion job expects a CSV file on a laptop to be accessible by COPY INTO immediately, without uploading it anywhere. It does not directly resolve the current requirement: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract.

D:

Set SINGLE or equivalent supported output controls only when necessary and understand its size/throughput trade-offs. That is suitable for a DIFFERENT Snowflake situation: An engineering team assumes UNLOAD generates one stable file name regardless of result size or parallel execution. It does not directly resolve the current requirement: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract.

Question 118

A Snowflake acceptance test follows this incident: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. What evidence most directly proves the correction?

  1. A least-privilege role can read the approved object prefix without SQL containing long-lived cloud secrets.
  2. The stage lists the expected file and COPY INTO can read it with the intended format.
  3. A representative record maps its fields and header correctly without column shifts.
  4. Only authorized external principals can list or download the exported test objects.

Explanation

Correct Answer

C:

A representative record maps its fields and header correctly without column shifts. This validates the relevant action: Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data. The underlying Snowflake behavior is: CSV parsing depends on the declared file format, not just a .csv extension.

Incorrect Answers

A:

A least-privilege role can read the approved object prefix without SQL containing long-lived cloud secrets. This evidence tests a DIFFERENT situation: A data lake S3 bucket is accessed using embedded access keys in a COPY script shared with contractors. The correction required in this case is: Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data.

B:

The stage lists the expected file and COPY INTO can read it with the intended format. This evidence tests a DIFFERENT situation: An ingestion job expects a CSV file on a laptop to be accessible by COPY INTO immediately, without uploading it anywhere. The correction required in this case is: Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data.

D:

Only authorized external principals can list or download the exported test objects. This evidence tests a DIFFERENT situation: An export of regulated records is written to a broadly readable cloud bucket because a script uses the default external stage. The correction required in this case is: Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data.

Question 119

The data-platform team observes: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. Which architectural or processing fact matters most?

  1. Positional and name-based column mapping are distinct file-load behaviors.
  2. Storage integrations provide controlled cloud access delegation for external stages.
  3. Event source configuration is independent of merely having a valid COPY statement inside the pipe.
  4. CSV parsing depends on the declared file format, not just a .csv extension.

Explanation

Correct Answer

D:

CSV parsing depends on the declared file format, not just a .csv extension. This explains the condition: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. The corrective response is: Define and test the correct CSV FILE FORMAT delimiter, quote and header handling for the staged data.

Incorrect Answers

A:

Positional and name-based column mapping are distinct file-load behaviors. That mechanism explains a DIFFERENT Snowflake problem: An operations analyst assumes COPY INTO will map reordered source columns correctly solely because target columns have matching names. Here the relevant mechanism instead is: CSV parsing depends on the declared file format, not just a .csv extension.

B:

Storage integrations provide controlled cloud access delegation for external stages. That mechanism explains a DIFFERENT Snowflake problem: A data lake S3 bucket is accessed using embedded access keys in a COPY script shared with contractors. Here the relevant mechanism instead is: CSV parsing depends on the declared file format, not just a .csv extension.

C:

Event source configuration is independent of merely having a valid COPY statement inside the pipe. That mechanism explains a DIFFERENT Snowflake problem: A cloud storage event notification invokes Snowpipe from a test bucket, but production bucket events point to a stale integration identifier. Here the relevant mechanism instead is: CSV parsing depends on the declared file format, not just a .csv extension.

Question 120

For a university data platform, this issue must not recur: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. Which review control fits best?

  1. Use sample files with quoted delimiters and escaped values in ingestion acceptance tests.
  2. Audit cloud trust relationships and allowed stage prefixes before onboarding new data.
  3. Validate representative nested arrays, nulls and malformed JSON before production loads.
  4. Monitor event-to-commit delay and producer file shapes.

Explanation

Correct Answer

A:

Use sample files with quoted delimiters and escaped values in ingestion acceptance tests. This reduces recurrence of: CSV parsing depends on the declared file format, not just a .csv extension. The verification should demonstrate: A representative record maps its fields and header correctly without column shifts.

Incorrect Answers

B:

Audit cloud trust relationships and allowed stage prefixes before onboarding new data. That safeguard is aimed at ANOTHER risk: A data lake S3 bucket is accessed using embedded access keys in a COPY script shared with contractors. It is less targeted than the control for: CSV parsing depends on the declared file format, not just a .csv extension.

C:

Validate representative nested arrays, nulls and malformed JSON before production loads. That safeguard is aimed at ANOTHER risk: An engineer sets JSON FILE FORMAT to CSV and loads a nested event record into a one-column raw table. It is less targeted than the control for: CSV parsing depends on the declared file format, not just a .csv extension.

D:

Monitor event-to-commit delay and producer file shapes. That safeguard is aimed at ANOTHER risk: A Snowpipe ingestion shows increasing time-to-availability after upstream sends huge compressed archives once daily. It is less targeted than the control for: CSV parsing depends on the declared file format, not just a .csv extension.