Snowflake SnowPro Core COF-C03 Practice Test 37
Question 360
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. An audited production dataset requires recovery mechanisms beyond a short staging lifecycle, and accidental deletion is a realistic threat. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Select a strict COPY INTO error policy such as ABORT_STATEMENT and reconcile source counts before releasing downstream results.
- Evaluate hybrid tables for the transactional access pattern and verify feature and account availability.
- Use a transient table for rebuildable intermediate storage after documenting its shorter recovery protections.
- Use an appropriate permanent table with supported Time Travel retention and understand its Fail-safe protection.
Explanation
Correct Answer
D:Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees. In this architecture planning workshop setting, the intended validation is: Table type and retention settings match the policy and a controlled within-retention restoration test succeeds.
Incorrect Answers
A:That action is relevant when A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. It is not the primary action for the stated permanent table recovery choice need.
B:That action is relevant when A customer application requires low-latency keyed row updates with enforced transactional constraints that fit a supported hybrid-table design. It is not the primary action for the stated permanent table recovery choice need.
C:That action is relevant when An ingestion team keeps rebuildable intermediate records with no requirement for Snowflake-managed Fail-safe recovery. It is not the primary action for the stated permanent table recovery choice need.
Question 361
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. A complicated analytical transform has predictable memory pressure, but management wants evidence before raising per-second warehouse consumption. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Benchmark representative SQL on appropriately sized warehouses while keeping input data and workload conditions comparable.
- Account for local warehouse data-cache loss across suspension, and test steady-state cost/performance without assuming persistence.
- Attach a suitable resource monitor to supported user-managed warehouse consumption and configure quota triggers.
- Inspect persisted query result cache eligibility, deterministic SQL, underlying data changes, and result reuse settings.
Explanation
Correct Answer
A:Warehouse resizing changes resources per cluster; benchmarking reveals whether one heavyweight query benefits enough to offset credits. In this query performance review setting, the intended validation is: Comparable runs show a meaningful runtime improvement and an acceptable compute cost for the chosen warehouse size.
Incorrect Answers
B:That action is relevant when A repeated large scan runs faster on the same warm warehouse, but the speedup disappears after the warehouse has been suspended. It is not the primary action for the stated warehouse sizing performance experiment need.
C:That action is relevant when A sandbox warehouse is used for unpredictable experiments and a manager needs credit alerts and a suspension threshold for that warehouse. Warehouse resizing changes resources per cluster; benchmarking reveals whether one heavyweight query benefits enough to offset credits.
D:That action is relevant when A team reruns an unchanged SELECT but sometimes receives cached results and sometimes spends compute again after underlying data changes. Inspect persisted query result cache eligibility, deterministic SQL, underlying data changes, and result reuse settings.
Question 362
[Production migration readiness] The team proposes: Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration. Its actual requirement is: A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- Comparable runs show a meaningful runtime improvement and an acceptable compute cost for the chosen warehouse size.
- The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
- Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
Explanation
Correct Answer
B:The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test. This is an outcome test of the specified snowpark optimized workload isolation action under the production migration readiness conditions. Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck.
Incorrect Answers
A:In this production migration readiness context, Comparable runs show a meaningful runtime improvement and an acceptable compute cost for the chosen warehouse size. This is an outcome for a different requirement: A complicated analytical transform has predictable memory pressure, but management wants evidence before raising per-second warehouse consumption. It cannot by itself validate the proposed snowpark optimized workload isolation action; the appropriate test is: The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
C:In this production migration readiness context, Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results. This is an outcome for a different requirement: A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. It cannot by itself validate the proposed snowpark optimized workload isolation action; the appropriate test is: The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
D:In this production migration readiness context, A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured. This is an outcome for a different requirement: An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. It cannot by itself validate the proposed snowpark optimized workload isolation action; the appropriate test is: The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
Question 363
[Provider and consumer workshop] The team proposes: Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers. Its actual requirement is: A data collaboration team is defining the permitted provider and consumer relationship. A software vendor needs to package governed application logic with Snowflake-integrated deployment instead of sending a collection of ad hoc scripts. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Only authorized member organizations see the private listings and permitted data products after membership checks.
- The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model.
- A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
- After cloning, test changes in the clone do not modify the source and storage growth is associated with diverging partitions.
Explanation
Correct Answer
C:A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow. This is an outcome test of the specified native app distribution to consumers action under the provider and consumer workshop conditions. Native Apps distribute application capabilities with managed privileges and application artifacts under a supported deployment model.
Incorrect Answers
A:Only authorized member organizations see the private listings and permitted data products after membership checks. This is an outcome for a different requirement: Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
B:In this provider and consumer workshop context, The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model. This is an outcome for a different requirement: An analytics team wants a small interactive application that queries governed Snowflake data without maintaining a standalone app server. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
D:In this provider and consumer workshop context, After cloning, test changes in the clone do not modify the source and storage growth is associated with diverging partitions. This is an outcome for a different requirement: A data owner must provide its internal analytics team with an independently modifiable copy of a large dataset for an experiment. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
Question 364
[Peak traffic performance incident] A reviewer recommends: Implement an authorized stored procedure in a supported language and test its transactional and error-handling semantics. The requirement remains: A BI engineer is investigating the exact bottleneck observed under production-like load. An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- A generative or summarization function fits a text transformation task, whereas a SQL COUNT does not express a message summary.
- Tasks schedule SQL or procedure execution, which a bare stream or file stage does not perform independently.
- A SQL UDF encapsulates reusable expression logic, whereas a scheduled task is meant for orchestration, not a scalar call per row.
- Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints.
Explanation
Correct Answer
D:In this peak traffic performance incident context, Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints. The recommendation is linked to observable evidence for this exact case: The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns cortex generative text operation, not the requirement in this case. That explanation applies to a different cortex generative text operation problem: A support workflow needs a concise natural-language summary of customer messages rather than a numeric SQL aggregation.
B:That option concerns task scheduled orchestration, not the requirement in this case. That explanation applies to a different task scheduled orchestration problem: A cleanup procedure should execute every hour without an operator opening Snowsight, and its success history must be auditable.
C:That option concerns sql udf reusable expression, not the requirement in this case. That explanation applies to a different sql udf reusable expression problem: Several analytics teams need the same small deterministic transformation that returns one scalar value and is naturally expressed in SQL.
Question 365
[Provider and consumer workshop] A data collaboration team is defining the permitted provider and consumer relationship. A Snowflake data provider wants a business partner who already has a Snowflake account to query governed datasets without copying daily CSV exports. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Create a secure direct share for eligible objects and grant it to the approved consumer account under supported region and cloud conditions.
- Plan explicit cross-region collaboration or replication and review cloud and region boundaries before selecting the transfer path.
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Use zero-copy cloning for an authorized internal copy and distinguish it from a cross-account secure share.
Explanation
Correct Answer
A:Direct secure sharing grants access to provider-controlled data objects through a consumer database while avoiding routine export-and-reload duplication. In this provider and consumer workshop setting, the intended validation is: The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
Incorrect Answers
B:That action is relevant when A company operates accounts on two clouds and wants to access a dataset from the second account without assuming storage instantly appears in both regions. It is not the primary action for the stated direct share cross-account access need.
C:That action is relevant when A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It is not the primary action for the stated direct share cross-account access need.
D:That action is relevant when A data owner must provide its internal analytics team with an independently modifiable copy of a large dataset for an experiment. It is not the primary action for the stated direct share cross-account access need.
Question 366
[Optimization regression test] A team is validating a targeted tuning plan against documented workloads and costs. A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Assess clustering depth and query frequency before assigning a clustering key with ongoing maintenance cost.
- Inspect pruning and the overlap of the filter column's values, then tune a supported clustering strategy if warranted.
- Use Snowflake PIVOT on the supported aggregation and quarter categories or an equivalent conditional aggregate.
- Inspect partition pruning and clustering characteristics before choosing a supported data-organizing strategy.
Explanation
Correct Answer
B:Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning. In this optimization regression test setting, the intended validation is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
Incorrect Answers
A:That action is relevant when A very large orders table receives steady inserts and selective date filters have poor clustering; the team needs a durable performance-versus-credit decision. Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
C:That action is relevant when A quarterly metrics report stores one row per region and quarter but the executive view needs a separate column for each quarter. It is not the primary action for the stated selective filter micro-partition pruning need.
D:That action is relevant when A fact table stores billions of events, yet a selective date predicate often scans nearly every partition because records are scattered across the table. It is not the primary action for the stated selective filter micro-partition pruning need.
Question 367
[Ingestion design acceptance] A data engineering team is checking the design before promoting a pipeline. A pipeline repeatedly joins newly ingested transactions to reference data and needs a declarative freshness objective instead of hand-managed CDC steps. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Attach a dynamic data masking policy to the sensitive column with conditions appropriate for the approved role model.
- Use the table's built-in stage where suitable and load into the target using supported commands.
- Define a supported dynamic table with a target lag and valid refresh mode for the transformation query.
- Enable or refresh an appropriate directory table on a supported stage and query its file metadata.
Explanation
Correct Answer
C:Dynamic tables materialize and refresh SQL results using Snowflake orchestration, while freshness is governed by target lag and refresh dependencies. In this ingestion design acceptance setting, the intended validation is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
Incorrect Answers
A:That action is relevant when A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. It is not the primary action for the stated dynamic table downstream freshness need.
B:That action is relevant when An analyst must stage a small support file used only to load one existing target table, with no need for a shared named-stage contract. It is not the primary action for the stated dynamic table downstream freshness need.
D:That action is relevant when A document processing workflow keeps PDFs on a Snowflake stage and needs a queryable inventory of staged files before extraction. Dynamic tables materialize and refresh SQL results using Snowflake orchestration, while freshness is governed by target lag and refresh dependencies.
Question 368
[Optimization regression test] A team is validating a targeted tuning plan against documented workloads and costs. Analytical reports experience sporadic expensive, selective scan work that can benefit from offloading qualifying fragments. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Buy a larger warehouse immediately without examining the query's active operators or whether the delay is queueing.
- Add extra multi-cluster warehouses alone to fix a single query's in-memory hash aggregation spill.
- Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
- Assume switching on the service guarantees every simple SELECT is accelerated without checking eligibility.
Explanation
Correct Answer
D:The discriminating technical reason is: Query Acceleration Service can offload eligible query components to shared compute; it does not replace base warehouse execution for every operation. This directly undermines query acceleration service suitability in the specified context.
Incorrect Answers
A:Under optimization regression test conditions, Buy a larger warehouse immediately without examining the query's active operators or whether the delay is queueing.
B:That is a mistake for a different remote spill diagnosis task, where A large GROUP BY and join spills extensively to remote storage and takes much longer than expected even without query queueing. It does not directly defeat the present query acceleration service suitability requirement, whose proper treatment is: Evaluate Query Acceleration Service eligibility, configuration, and Query Profile signals for the actual workload.
C:That is a mistake for a different materialized view precomputation task, where A dashboard repeatedly calculates the same expensive aggregate over a large base table while the source changes incrementally. It does not directly defeat the present query acceleration service suitability requirement, whose proper treatment is: Evaluate Query Acceleration Service eligibility, configuration, and Query Profile signals for the actual workload.
Question 369
[Provider and consumer workshop] A reviewer recommends: Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition. The requirement remains: A data collaboration team is defining the permitted provider and consumer relationship. A provider and a consumer operate in different supported regions and want catalog-based access without assuming a same-region direct share works unchanged. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Cross-region data product fulfillment has specific replication and availability requirements distinct from same-region share access.
- Direct secure sharing grants access to provider-controlled data objects through a consumer database while avoiding routine export-and-reload duplication.
- Reader accounts can let consumers without their own full Snowflake account access provider-shared data, subject to provisioning and cost controls.
- Accounts have specific cloud and region locations, and cross-region data movement or listings require deliberate supported configuration.
Explanation
Correct Answer
A:In this provider and consumer workshop context, Cross-region data product fulfillment has specific replication and availability requirements distinct from same-region share access. The recommendation is linked to observable evidence for this exact case: The recipient discovers the listing in its region and can read the expected version after fulfillment completes. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
B:That option concerns direct share cross-account access, not the requirement in this case. It does not justify the specific cross-region data listing fulfillment action or its validation path: The recipient discovers the listing in its region and can read the expected version after fulfillment completes.
C:That option concerns reader account for external consumer, not the requirement in this case. It does not justify the specific cross-region data listing fulfillment action or its validation path: The recipient discovers the listing in its region and can read the expected version after fulfillment completes.
D:That option concerns cross-region snowflake account planning, not the requirement in this case. It does not justify the specific cross-region data listing fulfillment action or its validation path: The recipient discovers the listing in its region and can read the expected version after fulfillment completes.
Question 370
[Security control assessment] The team proposes: Enforce and verify appropriate Snowflake MFA or federated IdP MFA controls according to the active policy. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A data platform security assessment finds interactive users have weak password-only sign-in and require a stronger authentication factor. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
- Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
- An approved corporate source can connect while a test connection from an excluded source is rejected.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
Explanation
Correct Answer
B:Identity logs and a controlled sign-in test show the required second factor before an authorized session starts. This is an outcome test of the specified multifactor authentication enrollment action under the security control assessment conditions. MFA protects interactive sign-in beyond knowledge of a single password; it is separate from table permissions.
Incorrect Answers
A:In this security control assessment context, A test user signs in through the approved identity provider and receives only the expected Snowflake role access. This is an outcome for a different requirement: An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. It cannot by itself validate the proposed multifactor authentication enrollment action; the appropriate test is: Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
C:An approved corporate source can connect while a test connection from an excluded source is rejected. This is an outcome for a different requirement: An organization must restrict logins to approved corporate egress ranges even when credentials are correct. It cannot by itself validate the proposed multifactor authentication enrollment action; the appropriate test is: Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
D:In this security control assessment context, A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured. This is an outcome for a different requirement: An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. It cannot by itself validate the proposed multifactor authentication enrollment action; the appropriate test is: Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.