Snowflake SnowPro Core COF-C03 Practice Test 68
Question 670
[Post-rollout service review] The team proposes: Use a suitable supported Snowflake Cortex AI text function or model API and govern its input and output. Its actual requirement is: An operations group is reassessing the installed data platform after a representative workload trial. A support workflow needs a concise natural-language summary of customer messages rather than a numeric SQL aggregation. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- A compatible engine discovers the expected Iceberg metadata and Snowflake queries return reconciled rows under documented catalog settings.
- A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage.
- Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
- The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
Explanation
Correct Answer
B:A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage. This is an outcome test of the specified cortex generative text operation action under the post-rollout service review conditions. A generative or summarization function fits a text transformation task, whereas a SQL COUNT does not express a message summary.
Incorrect Answers
A:In this post-rollout service review context, A compatible engine discovers the expected Iceberg metadata and Snowflake queries return reconciled rows under documented catalog settings. This is an outcome for a different requirement: A platform team must exchange a lakehouse table through an Apache Iceberg-compatible metadata/catalog workflow instead of migrating every file to proprietary table storage. It cannot by itself validate the proposed cortex generative text operation action; the appropriate test is: A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage.
C:In this post-rollout service review context, Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows. This is an outcome for a different requirement: Business users want to ask plain-language questions against governed structured metrics with defined business terminology. It cannot by itself validate the proposed cortex generative text operation action; the appropriate test is: A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage.
D:In this post-rollout service review context, The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely. This is an outcome for a different requirement: An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. It cannot by itself validate the proposed cortex generative text operation action; the appropriate test is: A review sample shows faithful summaries of the supplied messages under access controls and logged AI usage.
Question 671
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Configure a suitable AUTO_SUSPEND interval and AUTO_RESUME for the development warehouse after assessing startup cadence.
- Use Snowpark for Python with an appropriately provisioned execution context and pushdown-compatible dataframe operations.
- Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration.
- Use an appropriately supported programmatic identity with managed key-pair authentication and rotation controls.
Explanation
Correct Answer
C:Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck. In this architecture planning workshop setting, the intended validation is: The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
Incorrect Answers
A:That action is relevant when A development warehouse completes a short test query and then remains idle for hours because the team left its suspend behavior unmanaged. It is not the primary action for the stated snowpark optimized workload isolation need.
B:That action is relevant when A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck.
D:That action is relevant when An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck.
Question 672
[Production cutover rehearsal] A reviewer recommends: Install and configure the appropriate Snowflake JDBC or ODBC driver, connection parameters, and least-privilege role. The requirement remains: A data integration group runs a controlled replay with representative files or events. A third-party reporting product accepts standard database connectivity drivers and needs Snowflake queries under a service identity. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- OAuth tokens enable delegated access with scoped authorization, whereas granting database roles alone does not implement token issuance.
- Private connectivity and enhanced security functionality have edition and cloud prerequisites that must be verified independently of ordinary RBAC.
- Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
- Standard drivers provide supported client SQL connectivity; the correct account, network, authentication, and role settings remain mandatory.
Explanation
Correct Answer
D:In this production cutover rehearsal context, Standard drivers provide supported client SQL connectivity; the correct account, network, authentication, and role settings remain mandatory. The recommendation is linked to observable evidence for this exact case: A connection test reaches the expected account and a low-risk SELECT returns rows authorized for the service identity. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That explanation applies to a different oauth delegated client access problem: A managed business application requires scoped delegated Snowflake access on behalf of an authorized person without collecting their database password.
B:That explanation applies to a different business critical private connectivity problem: A financial-services project requires a supported private connectivity pattern and enhanced compliance options rather than access from arbitrary public networks.
C:For the production cutover rehearsal conditions, Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy. That explanation applies to a different network policy address restrictions problem: An organization must restrict logins to approved corporate egress ranges even when credentials are correct. It does not justify the specific jdbc or odbc application connection action or its validation path: A connection test reaches the expected account and a low-risk SELECT returns rows authorized for the service identity.
Question 673
[Production compliance review] A compliance reviewer is checking which safeguard actually enforces the stated boundary. A highly regulated project requires an additional customer-controlled key arrangement above standard platform encryption and a planned key-management process. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Assume every Standard edition account automatically gains a customer-managed key simply by creating a masking policy.
- Store an administrator's plaintext password in every CI job and assume a network policy makes it equivalent to key authentication.
- Enable an extra data analyst role and assume it automatically creates a cloud PrivateLink endpoint.
- Run unconditional INSERT for every retry and rely on order-by formatting to prevent duplicate customer keys.
Explanation
Correct Answer
A:The discriminating technical reason is: Tri-Secret Secure combines Snowflake-managed key protection with an eligible customer-managed key model, but it is not enabled just by a SQL grant. This directly undermines customer-managed encryption key option in the specified context.
Incorrect Answers
B:That is a mistake for a different workload identity key-pair authentication task, where An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. It does not directly defeat the present customer-managed encryption key option requirement, whose proper treatment is: Evaluate Tri-Secret Secure and its edition, cloud, and customer-key prerequisites before implementation.
C:That is a mistake for a different private network endpoint verification task, where A sensitive integration requires clients to use supported private cloud networking instead of routing all traffic through public endpoints. It does not directly defeat the present customer-managed encryption key option requirement, whose proper treatment is: Evaluate Tri-Secret Secure and its edition, cloud, and customer-key prerequisites before implementation.
D:That is a mistake for a different merge keyed upsert task, where A CRM staging feed has new customers and changed addresses and needs an idempotent update-or-insert into the curated customer table. It does not directly defeat the present customer-managed encryption key option requirement, whose proper treatment is: Evaluate Tri-Secret Secure and its edition, cloud, and customer-key prerequisites before implementation.
Question 674
[Production migration readiness] A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A development warehouse completes a short test query and then remains idle for hours because the team left its suspend behavior unmanaged. 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?
- Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
- Leave the warehouse running indefinitely to preserve tables, even when no compute-intensive activity remains.
- Increase one warehouse cluster's size exclusively while leaving the configured concurrency cluster limit at one.
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
Explanation
Correct Answer
B:The discriminating technical reason is: Auto-suspend releases idle warehouse compute while auto-resume permits later queries; frequency should reflect workload and billing minimums. This directly undermines warehouse auto-suspend economics in the specified context.
Incorrect Answers
A:That is a mistake for a different warehouse sizing performance experiment task, where A complicated analytical transform has predictable memory pressure, but management wants evidence before raising per-second warehouse consumption. 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 production migration readiness conditions, Increase one warehouse cluster's size exclusively while leaving the configured concurrency cluster limit at one.
D:That is a mistake for a different warehouse scale-up for complex query task, where A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. 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 675
[Post-rollout service review] A reviewer recommends: Use Snowsight with the permitted role and warehouse to manage worksheets and inspect account-visible objects. The requirement remains: An operations group is reassessing the installed data platform after a representative workload trial. An analyst needs a browser-based place to run worksheets, inspect query history, and explore Snowflake objects without provisioning an IDE. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Unqualified object resolution depends on active session context; the warehouse alone does not specify which schema is targeted.
- Time Travel queries retained historical table versions during configured retention; the latest table state does not replace accessible history immediately.
- Snowsight is Snowflake's graphical interface and surfaces SQL authoring and activity inspection based on the session's access.
- Cortex Analyst is oriented toward analytical natural-language questions over modeled structured data, not an ungoverned document search engine.
Explanation
Correct Answer
C:In this post-rollout service review context, Snowsight is Snowflake's graphical interface and surfaces SQL authoring and activity inspection based on the session's access. The recommendation is linked to observable evidence for this exact case: The analyst runs a permitted worksheet and sees its query details and object navigation in Snowsight. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns session database and role context, not the requirement in this case. It does not justify the specific snowsight analyst interface action or its validation path: The analyst runs a permitted worksheet and sees its query details and object navigation in Snowsight.
B:That option concerns time travel historical query, not the requirement in this case. It does not justify the specific snowsight analyst interface action or its validation path: The analyst runs a permitted worksheet and sees its query details and object navigation in Snowsight.
D:Cortex Analyst is oriented toward analytical natural-language questions over modeled structured data, not an ungoverned document search engine.
Question 676
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. 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 conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
- Assume CLONE DATABASE in one account silently creates an always-current replica in every other geography.
- Create a private SQL warehouse and assume it is automatically published as a searchable commercial dataset listing.
- Assume granting the consumer's account name in a remote region is always identical to a local share without any additional setup.
Explanation
Correct Answer
D:The supportable direction is: Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition. The discriminating technical reason is: Cross-region data product fulfillment has specific replication and availability requirements distinct from same-region share access.
Incorrect Answers
A:Under collaboration operating audit conditions, Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
B:That is a mistake for a different replication across regions for availability task, where A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. Under collaboration operating audit conditions, Assume CLONE DATABASE in one account silently creates an always-current replica in every other geography.
C:Under collaboration operating audit conditions, Create a private SQL warehouse and assume it is automatically published as a searchable commercial dataset listing.
Question 677
[Identity and governance change request] The team proposes: Run supported Snowflake data-classification capabilities and review resulting tags or classification metadata before policy assignment. Its actual requirement is: A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. A governance group is auditing hundreds of columns for sensitive categories before attaching masking controls. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
- Separate user-role tests return only the authorized region's row keys while total source data remains unchanged.
- SELECT against the external table returns staged records after location metadata has been refreshed appropriately.
- An approved corporate source can connect while a test connection from an excluded source is rejected.
Explanation
Correct Answer
A:Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection. This is an outcome test of the specified automated sensitive-data classification action under the identity and governance change request conditions. Classification identifies candidate sensitive data; policy enforcement is a separate governance decision that requires accurate mapping.
Incorrect Answers
B:In this identity and governance change request context, Separate user-role tests return only the authorized region's row keys while total source data remains unchanged. This is an outcome for a different requirement: Regional managers share a table but must see only the geographic rows permitted by their assigned region. It cannot by itself validate the proposed automated sensitive-data classification action; the appropriate test is: Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
C:In this identity and governance change request context, SELECT against the external table returns staged records after location metadata has been refreshed appropriately. This is an outcome for a different requirement: A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It cannot by itself validate the proposed automated sensitive-data classification action; the appropriate test is: Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
D: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 automated sensitive-data classification action; the appropriate test is: Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
Question 678
[Optimization regression test] The team proposes: Inspect pruning and the overlap of the filter column's values, then tune a supported clustering strategy if warranted. Its actual requirement is: 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 observation most directly validates success?
- A validated report has one region row and expected quarter columns with reconciled totals.
- The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
- Clustering information and workload-wide latency improve enough to justify the observed maintenance credits.
- The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
Explanation
Correct Answer
B:The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work. This is an outcome test of the specified selective filter micro-partition pruning action under the optimization regression test conditions. Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
Incorrect Answers
A:In this optimization regression test context, A validated report has one region row and expected quarter columns with reconciled totals. This is an outcome for a different requirement: A quarterly metrics report stores one row per region and quarter but the executive view needs a separate column for each quarter. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
C:In this optimization regression test context, Clustering information and workload-wide latency improve enough to justify the observed maintenance credits. This is an outcome for a different requirement: A very large orders table receives steady inserts and selective date filters have poor clustering; the team needs a durable performance-versus-credit decision. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
D:In this optimization regression test context, The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely. This is an outcome for a different requirement: An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
Question 679
[Production migration readiness] A reviewer recommends: Use an appropriate permanent table with supported Time Travel retention and understand its Fail-safe protection. The requirement remains: A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. An audited production dataset requires recovery mechanisms beyond a short staging lifecycle, and accidental deletion is a realistic threat. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- Hybrid tables support row-oriented transactional use cases that differ from purely analytical columnar standard tables.
- COPY error behavior determines whether load execution aborts or continues past bad rows; strict policy fits completeness-sensitive feeds.
- Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees.
- Transient tables avoid the Fail-safe period and are appropriate where the pipeline can safely recreate the data.
Explanation
Correct Answer
C:In this production migration readiness context, Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees. The recommendation is linked to observable evidence for this exact case: Table type and retention settings match the policy and a controlled within-retention restoration test succeeds. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns hybrid table transactional access, not the requirement in this case. It does not justify the specific permanent table recovery choice action or its validation path: Table type and retention settings match the policy and a controlled within-retention restoration test succeeds.
B:That option concerns copy into error-handling choice, not the requirement in this case. It does not justify the specific permanent table recovery choice action or its validation path: Table type and retention settings match the policy and a controlled within-retention restoration test succeeds.
D:That explanation applies to a different transient staging table lifecycle problem: An ingestion team keeps rebuildable intermediate records with no requirement for Snowflake-managed Fail-safe recovery.
Question 680
[Security control assessment] The team proposes: Evaluate Tri-Secret Secure and its edition, cloud, and customer-key prerequisites before implementation. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A highly regulated project requires an additional customer-controlled key arrangement above standard platform encryption and a planned key-management process. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
- A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
- Approved account configuration and key-management evidence confirm customer-key integration and controlled rotation responsibilities.
Explanation
Correct Answer
D:Approved account configuration and key-management evidence confirm customer-key integration and controlled rotation responsibilities. This is an outcome test of the specified customer-managed encryption key option action under the security control assessment conditions. Tri-Secret Secure combines Snowflake-managed key protection with an eligible customer-managed key model, but it is not enabled just by a SQL grant.
Incorrect Answers
A:In this security control assessment context, The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests. This is an outcome for a different requirement: A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. It cannot by itself validate the proposed customer-managed encryption key option action; the appropriate test is: Approved account configuration and key-management evidence confirm customer-key integration and controlled rotation responsibilities.
B:In this security control assessment context, A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can. This is an outcome for a different requirement: A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. It cannot by itself validate the proposed customer-managed encryption key option action; the appropriate test is: Approved account configuration and key-management evidence confirm customer-key integration and controlled rotation responsibilities.
C: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 customer-managed encryption key option action; the appropriate test is: Approved account configuration and key-management evidence confirm customer-key integration and controlled rotation responsibilities.