Snowflake SnowPro Core COF-C03 Practice Test 80
Question 790
[Security control assessment] The team proposes: Attach a dynamic data masking policy to the sensitive column with conditions appropriate for the approved role model. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load.
- The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
- Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
- Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
Explanation
Correct Answer
B:Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value. This is an outcome test of the specified dynamic data masking policy action under the security control assessment conditions.
Incorrect Answers
A:In this security control assessment context, Refresh history and source/target timestamps demonstrate the chosen target lag is achievable under production load. This is an outcome for a different requirement: A pipeline repeatedly joins newly ingested transactions to reference data and needs a declarative freshness objective instead of hand-managed CDC steps. It cannot by itself validate the proposed dynamic data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
C:In this security control assessment context, Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection. This is an outcome for a different requirement: A governance group is auditing hundreds of columns for sensitive categories before attaching masking controls. It cannot by itself validate the proposed dynamic data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
D:In this security control assessment context, 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 data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
Question 791
[Collaboration operating audit] A reviewer recommends: Configure supported database or account replication and plan promotion or failover procedures for the desired recovery objectives. The requirement remains: A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Cloning provides an independent object snapshot with shared initial storage, while secure sharing is primarily provider-controlled consumption.
- Accounts have specific cloud and region locations, and cross-region data movement or listings require deliberate supported configuration.
- Replication moves supported data and metadata across account or region boundaries and differs from a local zero-copy clone.
- Cloning can initially share underlying storage micro-partitions, with additional storage as source or clone changes over time.
Explanation
Correct Answer
C:In this collaboration operating audit context, Replication moves supported data and metadata across account or region boundaries and differs from a local zero-copy clone. The recommendation is linked to observable evidence for this exact case: Replication status and a controlled secondary-account query confirm the expected dataset and documented lag. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns zero-copy clone lifecycle in collaboration, not the requirement in this case. It does not justify the specific replication across regions for availability action or its validation path: Replication status and a controlled secondary-account query confirm the expected dataset and documented lag.
B:That option concerns cross-region snowflake account planning, not the requirement in this case. It does not justify the specific replication across regions for availability action or its validation path: Replication status and a controlled secondary-account query confirm the expected dataset and documented lag.
D:It does not justify the specific replication across regions for availability action or its validation path: Replication status and a controlled secondary-account query confirm the expected dataset and documented lag.
Question 792
[Query performance review] A reviewer recommends: Open the query's profile and compare execution operators, partitions scanned, bytes processed, and spill indicators before tuning. The requirement remains: A performance engineer is benchmarking representative queries before accepting changes. A 70-second analytics query has become slow after a schema change, and the team wants to find whether scanning, joining, or spilling dominates its runtime. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Warehouse resizing changes resources per cluster; benchmarking reveals whether one heavyweight query benefits enough to offset credits.
- Search optimization maintains access paths for selective probes and is not the same as adding a multi-cluster warehouse for concurrency.
- Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time.
- Query Profile provides evidence about actual execution instead of assuming all slow SQL has the same cause.
Explanation
Correct Answer
D:In this query performance review context, Query Profile provides evidence about actual execution instead of assuming all slow SQL has the same cause. The recommendation is linked to observable evidence for this exact case: A before-and-after profile identifies the operator that improved and shows lower elapsed execution time on comparable data. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:It does not justify the specific query profile bottleneck localization action or its validation path: A before-and-after profile identifies the operator that improved and shows lower elapsed execution time on comparable data.
B:That option concerns search optimization selective lookup, not the requirement in this case. It does not justify the specific query profile bottleneck localization action or its validation path: A before-and-after profile identifies the operator that improved and shows lower elapsed execution time on comparable data.
C:That option concerns remote spill diagnosis, not the requirement in this case. It does not justify the specific query profile bottleneck localization action or its validation path: A before-and-after profile identifies the operator that improved and shows lower elapsed execution time on comparable data.
Question 793
[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 specific design mistake would most directly defeat the intended result?
- Assume a standard tiny warehouse can execute an arbitrary in-memory dataframe operation regardless of memory demand.
- Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
- Download the entire confidential source table to a local pandas session before applying a simple supported projection.
- Store an administrator's plaintext password in every CI job and assume a network policy makes it equivalent to key authentication.
Explanation
Correct Answer
A:The discriminating technical reason is: Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck. The supportable direction is: Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration.
Incorrect Answers
B: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. Under architecture planning workshop conditions, Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
C:That is a mistake for a different snowpark python pushdown task, where A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. Under architecture planning workshop conditions, Download the entire confidential source table to a local pandas session before applying a simple supported projection.
D: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. Under architecture planning workshop conditions, Store an administrator's plaintext password in every CI job and assume a network policy makes it equivalent to key authentication.
Question 794
[Post-rollout service review] An operations group is reassessing the installed data platform after a representative workload trial. A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. The conclusion must be justified with observable verification rather than an undocumented assumption. 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.
- Assume a standard tiny warehouse can execute an arbitrary in-memory dataframe operation regardless of memory demand.
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
- Download the entire confidential source table to a local pandas session before applying a simple supported projection.
Explanation
Correct Answer
B:The discriminating technical reason is: Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck. Assume a standard tiny warehouse can execute an arbitrary in-memory dataframe operation regardless of memory demand.
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. Under post-rollout service review conditions, Conclude that a 4X larger warehouse must be 4X faster for every small query without collecting any timing data.
C: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 snowpark optimized workload isolation requirement, whose proper treatment is: Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration.
D:That is a mistake for a different snowpark python pushdown task, where A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. Under post-rollout service review conditions, Download the entire confidential source table to a local pandas session before applying a simple supported projection.
Question 795
[Post-rollout service review] An operations group is reassessing the installed data platform after a representative workload trial. A financial-services project requires a supported private connectivity pattern and enhanced compliance options rather than access from arbitrary public networks. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Install and configure the appropriate Snowflake JDBC or ODBC driver, connection parameters, and least-privilege role.
- Evaluate Cortex Analyst with a suitable semantic model or semantic view over authorized structured data.
- Evaluate the Business Critical or otherwise eligible edition and configure a supported private connectivity option for its cloud.
- Evaluate Snowflake Data Exchange or a supported private listing arrangement with approved membership and governance.
Explanation
Correct Answer
C:Private connectivity and enhanced security functionality have edition and cloud prerequisites that must be verified independently of ordinary RBAC.
Incorrect Answers
A:That action is relevant when A third-party reporting product accepts standard database connectivity drivers and needs Snowflake queries under a service identity. It is not the primary action for the stated business critical private connectivity need.
B:That action is relevant when Business users want to ask plain-language questions against governed structured metrics with defined business terminology. It is not the primary action for the stated business critical private connectivity need.
D:That action is relevant when Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly. It is not the primary action for the stated business critical private connectivity need.
Question 796
[Partner onboarding review] A privacy reviewer checks a collaboration rollout before new partner access is granted. A data owner must provide its internal analytics team with an independently modifiable copy of a large dataset for an experiment. 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?
- Run COPY INTO the target table while claiming that the statement creates outbound partner CSV files.
- Use ON_ERROR=CONTINUE and call the loaded row count complete without logging the rejected records.
- Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
- Expect edits to a direct-shared consumer database to update the provider's base tables as though it were a mutable local clone.
Explanation
Correct Answer
D:The discriminating technical reason is: Cloning provides an independent object snapshot with shared initial storage, while secure sharing is primarily provider-controlled consumption. Expect edits to a direct-shared consumer database to update the provider's base tables as though it were a mutable local clone.
Incorrect Answers
A:Under partner onboarding review conditions, Run COPY INTO the target table while claiming that the statement creates outbound partner CSV files.
B:That is a mistake for a different copy into error-handling choice task, where A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. Under partner onboarding review conditions, Use ON_ERROR=CONTINUE and call the loaded row count complete without logging the rejected records.
C:Under partner onboarding review conditions, Email unencrypted copies of all source tables nightly and claim that this is the only supported Snowflake collaboration model.
Question 797
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A software vendor needs to package governed application logic with Snowflake-integrated deployment instead of sending a collection of ad hoc scripts. 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 attaching a SQL comment to a shared table automatically creates a deployable Native App package.
- Create a private SQL warehouse and assume it is automatically published as a searchable commercial dataset listing.
- Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically.
- Assume deploying the app bypasses database grants and makes every protected table readable to all anonymous visitors.
Explanation
Correct Answer
A:The supportable direction is: Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers. Assume attaching a SQL comment to a shared table automatically creates a deployable Native App package.
Incorrect Answers
B:That is a mistake for a different marketplace listing discovery task, where A publisher needs customers to discover and request an approved dataset through a catalog rather than exchange account identifiers manually. It does not directly defeat the present native app distribution to consumers requirement, whose proper treatment is: Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers.
C:Under collaboration operating audit conditions, Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically. That is a mistake for a different reader account for external consumer task, where A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It does not directly defeat the present native app distribution to consumers requirement, whose proper treatment is: Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers.
D:That is a mistake for a different streamlit app inside snowflake task, where An analytics team wants a small interactive application that queries governed Snowflake data without maintaining a standalone app server. Under collaboration operating audit conditions, Assume deploying the app bypasses database grants and makes every protected table readable to all anonymous visitors.
Question 798
[Production cutover rehearsal] A data integration group runs a controlled replay with representative files or events. A team needs a stable staging location where several engineers can PUT source files and run repeatable bulk loads for the same project. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Treat a SELECT against an empty user table as a guaranteed live list of all PDFs in unrelated cloud buckets.
- Rely on one engineer's user stage as a durable team-owned contract without assigning the required permissions.
- Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract.
- Use FORCE=TRUE on every retry without any deduplication plan and assume no extra records can appear.
Explanation
Correct Answer
B:The supportable direction is: Create an appropriately permissioned named internal stage and define a compatible file format for the incoming files. The discriminating technical reason is: Named internal stages support managed file staging and reusable load references across authorized sessions.
Incorrect Answers
A:Under production cutover rehearsal conditions, Treat a SELECT against an empty user table as a guaranteed live list of all PDFs in unrelated cloud buckets.
C:Under production cutover rehearsal conditions, Specify JSON as the file format for this delimited feed and expect COPY to infer the entire quoting contract.
D:Under production cutover rehearsal conditions, Use FORCE=TRUE on every retry without any deduplication plan and assume no extra records can appear. That is a mistake for a different load idempotence and history task, where A nightly pipeline may retry an earlier bulk load after a network timeout and must avoid inadvertently duplicating files that were already committed. It does not directly defeat the present named internal stage for file reuse requirement, whose proper treatment is: Create an appropriately permissioned named internal stage and define a compatible file format for the incoming files.
Question 799
[Identity and governance change request] A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Configure an appropriate OAuth authorization flow and token scopes along with Snowflake role privileges.
- Create a clear role hierarchy and grant the reader role to an appropriate higher functional role with the additional privileges.
- Create a narrowly scoped reader role with USAGE on parent containers and SELECT on the approved view, then grant it to the user.
- Configure appropriate future grants for the required schema scope while preserving narrowly defined access roles.
Explanation
Correct Answer
C:Snowflake's role-based access control separates namespace visibility from object-level privileges and does not require administrative ownership for reading. In this identity and governance change request setting, the intended validation is: SHOW GRANTS shows only the intended USAGE and SELECT path, and a tested UPDATE against the base table is denied.
Incorrect Answers
A:That action is relevant when A managed business application requires scoped delegated Snowflake access on behalf of an authorized person without collecting their database password. It is not the primary action for the stated least-privilege read role need.
B:That action is relevant when A data science team needs the privileges of its reader role plus a limited set of model-development privileges without maintaining a duplicate grant list. It is not the primary action for the stated least-privilege read role need.
D:That action is relevant when Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. Snowflake's role-based access control separates namespace visibility from object-level privileges and does not require administrative ownership for reading.
Question 800
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. An analytics team wants a small interactive application that queries governed Snowflake data without maintaining a standalone app server. 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 an external table and its stage/integration and maintain the external file metadata as required.
- Plan explicit cross-region collaboration or replication and review cloud and region boundaries before selecting the transfer path.
- Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers.
- Evaluate Streamlit in Snowflake and configure app access, runtime, and roles within supported account capabilities.
Explanation
Correct Answer
D:Streamlit in Snowflake provides a managed application experience within the Snowflake ecosystem, with ordinary role and data controls still relevant. In this architecture planning workshop setting, the intended validation is: The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model.
Incorrect Answers
A:That action is relevant when A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. Configure an external table and its stage/integration and maintain the external file metadata as required.
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. Streamlit in Snowflake provides a managed application experience within the Snowflake ecosystem, with ordinary role and data controls still relevant.
C:That action is relevant when A software vendor needs to package governed application logic with Snowflake-integrated deployment instead of sending a collection of ad hoc scripts.