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 2

Question 10

A test plan evaluates: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. Which evidence should be required before release?

  1. The chosen permanent table has documented Fail-safe coverage while transient test tables do not.
  2. The selected retention setting is accepted without unsupported edition assumptions.
  3. A test query resolves the intended object using the documented naming convention.
  4. A targeted query scans fewer partitions after an appropriate data organization correction.

Explanation

Correct Answer

D:

A targeted query scans fewer partitions after an appropriate data organization correction. This validates the relevant action: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning. The underlying Snowflake behavior is: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

Incorrect Answers

A:

The chosen permanent table has documented Fail-safe coverage while transient test tables do not. This evidence tests a DIFFERENT situation: A staging team creates transient tables for reproducible data but expects the seven-day Fail-safe recovery of permanent tables. The correction required in this case is: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.

B:

The selected retention setting is accepted without unsupported edition assumptions. This evidence tests a DIFFERENT situation: A team increases Time Travel retention to 90 days on a Standard Edition account without checking edition limits. The correction required in this case is: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.

C:

A test query resolves the intended object using the documented naming convention. This evidence tests a DIFFERENT situation: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. The correction required in this case is: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.

Question 11

A Snowflake incident report notes: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. What underlying mechanism explains the behavior?

  1. Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.
  2. Fail-safe is not user-accessible historical querying; it is a Snowflake-managed recovery period.
  3. Standard Snowflake tables automatically organize data into micro-partitions rather than requiring manual file partitions.
  4. Minimum active clusters set baseline capacity and cost even with low concurrency.

Explanation

Correct Answer

A:

Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan. This explains the condition: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. The corrective response is: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.

Incorrect Answers

B:

Fail-safe is not user-accessible historical querying; it is a Snowflake-managed recovery period. That mechanism explains a DIFFERENT Snowflake problem: An analyst expects to run SELECT AT a historical timestamp after Time Travel retention has expired into Fail-safe. Here the relevant mechanism instead is: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

C:

Standard Snowflake tables automatically organize data into micro-partitions rather than requiring manual file partitions. That mechanism explains a DIFFERENT Snowflake problem: A table is manually partitioned into separate daily physical files to achieve traditional partition maintenance in regular Snowflake tables. Here the relevant mechanism instead is: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

D:

Minimum active clusters set baseline capacity and cost even with low concurrency. That mechanism explains a DIFFERENT Snowflake problem: A multi-cluster warehouse has a large fixed minimum cluster count during a quiet overnight period. Here the relevant mechanism instead is: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

Question 12

A platform governance committee considers: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. What preventive check should be standardized?

  1. Review churn and retention policies for frequently updated large tables.
  2. Monitor scanned partitions and workload patterns before adding clustering keys.
  3. Check object retention and naming before maintenance that drops important tables.
  4. Document data consistency separately from performance cache behavior.

Explanation

Correct Answer

B:

Monitor scanned partitions and workload patterns before adding clustering keys. This reduces recurrence of: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan. The verification should demonstrate: A targeted query scans fewer partitions after an appropriate data organization correction.

Incorrect Answers

A:

Review churn and retention policies for frequently updated large tables. That safeguard is aimed at ANOTHER risk: A storage report shows unexpected historical bytes after frequent updates to a large permanent table. It is less targeted than the control for: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

C:

Check object retention and naming before maintenance that drops important tables. That safeguard is aimed at ANOTHER risk: A developer asks to recover a table dropped yesterday within its configured retention window. It is less targeted than the control for: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

D:

Document data consistency separately from performance cache behavior. That safeguard is aimed at ANOTHER risk: Analysts assume moving a query to another warehouse duplicates cached results and changes the source table. It is less targeted than the control for: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.

Question 13

An engineering team investigates the following Snowflake issue: A report author creates a database object but a new role cannot see the schema despite permission on one table. Which configuration or processing decision is most appropriate?

  1. Choose a UDF for expression-style reusable computation and a procedure where supported procedural operations are required.
  2. Parse compatible JSON text to VARIANT or define the appropriate semi-structured type before path traversal.
  3. Measure active and historical storage with retention and Fail-safe costs before blaming a warehouse setting.
  4. Grant required usage privileges on the containing database and schema together with appropriate object privileges.

Explanation

Correct Answer

D:

Grant required usage privileges on the containing database and schema together with appropriate object privileges. This directly addresses the described Snowflake condition: A report author creates a database object but a new role cannot see the schema despite permission on one table. The mechanism is: Object name resolution and access depend on hierarchical container USAGE plus table privileges. Verify success using: The test role can resolve and query the intended table without broad account administrator privileges.

Incorrect Answers

A:

Choose a UDF for expression-style reusable computation and a procedure where supported procedural operations are required. That is suitable for a DIFFERENT Snowflake situation: A SQL reporting team mixes SQL UDFs and stored procedures as though both have identical invocation and side effects. It does not directly resolve the current requirement: A report author creates a database object but a new role cannot see the schema despite permission on one table.

B:

Parse compatible JSON text to VARIANT or define the appropriate semi-structured type before path traversal. That is suitable for a DIFFERENT Snowflake situation: A migration tool defines a table column as VARCHAR then assumes all JSON path operators will work on it without conversion. It does not directly resolve the current requirement: A report author creates a database object but a new role cannot see the schema despite permission on one table.

C:

Measure active and historical storage with retention and Fail-safe costs before blaming a warehouse setting. That is suitable for a DIFFERENT Snowflake situation: A storage report shows unexpected historical bytes after frequent updates to a large permanent table. It does not directly resolve the current requirement: A report author creates a database object but a new role cannot see the schema despite permission on one table.

Question 14

For a global logistics company, the original problem was: A report author creates a database object but a new role cannot see the schema despite permission on one table. What observation confirms success?

  1. The test role can resolve and query the intended table without broad account administrator privileges.
  2. A UDF call returns an expression value while the controlled procedure performs its intended procedural workflow.
  3. The analyst role can query allowed projected fields but not retrieve excluded sensitive columns.
  4. A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary.

Explanation

Correct Answer

A:

The test role can resolve and query the intended table without broad account administrator privileges. This validates the relevant action: Grant required usage privileges on the containing database and schema together with appropriate object privileges. The underlying Snowflake behavior is: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

Incorrect Answers

B:

A UDF call returns an expression value while the controlled procedure performs its intended procedural workflow. This evidence tests a DIFFERENT situation: A SQL reporting team mixes SQL UDFs and stored procedures as though both have identical invocation and side effects. The correction required in this case is: Grant required usage privileges on the containing database and schema together with appropriate object privileges.

C:

The analyst role can query allowed projected fields but not retrieve excluded sensitive columns. This evidence tests a DIFFERENT situation: An analyst uses SELECT * from a view to expose sensitive fields that should remain hidden from general users. The correction required in this case is: Grant required usage privileges on the containing database and schema together with appropriate object privileges.

D:

A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary. This evidence tests a DIFFERENT situation: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. The correction required in this case is: Grant required usage privileges on the containing database and schema together with appropriate object privileges.

Question 15

In a case affecting a global logistics company, this issue appears: A report author creates a database object but a new role cannot see the schema despite permission on one table. What explains it?

  1. Unstructured files use supported file/stage interfaces and access controls different from scalar table values.
  2. Object name resolution and access depend on hierarchical container USAGE plus table privileges.
  3. Unquoted identifiers are normalized while quoted identifiers preserve case sensitivity rules.
  4. Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

Explanation

Correct Answer

B:

Object name resolution and access depend on hierarchical container USAGE plus table privileges. This explains the condition: A report author creates a database object but a new role cannot see the schema despite permission on one table. The corrective response is: Grant required usage privileges on the containing database and schema together with appropriate object privileges.

Incorrect Answers

A:

Unstructured files use supported file/stage interfaces and access controls different from scalar table values. That mechanism explains a DIFFERENT Snowflake problem: A team stores user-uploaded images and PDFs in a regular VARCHAR column and expects Snowflake to interpret them as file objects. Here the relevant mechanism instead is: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

C:

Unquoted identifiers are normalized while quoted identifiers preserve case sensitivity rules. That mechanism explains a DIFFERENT Snowflake problem: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. Here the relevant mechanism instead is: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

D:

Text-to-SQL accuracy depends on controlled semantic definitions and database permissions. That mechanism explains a DIFFERENT Snowflake problem: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. Here the relevant mechanism instead is: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

Question 16

After remediating the Snowflake issue, the team reviews: A report author creates a database object but a new role cannot see the schema despite permission on one table. Which recurring control is most targeted?

  1. Adopt consistent identifier casing and quoting conventions in migration standards.
  2. Review view definitions and downstream role grants when schemas change.
  3. Audit object grants at database, schema and object levels.
  4. Maintain account locator and organization identity inventory for cross-region deployments.

Explanation

Correct Answer

C:

Audit object grants at database, schema and object levels. This reduces recurrence of: Object name resolution and access depend on hierarchical container USAGE plus table privileges. The verification should demonstrate: The test role can resolve and query the intended table without broad account administrator privileges.

Incorrect Answers

A:

Adopt consistent identifier casing and quoting conventions in migration standards. That safeguard is aimed at ANOTHER risk: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. It is less targeted than the control for: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

B:

Review view definitions and downstream role grants when schemas change. That safeguard is aimed at ANOTHER risk: An analyst uses SELECT * from a view to expose sensitive fields that should remain hidden from general users. It is less targeted than the control for: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

D:

Maintain account locator and organization identity inventory for cross-region deployments. That safeguard is aimed at ANOTHER risk: An application connects from a new region and assumes account-level identifiers are globally interchangeable across Snowflake organizations. It is less targeted than the control for: Object name resolution and access depend on hierarchical container USAGE plus table privileges.

Question 17

At a subscription SaaS business, a Snowflake implementation review finds: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. Which action best addresses this requirement?

  1. Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.
  2. Apply Snowflake governance policies to the source datasets and verify the model-access role's permitted rows and columns.
  3. Evaluate Cortex Analyst with a governed semantic model for structured analytic questions.
  4. Assess supported workload options and give high-frequency operational processing an explicitly managed compute strategy.

Explanation

Correct Answer

A:

Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review. This directly addresses the described Snowflake condition: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. The mechanism is: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces. Verify success using: A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary.

Incorrect Answers

B:

Apply Snowflake governance policies to the source datasets and verify the model-access role's permitted rows and columns. That is suitable for a DIFFERENT Snowflake situation: A developer combines customer and product records for an LLM app without considering masking policy and row restrictions. It does not directly resolve the current requirement: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint.

C:

Evaluate Cortex Analyst with a governed semantic model for structured analytic questions. That is suitable for a DIFFERENT Snowflake situation: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. It does not directly resolve the current requirement: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint.

D:

Assess supported workload options and give high-frequency operational processing an explicitly managed compute strategy. That is suitable for a DIFFERENT Snowflake situation: A pipeline architect puts transactional row mutation processing on an ad hoc BI query warehouse with no workload isolation. It does not directly resolve the current requirement: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint.

Question 18

After the approved change, engineers revisit: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. Which result establishes the intended state?

  1. A restricted test user sees the app's permitted data and cannot access unapproved sensitive tables.
  2. A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary.
  3. A deployment preflight succeeds in the target account or selects an approved supported alternative.
  4. Execution timing and credits improve under measured query bursts without keeping the warehouse idle all day.

Explanation

Correct Answer

B:

A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary. This validates the relevant action: Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review. The underlying Snowflake behavior is: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

Incorrect Answers

A:

A restricted test user sees the app's permitted data and cannot access unapproved sensitive tables. This evidence tests a DIFFERENT situation: A company develops an internal Streamlit data app but assumes every user should automatically see the creator's entire warehouse data. The correction required in this case is: Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.

C:

A deployment preflight succeeds in the target account or selects an approved supported alternative. This evidence tests a DIFFERENT situation: A team treats Snowflake's managed AI inference as having exactly the same regional availability for every model. The correction required in this case is: Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.

D:

Execution timing and credits improve under measured query bursts without keeping the warehouse idle all day. This evidence tests a DIFFERENT situation: A recurring report finishes in two minutes but its warehouse auto-suspends after an extremely short idle timeout between closely spaced queries. The correction required in this case is: Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.

Question 19

A root-cause investigation considers: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. What is the most applicable explanation?

  1. Model registry governance links artifact identity to deployment approvals and monitoring.
  2. AI application logic must respect Snowflake RBAC and data-governance rules on its source queries.
  3. Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.
  4. Some metadata and orchestration work is handled by cloud services, distinct from warehouse data processing.

Explanation

Correct Answer

C:

Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces. This explains the condition: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. The corrective response is: Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.

Incorrect Answers

A:

Model registry governance links artifact identity to deployment approvals and monitoring. That mechanism explains a DIFFERENT Snowflake problem: A team wants to trigger governance checks whenever a Snowflake model registry artifact changes but relies on manual emails. Here the relevant mechanism instead is: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

B:

AI application logic must respect Snowflake RBAC and data-governance rules on its source queries. That mechanism explains a DIFFERENT Snowflake problem: A developer combines customer and product records for an LLM app without considering masking policy and row restrictions. Here the relevant mechanism instead is: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

D:

Some metadata and orchestration work is handled by cloud services, distinct from warehouse data processing. That mechanism explains a DIFFERENT Snowflake problem: An application requires a low-latency metadata operation, but operations assumes every SQL statement must start a warehouse. Here the relevant mechanism instead is: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

Question 20

During operational handoff for this problem: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. Which guardrail should be included?

  1. Test generated SQL and model semantics against finance-approved calculations.
  2. Pin availability checks to target regions in AI application deployment reviews.
  3. Review min and max cluster settings against real hourly demand.
  4. Classify data and review function availability and charges before rollout.

Explanation

Correct Answer

D:

Classify data and review function availability and charges before rollout. This reduces recurrence of: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces. The verification should demonstrate: A small approved comment sample yields results while sensitive rows remain inside the approved processing boundary.

Incorrect Answers

A:

Test generated SQL and model semantics against finance-approved calculations. That safeguard is aimed at ANOTHER risk: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. It is less targeted than the control for: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

B:

Pin availability checks to target regions in AI application deployment reviews. That safeguard is aimed at ANOTHER risk: A team treats Snowflake's managed AI inference as having exactly the same regional availability for every model. It is less targeted than the control for: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.

C:

Review min and max cluster settings against real hourly demand. That safeguard is aimed at ANOTHER risk: A multi-cluster warehouse has a large fixed minimum cluster count during a quiet overnight period. It is less targeted than the control for: Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.