Snowflake SnowPro Core COF-C03 Practice Test 98
Question 970
[Peak traffic performance incident] A reviewer recommends: Inspect persisted query result cache eligibility, deterministic SQL, underlying data changes, and result reuse settings. The requirement remains: A BI engineer is investigating the exact bottleneck observed under production-like load. A team reruns an unchanged SELECT but sometimes receives cached results and sometimes spends compute again after underlying data changes. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- QUALIFY filters the results of window functions in Snowflake and is suited to post-window row selection.
- Result reuse depends on strict eligibility and unchanged relevant data; it is distinct from local warehouse data-cache reuse.
- Query Acceleration Service can offload eligible query components to shared compute; it does not replace base warehouse execution for every operation.
- Warehouses isolate compute and cache resources, so the two teams can query the same persisted data without competing for one active warehouse.
Explanation
Correct Answer
B:In this peak traffic performance incident context, Result reuse depends on strict eligibility and unchanged relevant data; it is distinct from local warehouse data-cache reuse. The recommendation is linked to observable evidence for this exact case: Two eligible unchanged executions show a reuse indicator, while changed data causes fresh evaluation under documented conditions. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:It does not justify the specific persisted result reuse conditions action or its validation path: Two eligible unchanged executions show a reuse indicator, while changed data causes fresh evaluation under documented conditions.
C:That option concerns query acceleration service suitability, not the requirement in this case. It does not justify the specific persisted result reuse conditions action or its validation path: Two eligible unchanged executions show a reuse indicator, while changed data causes fresh evaluation under documented conditions.
D:Warehouses isolate compute and cache resources, so the two teams can query the same persisted data without competing for one active warehouse.
Question 971
[Provider and consumer workshop] A data collaboration team is defining the permitted provider and consumer relationship. Two advertisers want to calculate joint audience overlap while preventing either company from freely inspecting the other's raw person-level records. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- 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.
- Evaluate a Snowflake Data Clean Room with approved collaboration templates and privacy controls for the intended aggregate analysis.
- Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition.
Explanation
Correct Answer
C:Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results. In this provider and consumer workshop setting, the intended validation is: The approved overlap result returns only permitted aggregate metrics and tests reject prohibited raw-identifier disclosures.
Incorrect Answers
A: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. Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
B: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. Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results.
D:That action is relevant when A provider and a consumer operate in different supported regions and want catalog-based access without assuming a same-region direct share works unchanged. Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results.
Question 972
[Production cutover rehearsal] The team proposes: Configure Snowpipe with a pipe definition and supported auto-ingest cloud event notifications. Its actual requirement is: A data integration group runs a controlled replay with representative files or events. Incoming small object-storage files appear several times per hour and should load automatically soon after the object store sends events. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- Load history and target counts confirm expected files were not ingested twice after simulated network retry.
- Warehouse events show suspension during idle periods and subsequent query-triggered resume without losing stored data.
- The exported object files have the expected schema, row counts, and authorized destination path.
- A newly uploaded event-notified file appears in pipe load history and target rows without running a manual warehouse COPY.
Explanation
Correct Answer
D:A newly uploaded event-notified file appears in pipe load history and target rows without running a manual warehouse COPY. This is an outcome test of the specified snowpipe file event auto ingest action under the production cutover rehearsal conditions. Snowpipe uses Snowflake-managed compute to ingest staged files automatically, distinct from warehouse-driven scheduled COPY batches.
Incorrect Answers
A:In this production cutover rehearsal context, Load history and target counts confirm expected files were not ingested twice after simulated network retry. This is an outcome for a different requirement: A nightly pipeline may retry an earlier bulk load after a network timeout and must avoid inadvertently duplicating files that were already committed. It cannot by itself validate the proposed snowpipe file event auto ingest action; the appropriate test is: A newly uploaded event-notified file appears in pipe load history and target rows without running a manual warehouse COPY.
B:Warehouse events show suspension during idle periods and subsequent query-triggered resume without losing stored data. This is an outcome for a different requirement: A development warehouse completes a short test query and then remains idle for hours because the team left its suspend behavior unmanaged. It cannot by itself validate the proposed snowpipe file event auto ingest action; the appropriate test is: A newly uploaded event-notified file appears in pipe load history and target rows without running a manual warehouse COPY.
C:In this production cutover rehearsal context, The exported object files have the expected schema, row counts, and authorized destination path. This is an outcome for a different requirement: A downstream finance application requires an export of curated query results to an approved cloud storage path for a partner batch job. It cannot by itself validate the proposed snowpipe file event auto ingest action; the appropriate test is: A newly uploaded event-notified file appears in pipe load history and target rows without running a manual warehouse COPY.
Question 973
[Production migration readiness] A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A data provider must hide sensitive query definition details while exposing a restricted projection of source data to consumers. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which specific design mistake would most directly defeat the intended result?
- Grant consumers direct ownership of every sensitive base table and rely on a regular view to undo those grants.
- Expect edits to a direct-shared consumer database to update the provider's base tables as though it were a mutable local clone.
- Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
- Use Cortex Search as though it alone provides a certified semantic definition of revenue aggregations in every structured table.
Explanation
Correct Answer
A:The supportable direction is: Publish an appropriately designed secure view and grant only the needed access to the consumer role. Grant consumers direct ownership of every sensitive base table and rely on a regular view to undo those grants.
Incorrect Answers
B:It does not directly defeat the present secure view exposure boundary requirement, whose proper treatment is: Publish an appropriately designed secure view and grant only the needed access to the consumer role.
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. Under production migration readiness conditions, Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
D:That is a mistake for a different cortex analyst structured nl-to-sql task, where Business users want to ask plain-language questions against governed structured metrics with defined business terminology. It does not directly defeat the present secure view exposure boundary requirement, whose proper treatment is: Publish an appropriately designed secure view and grant only the needed access to the consumer role.
Question 974
[Ingestion design acceptance] A data engineering team is checking the design before promoting a pipeline. 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. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Rely on one engineer's user stage as a durable team-owned contract without assigning the required permissions.
- Use an unrelated Snowflake warehouse as a file-storage namespace and assume tables automatically locate files by warehouse.
- Assume an external table is identical to a mutable standard Snowflake table with unrestricted DELETE support.
- Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract.
Explanation
Correct Answer
B:The discriminating technical reason is: A table stage gives a convenient table-associated internal landing location without creating a separate named stage.
Incorrect Answers
A:Under ingestion design acceptance conditions, Rely on one engineer's user stage as a durable team-owned contract without assigning the required permissions. That is a mistake for a different named internal stage for file reuse task, where A team needs a stable staging location where several engineers can PUT source files and run repeatable bulk loads for the same project. It does not directly defeat the present table stage file landing requirement, whose proper treatment is: Use the table's built-in stage where suitable and load into the target using supported commands.
C:Under ingestion design acceptance conditions, Assume an external table is identical to a mutable standard Snowflake table with unrestricted DELETE support. That is a mistake for a different external table over data lake task, where A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It does not directly defeat the present table stage file landing requirement, whose proper treatment is: Use the table's built-in stage where suitable and load into the target using supported commands.
D:Under ingestion design acceptance conditions, Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract. That is a mistake for a different reusable csv file format task, where One source feed uses pipe-delimited UTF-8 files with a header and quoted embedded delimiters, and every daily load must interpret them consistently. It does not directly defeat the present table stage file landing requirement, whose proper treatment is: Use the table's built-in stage where suitable and load into the target using supported commands.
Question 975
[Peak traffic performance incident] A BI engineer is investigating the exact bottleneck observed under production-like load. A complicated analytical transform has predictable memory pressure, but management wants evidence before raising per-second warehouse consumption. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which specific design mistake would most directly defeat the intended result?
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
- Expect reducing warehouse size to automatically increase cluster count when MAX_CLUSTER_COUNT remains one.
- Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
- Treat the suspended warehouse's local cache as a permanent table copy that must remain available after shutdown.
Explanation
Correct Answer
C:The supportable direction is: Benchmark representative SQL on appropriately sized warehouses while keeping input data and workload conditions comparable. Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
Incorrect Answers
A:Under peak traffic performance incident conditions, Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
B:Under peak traffic performance incident conditions, Expect reducing warehouse size to automatically increase cluster count when MAX_CLUSTER_COUNT remains one.
D:Under peak traffic performance incident conditions, Treat the suspended warehouse's local cache as a permanent table copy that must remain available after shutdown.
Question 976
[Post-rollout service review] The team proposes: Evaluate Cortex Analyst with a suitable semantic model or semantic view over authorized structured data. Its actual requirement is: An operations group is reassessing the installed data platform after a representative workload trial. Business users want to ask plain-language questions against governed structured metrics with defined business terminology. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage.
- Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers.
- The account's edition and configured private endpoint show a private connection path, and network tests reject unintended access.
- Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
Explanation
Correct Answer
D:Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows. This is an outcome test of the specified cortex analyst structured nl-to-sql action under the post-rollout service review conditions. Cortex Analyst is oriented toward analytical natural-language questions over modeled structured data, not an ungoverned document search engine.
Incorrect Answers
A:A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage. This is an outcome for a different requirement: A support workflow needs a concise natural-language summary of customer messages rather than a numeric SQL aggregation. It cannot by itself validate the proposed cortex analyst structured nl-to-sql action; the appropriate test is: Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
B:In this post-rollout service review context, Queries return relevant authorized passages and identifiers that the application can cite or display to reviewers. This is an outcome for a different requirement: A support application must retrieve relevant passages from a collection of policy documents to ground an answer. It cannot by itself validate the proposed cortex analyst structured nl-to-sql action; the appropriate test is: Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
C:In this post-rollout service review context, The account's edition and configured private endpoint show a private connection path, and network tests reject unintended access. This is an outcome for a different requirement: A financial-services project requires a supported private connectivity pattern and enhanced compliance options rather than access from arbitrary public networks. It cannot by itself validate the proposed cortex analyst structured nl-to-sql action; the appropriate test is: Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
Question 977
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. A development warehouse completes a short test query and then remains idle for hours because the team left its suspend behavior unmanaged. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Leave the warehouse running indefinitely to preserve tables, even when no compute-intensive activity remains.
- Assume a regular external stage by itself listens to cloud events and continuously inserts table rows.
- Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
Explanation
Correct Answer
A:The discriminating technical reason is: Auto-suspend releases idle warehouse compute while auto-resume permits later queries; frequency should reflect workload and billing minimums. The supportable direction is: Configure a suitable AUTO_SUSPEND interval and AUTO_RESUME for the development warehouse after assessing startup cadence.
Incorrect Answers
B:That is a mistake for a different snowpipe file event auto ingest task, where Incoming small object-storage files appear several times per hour and should load automatically soon after the object store sends events. It does not directly defeat the present warehouse auto-suspend economics requirement, whose proper treatment is: Configure a suitable AUTO_SUSPEND interval and AUTO_RESUME for the development warehouse after assessing startup cadence.
C:Under architecture planning workshop conditions, Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
D:It does not directly defeat the present warehouse auto-suspend economics requirement, whose proper treatment is: Configure a suitable AUTO_SUSPEND interval and AUTO_RESUME for the development warehouse after assessing startup cadence.
Question 978
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. A customer application requires low-latency keyed row updates with enforced transactional constraints that fit a supported hybrid-table design. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which specific design mistake would most directly defeat the intended result?
- Require a transient table to provide the same Fail-safe recovery guarantees as a permanent audited table.
- Choose a conventional analytical external table and expect the same transactional constraints and row update behavior.
- Ask Cortex Analyst to index and retrieve all document paragraphs without configuring a document search service.
- Mask the REGION column text and assume unauthorized rows have automatically disappeared from all queries.
Explanation
Correct Answer
B:The supportable direction is: Evaluate hybrid tables for the transactional access pattern and verify feature and account availability. Choose a conventional analytical external table and expect the same transactional constraints and row update behavior.
Incorrect Answers
A:It does not directly defeat the present hybrid table transactional access requirement, whose proper treatment is: Evaluate hybrid tables for the transactional access pattern and verify feature and account availability.
C:That is a mistake for a different cortex search document retrieval task, where A support application must retrieve relevant passages from a collection of policy documents to ground an answer. It does not directly defeat the present hybrid table transactional access requirement, whose proper treatment is: Evaluate hybrid tables for the transactional access pattern and verify feature and account availability.
D:That is a mistake for a different row access policy filtering task, where Regional managers share a table but must see only the geographic rows permitted by their assigned region. Under architecture planning workshop conditions, Mask the REGION column text and assume unauthorized rows have automatically disappeared from all queries.
Question 979
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Use a suitable supported Snowflake Cortex AI text function or model API and govern its input and output.
- Use a suitably configured multi-cluster warehouse and auto-scale policy where supported to address concurrency.
- Implement an authorized stored procedure in a supported language and test its transactional and error-handling semantics.
- Select a strict COPY INTO error policy such as ABORT_STATEMENT and reconcile source counts before releasing downstream results.
Explanation
Correct Answer
C:Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints. In this query performance review setting, the intended validation is: The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
Incorrect Answers
A:That action is relevant when A support workflow needs a concise natural-language summary of customer messages rather than a numeric SQL aggregation. Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints.
B:That action is relevant when During a product launch dozens of short BI queries queue even though each individual query already finishes quickly once it starts. It is not the primary action for the stated stored procedure multi-step operation need.
D: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. Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints.
Question 980
[Production migration readiness] A reviewer recommends: Use Snowpark for Python with an appropriately provisioned execution context and pushdown-compatible dataframe operations. The requirement remains: A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck.
- Unqualified object resolution depends on active session context; the warehouse alone does not specify which schema is targeted.
- The Spark connector integrates Snowflake data access with Spark distributed processing and can use supported query pushdown.
- Snowpark builds logical plans executed in Snowflake, reducing unnecessary client-side transfers for supported operations.
Explanation
Correct Answer
D:In this production migration readiness context, Snowpark builds logical plans executed in Snowflake, reducing unnecessary client-side transfers for supported operations. The recommendation is linked to observable evidence for this exact case: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:For 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. That explanation applies to a different snowpark optimized workload isolation problem: A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. It does not justify the specific snowpark python pushdown action or its validation path: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
B:That option concerns session database and role context, not the requirement in this case. It does not justify the specific snowpark python pushdown action or its validation path: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
C:The Spark connector integrates Snowflake data access with Spark distributed processing and can use supported query pushdown.