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 18

Question 170

A test plan evaluates: A developer asks to recover a table dropped yesterday within its configured retention window. Which evidence should be required before release?

  1. Time-filtered SQL queries prune eligible partitions without user-maintained folder partition definitions.
  2. A region-level outage drill has an independent approved recovery path rather than relying on a local clone.
  3. Execution timing and credits improve under measured query bursts without keeping the warehouse idle all day.
  4. Recovered table data matches the point within its permitted Time Travel retention window.

Explanation

Correct Answer

D:

Recovered table data matches the point within its permitted Time Travel retention window. This validates the relevant action: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts. The underlying Snowflake behavior is: Time Travel supports recovery of dropped supported objects while their retention remains valid.

Incorrect Answers

A:

Time-filtered SQL queries prune eligible partitions without user-maintained folder partition definitions. This evidence tests a DIFFERENT situation: A table is manually partitioned into separate daily physical files to achieve traditional partition maintenance in regular Snowflake tables. The correction required in this case is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.

B:

A region-level outage drill has an independent approved recovery path rather than relying on a local clone. This evidence tests a DIFFERENT situation: A data steward uses a zero-copy clone as a replacement for a remote recovery copy in a separate cloud region. The correction required in this case is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.

C:

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: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.

Question 171

A Snowflake incident report notes: A developer asks to recover a table dropped yesterday within its configured retention window. What underlying mechanism explains the behavior?

  1. Time Travel supports recovery of dropped supported objects while their retention remains valid.
  2. Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.
  3. Extended Time Travel retention for permanent objects depends on edition entitlement and limits.
  4. Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage.

Explanation

Correct Answer

A:

Time Travel supports recovery of dropped supported objects while their retention remains valid. This explains the condition: A developer asks to recover a table dropped yesterday within its configured retention window. The corrective response is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.

Incorrect Answers

B:

Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan. That mechanism explains a DIFFERENT Snowflake problem: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. Here the relevant mechanism instead is: Time Travel supports recovery of dropped supported objects while their retention remains valid.

C:

Extended Time Travel retention for permanent objects depends on edition entitlement and limits. That mechanism explains a DIFFERENT Snowflake problem: A team increases Time Travel retention to 90 days on a Standard Edition account without checking edition limits. Here the relevant mechanism instead is: Time Travel supports recovery of dropped supported objects while their retention remains valid.

D:

Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage. That mechanism explains a DIFFERENT Snowflake problem: A pipeline architect puts transactional row mutation processing on an ad hoc BI query warehouse with no workload isolation. Here the relevant mechanism instead is: Time Travel supports recovery of dropped supported objects while their retention remains valid.

Question 172

A platform governance committee considers: A developer asks to recover a table dropped yesterday within its configured retention window. What preventive check should be standardized?

  1. Capture incident timestamps and retention deadlines when recovering data changes.
  2. Check object retention and naming before maintenance that drops important tables.
  3. Monitor scanned partitions and workload patterns before adding clustering keys.
  4. Audit registry versions and deployment history at every release.

Explanation

Correct Answer

B:

Check object retention and naming before maintenance that drops important tables. This reduces recurrence of: Time Travel supports recovery of dropped supported objects while their retention remains valid. The verification should demonstrate: Recovered table data matches the point within its permitted Time Travel retention window.

Incorrect Answers

A:

Capture incident timestamps and retention deadlines when recovering data changes. That safeguard is aimed at ANOTHER risk: A team wants a historical snapshot of a supported table at the state before a mistaken DELETE within retention. It is less targeted than the control for: Time Travel supports recovery of dropped supported objects while their retention remains valid.

C:

Monitor scanned partitions and workload patterns before adding clustering keys. That safeguard is aimed at ANOTHER risk: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. It is less targeted than the control for: Time Travel supports recovery of dropped supported objects while their retention remains valid.

D:

Audit registry versions and deployment history at every release. That safeguard is aimed at ANOTHER risk: A team wants to trigger governance checks whenever a Snowflake model registry artifact changes but relies on manual emails. It is less targeted than the control for: Time Travel supports recovery of dropped supported objects while their retention remains valid.

Question 173

An engineering team investigates the following Snowflake issue: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. Which configuration or processing decision is most appropriate?

  1. Use consistent normal identifiers or quote case-sensitive identifiers deliberately in SQL and connectors.
  2. Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement.
  3. Enable AUTO_SUSPEND after an appropriate idle interval and AUTO_RESUME for the job warehouse.
  4. Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use.

Explanation

Correct Answer

D:

Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use. This directly addresses the described Snowflake condition: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. The mechanism is: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes. Verify success using: Representative varied JSON payloads load without adding a column for each optional key.

Incorrect Answers

A:

Use consistent normal identifiers or quote case-sensitive identifiers deliberately in SQL and connectors. That is suitable for a DIFFERENT Snowflake situation: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. It does not directly resolve the current requirement: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties.

B:

Choose a dynamic table only when a target-lag refresh model suits the pipeline requirement. That is suitable for a DIFFERENT Snowflake situation: An engineer creates a dynamic table with a SELECT query and assumes it behaves like a normal manually written snapshot table. It does not directly resolve the current requirement: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties.

C:

Enable AUTO_SUSPEND after an appropriate idle interval and AUTO_RESUME for the job warehouse. That is suitable for a DIFFERENT Snowflake situation: A scheduled workload runs briefly every hour, but its dedicated warehouse remains running between jobs. It does not directly resolve the current requirement: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties.

Question 174

For a telecommunications provider, the original problem was: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. What observation confirms success?

  1. Representative varied JSON payloads load without adding a column for each optional key.
  2. A sample metadata refresh or write follows the chosen catalog ownership and supported permissions.
  3. A controlled document is referenced through the approved stage workflow and accessed according to permissions.
  4. At low demand one cluster runs; during queued demand extra clusters start within the configured maximum.

Explanation

Correct Answer

A:

Representative varied JSON payloads load without adding a column for each optional key. This validates the relevant action: Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use. The underlying Snowflake behavior is: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

Incorrect Answers

B:

A sample metadata refresh or write follows the chosen catalog ownership and supported permissions. This evidence tests a DIFFERENT situation: An application developer assumes an external Iceberg catalog table is administered identically to a native Snowflake-managed table. The correction required in this case is: Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use.

C:

A controlled document is referenced through the approved stage workflow and accessed according to permissions. This evidence tests a DIFFERENT situation: A team stores user-uploaded images and PDFs in a regular VARCHAR column and expects Snowflake to interpret them as file objects. The correction required in this case is: Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use.

D:

At low demand one cluster runs; during queued demand extra clusters start within the configured maximum. This evidence tests a DIFFERENT situation: A team sets MAX_CLUSTER_COUNT to four but leaves MIN_CLUSTER_COUNT at one and expects four clusters to run continuously. The correction required in this case is: Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use.

Question 175

In a case affecting a telecommunications provider, this issue appears: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. What explains it?

  1. Dynamic tables maintain query-defined results through Snowflake refresh management.
  2. VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.
  3. Views can provide a controlled logical interface over underlying table data.
  4. Model registry governance links artifact identity to deployment approvals and monitoring.

Explanation

Correct Answer

B:

VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes. This explains the condition: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. The corrective response is: Store raw semi-structured payloads in VARIANT where appropriate and derive typed fields for analytic use.

Incorrect Answers

A:

Dynamic tables maintain query-defined results through Snowflake refresh management. That mechanism explains a DIFFERENT Snowflake problem: An engineer creates a dynamic table with a SELECT query and assumes it behaves like a normal manually written snapshot table. Here the relevant mechanism instead is: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

C:

Views can provide a controlled logical interface over underlying table data. That mechanism explains a DIFFERENT Snowflake problem: An analyst uses SELECT * from a view to expose sensitive fields that should remain hidden from general users. Here the relevant mechanism instead is: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

D:

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: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

Question 176

After remediating the Snowflake issue, the team reviews: A developer wants to store variable nested JSON documents but designs dozens of nullable columns for unknown future properties. Which recurring control is most targeted?

  1. Record catalog ownership and compatibility tests for Iceberg integrations.
  2. Review package/network permissions and cost before adopting new Snowpark processing.
  3. Establish typed projection and data-quality rules for important JSON attributes.
  4. Monitor scanned partitions and workload patterns before adding clustering keys.

Explanation

Correct Answer

C:

Establish typed projection and data-quality rules for important JSON attributes. This reduces recurrence of: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes. The verification should demonstrate: Representative varied JSON payloads load without adding a column for each optional key.

Incorrect Answers

A:

Record catalog ownership and compatibility tests for Iceberg integrations. That safeguard is aimed at ANOTHER risk: An application developer assumes an external Iceberg catalog table is administered identically to a native Snowflake-managed table. It is less targeted than the control for: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

B:

Review package/network permissions and cost before adopting new Snowpark processing. That safeguard is aimed at ANOTHER risk: A data science app requires Python transformations close to governed Snowflake tables but engineers plan repeated external exports. It is less targeted than the control for: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

D:

Monitor scanned partitions and workload patterns before adding clustering keys. That safeguard is aimed at ANOTHER risk: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. It is less targeted than the control for: VARIANT can store and query semi-structured content while schema-on-read extracts nested attributes.

Question 177

At a consumer marketplace, a Snowflake implementation review finds: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. Which action best addresses this requirement?

  1. Evaluate Cortex Analyst with a governed semantic model for structured analytic questions.
  2. Evaluate a supported Cortex Search service for semantic retrieval over approved document text and metadata.
  3. Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review.
  4. Assess supported workload options and give high-frequency operational processing an explicitly managed compute strategy.

Explanation

Correct Answer

A:

Evaluate Cortex Analyst with a governed semantic model for structured analytic questions. This directly addresses the described Snowflake condition: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. The mechanism is: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions. Verify success using: A pilot maps representative natural-language revenue questions to valid SQL based on approved definitions.

Incorrect Answers

B:

Evaluate a supported Cortex Search service for semantic retrieval over approved document text and metadata. That is suitable for a DIFFERENT Snowflake situation: An AI team expects an enterprise search feature to be built by sorting all documents by their file names. It does not directly resolve the current requirement: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins.

C:

Evaluate an available governed Snowflake Cortex AI function for permitted text analysis after access and cost review. That is suitable for a DIFFERENT Snowflake situation: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. It does not directly resolve the current requirement: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins.

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 business team asks an LLM to answer revenue questions but the model frequently invents column names and joins.

Question 178

After the approved change, engineers revisit: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. Which result establishes the intended state?

  1. A least-privilege test session sees only authorized records while the application still performs its expected task.
  2. A pilot maps representative natural-language revenue questions to valid SQL based on approved definitions.
  3. A restricted test user sees the app's permitted data and cannot access unapproved sensitive tables.
  4. The selected retention setting is accepted without unsupported edition assumptions.

Explanation

Correct Answer

B:

A pilot maps representative natural-language revenue questions to valid SQL based on approved definitions. This validates the relevant action: Evaluate Cortex Analyst with a governed semantic model for structured analytic questions. The underlying Snowflake behavior is: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

Incorrect Answers

A:

A least-privilege test session sees only authorized records while the application still performs its expected task. This evidence tests a DIFFERENT situation: A developer combines customer and product records for an LLM app without considering masking policy and row restrictions. The correction required in this case is: Evaluate Cortex Analyst with a governed semantic model for structured analytic questions.

C:

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 Cortex Analyst with a governed semantic model for structured analytic questions.

D:

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: Evaluate Cortex Analyst with a governed semantic model for structured analytic questions.

Question 179

A root-cause investigation considers: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. What is the most applicable explanation?

  1. AI function usage can create distinct consumption costs that require their own monitoring.
  2. Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces.
  3. Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.
  4. Cloning shares region-local storage constructs and is not equivalent to cross-region disaster recovery.

Explanation

Correct Answer

C:

Text-to-SQL accuracy depends on controlled semantic definitions and database permissions. This explains the condition: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. The corrective response is: Evaluate Cortex Analyst with a governed semantic model for structured analytic questions.

Incorrect Answers

A:

AI function usage can create distinct consumption costs that require their own monitoring. That mechanism explains a DIFFERENT Snowflake problem: An internal AI pilot is evaluated only on output quality while unbounded model calls inflate consumption charges. Here the relevant mechanism instead is: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

B:

Supported Cortex AI functions can provide managed model operations through Snowflake SQL interfaces. That mechanism explains a DIFFERENT Snowflake problem: A department wants sentiment analysis in SQL but proposes shipping every customer comment to an ungoverned third-party endpoint. Here the relevant mechanism instead is: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

D:

Cloning shares region-local storage constructs and is not equivalent to cross-region disaster recovery. That mechanism explains a DIFFERENT Snowflake problem: A data steward uses a zero-copy clone as a replacement for a remote recovery copy in a separate cloud region. Here the relevant mechanism instead is: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

Question 180

During operational handoff for this problem: A business team asks an LLM to answer revenue questions but the model frequently invents column names and joins. Which guardrail should be included?

  1. Review feature reproducibility and data lineage across training runs.
  2. Pin availability checks to target regions in AI application deployment reviews.
  3. Test input parsing and malformed payload handling in ingestion contracts.
  4. Test generated SQL and model semantics against finance-approved calculations.

Explanation

Correct Answer

D:

Test generated SQL and model semantics against finance-approved calculations. This reduces recurrence of: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions. The verification should demonstrate: A pilot maps representative natural-language revenue questions to valid SQL based on approved definitions.

Incorrect Answers

A:

Review feature reproducibility and data lineage across training runs. That safeguard is aimed at ANOTHER risk: A retailer builds an ML feature pipeline by copying full source datasets to laptops every day. It is less targeted than the control for: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

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: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.

C:

Test input parsing and malformed payload handling in ingestion contracts. That safeguard is aimed at ANOTHER risk: A migration tool defines a table column as VARCHAR then assumes all JSON path operators will work on it without conversion. It is less targeted than the control for: Text-to-SQL accuracy depends on controlled semantic definitions and database permissions.