Snowflake SnowPro Core COF-C03 Practice Test 63
Question 620
[Pipeline incident investigation] The team proposes: Define a supported dynamic table with a target lag and valid refresh mode for the transformation query. Its actual requirement is: An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. A pipeline repeatedly joins newly ingested transactions to reference data and needs a declarative freshness objective instead of hand-managed CDC steps. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- Directory metadata contains the expected file paths, sizes and update timestamps after a controlled stage refresh.
- The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
- Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
- Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
Explanation
Correct Answer
D:Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load. This is an outcome test of the specified dynamic table downstream freshness action under the pipeline incident investigation conditions. Dynamic tables materialize and refresh SQL results using Snowflake orchestration, while freshness is governed by target lag and refresh dependencies.
Incorrect Answers
A:In this pipeline incident investigation context, Directory metadata contains the expected file paths, sizes and update timestamps after a controlled stage refresh. This is an outcome for a different requirement: A document processing workflow keeps PDFs on a Snowflake stage and needs a queryable inventory of staged files before extraction. It cannot by itself validate the proposed dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
B:In this pipeline incident investigation 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 dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
C:Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target. This is an outcome for a different requirement: A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. It cannot by itself validate the proposed dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
Question 621
[Optimization regression test] A reviewer recommends: Account for local warehouse data-cache loss across suspension, and test steady-state cost/performance without assuming persistence. The requirement remains: A team is validating a targeted tuning plan against documented workloads and costs. A repeated large scan runs faster on the same warm warehouse, but the speedup disappears after the warehouse has been suspended. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Warehouse cache is local compute storage and is not the durable persisted-query-result cache or underlying table storage.
- Auto-suspend releases idle warehouse compute while auto-resume permits later queries; frequency should reflect workload and billing minimums.
- The database storage layer persists committed table data independently from the lifecycle of virtual warehouse clusters.
- Result reuse depends on strict eligibility and unchanged relevant data; it is distinct from local warehouse data-cache reuse.
Explanation
Correct Answer
A:In this optimization regression test context, Warehouse cache is local compute storage and is not the durable persisted-query-result cache or underlying table storage. The recommendation is linked to observable evidence for this exact case: Profile and timing comparisons show faster warm scans on the active warehouse and a changed cache pattern after resumption. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
B:For the optimization regression test conditions, Auto-suspend releases idle warehouse compute while auto-resume permits later queries; frequency should reflect workload and billing minimums. That explanation applies to a different warehouse auto-suspend economics problem: A development warehouse completes a short test query and then remains idle for hours because the team left its suspend behavior unmanaged. It does not justify the specific warehouse local data cache action or its validation path: Profile and timing comparisons show faster warm scans on the active warehouse and a changed cache pattern after resumption.
C:For the optimization regression test conditions, The database storage layer persists committed table data independently from the lifecycle of virtual warehouse clusters. That explanation applies to a different durable database storage separation problem: An administrator suspends every reporting warehouse overnight and the operations manager fears that previously committed tables will be erased. It does not justify the specific warehouse local data cache action or its validation path: Profile and timing comparisons show faster warm scans on the active warehouse and a changed cache pattern after resumption.
D:For the optimization regression test conditions, Result reuse depends on strict eligibility and unchanged relevant data; it is distinct from local warehouse data-cache reuse. That explanation applies to a different persisted result reuse conditions problem: A team reruns an unchanged SELECT but sometimes receives cached results and sometimes spends compute again after underlying data changes. It does not justify the specific warehouse local data cache action or its validation path: Profile and timing comparisons show faster warm scans on the active warehouse and a changed cache pattern after resumption.
Question 622
[Architecture planning workshop] The team proposes: Inspect the active role's grants and cloud-services authorization path instead of resizing compute. Its actual requirement is: An internal platform architecture group is assessing the initial design. An engineer receives an authorization error before a simple SELECT begins even though the warehouse is running and has idle capacity. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
- The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
- The account's edition and configured private endpoint show a private connection path, and network tests reject unintended access.
Explanation
Correct Answer
B:The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged. This is an outcome test of the specified cloud services authentication boundary action under the architecture planning workshop conditions. Access control and query planning belong to Snowflake cloud services; extra warehouse CPU does not grant missing privileges.
Incorrect Answers
A:In this architecture planning workshop context, Identity logs and a controlled sign-in test show the required second factor before an authorized session starts. This is an outcome for a different requirement: A data platform security assessment finds interactive users have weak password-only sign-in and require a stronger authentication factor. It cannot by itself validate the proposed cloud services authentication boundary action; the appropriate test is: The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged.
C: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 cloud services authentication boundary action; the appropriate test is: The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged.
D:In this architecture planning workshop 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 cloud services authentication boundary action; the appropriate test is: The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged.
Question 623
[Security control assessment] 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 specific design mistake would most directly defeat the intended result?
- Mask the REGION column text and assume unauthorized rows have automatically disappeared from all queries.
- Grant every user elevated SQL privileges and call it a replacement for identity federation.
- Set a masking policy on a table column and assume that supplies a second authentication factor at login.
- Create a separate unrestricted duplicate table for analysts and rely on a comment saying identifiers are confidential.
Explanation
Correct Answer
C:The discriminating technical reason is: MFA protects interactive sign-in beyond knowledge of a single password; it is separate from table permissions. The supportable direction is: Enforce and verify appropriate Snowflake MFA or federated IdP MFA controls according to the active policy.
Incorrect Answers
A: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. It does not directly defeat the present multifactor authentication enrollment requirement, whose proper treatment is: Enforce and verify appropriate Snowflake MFA or federated IdP MFA controls according to the active policy.
B:That is a mistake for a different federated single sign-on task, where An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. Under security control assessment conditions, Grant every user elevated SQL privileges and call it a replacement for identity federation.
D:Under security control assessment conditions, Create a separate unrestricted duplicate table for analysts and rely on a comment saying identifiers are confidential.
Question 624
[Provider and consumer workshop] The team proposes: Create a secure direct share for eligible objects and grant it to the approved consumer account under supported region and cloud conditions. Its actual requirement is: 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 observation most directly validates success?
- The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
- Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
- After cloning, test changes in the clone do not modify the source and storage growth is associated with diverging partitions.
- The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
Explanation
Correct Answer
D:Direct secure sharing grants access to provider-controlled data objects through a consumer database while avoiding routine export-and-reload duplication. This is an outcome test of the specified direct share cross-account access action under the provider and consumer workshop conditions.
Incorrect Answers
A:In this provider and consumer workshop context, The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider. This is an outcome for a different requirement: A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It cannot by itself validate the proposed direct share cross-account access action; the appropriate test is: The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
B:In this provider and consumer workshop context, Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured. This is an outcome for a different requirement: 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 cannot by itself validate the proposed direct share cross-account access action; the appropriate test is: The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
C: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 direct share cross-account access action; the appropriate test is: The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
Question 625
[Post-rollout service review] 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 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.
- Build a supported dynamic table with a SELECT definition, warehouse, and achievable TARGET_LAG setting.
- Evaluate Snowflake's supported Apache Iceberg table options and catalog ownership for the intended interoperability model.
- Build a supported Cortex Search service over appropriately prepared text and filterable metadata.
Explanation
Correct Answer
A:A generative or summarization function fits a text transformation task, whereas a SQL COUNT does not express a message summary. The answer targets the described requirement rather than an unrelated feature.
Incorrect Answers
B:That action is relevant when A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. It is not the primary action for the stated cortex generative text operation need.
C:That action is relevant when 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 is not the primary action for the stated cortex generative text operation need.
D:That action is relevant when A support application must retrieve relevant passages from a collection of policy documents to ground an answer. It is not the primary action for the stated cortex generative text operation need.
Question 626
[Partner onboarding review] The team proposes: Evaluate Snowflake Data Exchange or a supported private listing arrangement with approved membership and governance. Its actual requirement is: A privacy reviewer checks a collaboration rollout before new partner access is granted. Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- The recipient discovers the listing in its region and can read the expected version after fulfillment completes.
- Only authorized member organizations see the private listings and permitted data products after membership checks.
- Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used.
- The approved overlap result returns only permitted aggregate metrics and tests reject prohibited raw-identifier disclosures.
Explanation
Correct Answer
B:Only authorized member organizations see the private listings and permitted data products after membership checks. This is an outcome test of the specified private data exchange collaboration action under the partner onboarding review conditions. Private collaboration environments govern which organizations can discover and share listings beyond simple public marketplace exposure.
Incorrect Answers
A:In this partner onboarding review context, The recipient discovers the listing in its region and can read the expected version after fulfillment completes. This is an outcome for a different requirement: A provider and a consumer operate in different supported regions and want catalog-based access without assuming a same-region direct share works unchanged. It cannot by itself validate the proposed private data exchange collaboration action; the appropriate test is: Only authorized member organizations see the private listings and permitted data products after membership checks.
C:In this partner onboarding review context, Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used. This is an outcome for a different requirement: A sensitive integration requires clients to use supported private cloud networking instead of routing all traffic through public endpoints. It cannot by itself validate the proposed private data exchange collaboration action; the appropriate test is: Only authorized member organizations see the private listings and permitted data products after membership checks.
D:In this partner onboarding review context, The approved overlap result returns only permitted aggregate metrics and tests reject prohibited raw-identifier disclosures. This is an outcome for a different requirement: Two advertisers want to calculate joint audience overlap while preventing either company from freely inspecting the other's raw person-level records. It cannot by itself validate the proposed private data exchange collaboration action; the appropriate test is: Only authorized member organizations see the private listings and permitted data products after membership checks.
Question 627
[Production cutover rehearsal] The team proposes: Define a supported dynamic table with a target lag and valid refresh mode for the transformation query. Its actual requirement is: A data integration group runs a controlled replay with representative files or events. A pipeline repeatedly joins newly ingested transactions to reference data and needs a declarative freshness objective instead of hand-managed CDC steps. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- Directory metadata contains the expected file paths, sizes and update timestamps after a controlled stage refresh.
- The exported object files have the expected schema, row counts, and authorized destination path.
- Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
- A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
Explanation
Correct Answer
C:Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load. This is an outcome test of the specified dynamic table downstream freshness action under the production cutover rehearsal conditions. Dynamic tables materialize and refresh SQL results using Snowflake orchestration, while freshness is governed by target lag and refresh dependencies.
Incorrect Answers
A:In this production cutover rehearsal context, Directory metadata contains the expected file paths, sizes and update timestamps after a controlled stage refresh. This is an outcome for a different requirement: A document processing workflow keeps PDFs on a Snowflake stage and needs a queryable inventory of staged files before extraction. It cannot by itself validate the proposed dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
B: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 dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
D:In this production cutover rehearsal context, A staged file is visible through the table-stage reference and a controlled COPY loads the intended table. This is an outcome for a different requirement: 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 cannot by itself validate the proposed dynamic table downstream freshness action; the appropriate test is: Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
Question 628
[Optimization regression test] The team proposes: Load the payload into a VARIANT column and use supported path extraction and casts for downstream typed calculations. Its actual requirement is: A team is validating a targeted tuning plan against documented workloads and costs. A mobile application sends JSON documents with evolving optional fields, and developers want to retain the nested payload without predefining every scalar column. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- Separate user-role tests return only the authorized region's row keys while total source data remains unchanged.
- Queued time drops on the same load test and per-query execution time remains stable while cluster usage is visible.
- A validated report has one region row and expected quarter columns with reconciled totals.
- SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
Explanation
Correct Answer
D:SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic. This is an outcome test of the specified variant semi-structured access action under the optimization regression test conditions. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.
Incorrect Answers
A:In this optimization regression test 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 variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
B:Queued time drops on the same load test and per-query execution time remains stable while cluster usage is visible. This is an outcome for a different requirement: A business-intelligence warehouse serves hundreds of short requests and most end-user delay occurs before the queries actually start. It cannot by itself validate the proposed variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
C: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 variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
Question 629
[Architecture planning workshop] The team proposes: Use the maintained Snowflake CLI with explicit connection configuration and scoped deployment credentials. Its actual requirement is: An internal platform architecture group is assessing the initial design. A team needs repeatable command-line deployment of Snowflake project artifacts inside a CI pipeline rather than manual browser clicks. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- A clean pipeline run connects to the intended account and reproducibly creates the authorized target artifact.
- The analyst runs a permitted worksheet and sees its query details and object navigation in Snowsight.
- The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model.
- Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
Explanation
Correct Answer
A:A clean pipeline run connects to the intended account and reproducibly creates the authorized target artifact. This is an outcome test of the specified snowflake cli reproducible developer work action under the architecture planning workshop conditions. Snowflake CLI supports scripted, reproducible project workflows; authorization still comes from configured Snowflake identities and roles.
Incorrect Answers
B:In this architecture planning workshop context, The analyst runs a permitted worksheet and sees its query details and object navigation in Snowsight. This is an outcome for a different requirement: An analyst needs a browser-based place to run worksheets, inspect query history, and explore Snowflake objects without provisioning an IDE. It cannot by itself validate the proposed snowflake cli reproducible developer work action; the appropriate test is: A clean pipeline run connects to the intended account and reproducibly creates the authorized target artifact.
C:In this architecture planning 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 snowflake cli reproducible developer work action; the appropriate test is: A clean pipeline run connects to the intended account and reproducibly creates the authorized target artifact.
D:Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured. This is an outcome for a different requirement: 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 cannot by itself validate the proposed snowflake cli reproducible developer work action; the appropriate test is: A clean pipeline run connects to the intended account and reproducibly creates the authorized target artifact.
Question 630
[Security control assessment] A quarterly access-control audit requires an evidence-backed answer. An organization must restrict logins to approved corporate egress ranges even when credentials are correct. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Run supported Snowflake data-classification capabilities and review resulting tags or classification metadata before policy assignment.
- Create and attach an appropriate Snowflake network policy or network rule-based policy for the specified identities and IP ranges.
- Install and configure the appropriate Snowflake JDBC or ODBC driver, connection parameters, and least-privilege role.
- Define and attach a row access policy that evaluates approved regional role or mapping criteria.
Explanation
Correct Answer
B:Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy. In this security control assessment setting, the intended validation is: An approved corporate source can connect while a test connection from an excluded source is rejected.
Incorrect Answers
A:That action is relevant when A governance group is auditing hundreds of columns for sensitive categories before attaching masking controls. Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
C:That action is relevant when A third-party reporting product accepts standard database connectivity drivers and needs Snowflake queries under a service identity. Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
D:That action is relevant when Regional managers share a table but must see only the geographic rows permitted by their assigned region. Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.