Snowflake SnowPro Core COF-C03 Practice Test 91
Question 900
[Peak traffic performance incident] A BI engineer is investigating the exact bottleneck observed under production-like load. A business-intelligence warehouse serves hundreds of short requests and most end-user delay occurs before the queries actually start. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Inspect spill and execution profile, then evaluate more memory, predicate reduction, or join/query restructuring.
- Use Snowflake's load metadata/history and carefully controlled COPY retry behavior to identify already ingested files.
- Evaluate Query Acceleration Service eligibility, configuration, and Query Profile signals for the actual workload.
- Inspect queued time and concurrency load, then isolate workloads or add supported multi-cluster capacity.
Explanation
Correct Answer
D:A concurrency bottleneck is principally about simultaneous slots rather than the CPU needs of one query. In this peak traffic performance incident setting, the intended validation is: Queued time drops on the same load test and per-query execution time remains stable while cluster usage is visible.
Incorrect Answers
A:That action is relevant when A large GROUP BY and join spills extensively to remote storage and takes much longer than expected even without query queueing. A concurrency bottleneck is principally about simultaneous slots rather than the CPU needs of one query.
B:That action is relevant when A nightly pipeline may retry an earlier bulk load after a network timeout and must avoid inadvertently duplicating files that were already committed. It is not the primary action for the stated query queueing load analysis need.
C:That action is relevant when Analytical reports experience sporadic expensive, selective scan work that can benefit from offloading qualifying fragments. A concurrency bottleneck is principally about simultaneous slots rather than the CPU needs of one query.
Question 901
[Peak traffic performance incident] 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 BI engineer is investigating the exact bottleneck observed under production-like load. 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 release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- Query Profile provides evidence about actual execution instead of assuming all slow SQL has the same cause.
- 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.
- A single heavyweight query's memory and compute needs are a scale-up or query-tuning problem, not inherently a scale-out problem.
Explanation
Correct Answer
A:In this peak traffic performance incident 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
B:That explanation applies to a different search optimization selective lookup problem: An API workload repeatedly probes a huge fact table for single customer identifiers and needs fast selective lookup response.
C:For the peak traffic performance incident conditions, Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time. That explanation applies to a different remote spill diagnosis problem: A large GROUP BY and join spills extensively to remote storage and takes much longer than expected even without query queueing. 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.
D:For the peak traffic performance incident conditions, A single heavyweight query's memory and compute needs are a scale-up or query-tuning problem, not inherently a scale-out problem. That explanation applies to a different warehouse scale-up for complex query problem: A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. 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 902
[Architecture planning workshop] An internal platform architecture group is assessing the initial design. 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. 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?
- Increase warehouse size repeatedly without checking role grants or the denied object privilege.
- Assume a database is automatically replicated to every account merely because all accounts share the same organization.
- Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically.
- 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
B:The supportable direction is: Plan explicit cross-region collaboration or replication and review cloud and region boundaries before selecting the transfer path. The discriminating technical reason is: Accounts have specific cloud and region locations, and cross-region data movement or listings require deliberate supported configuration.
Incorrect Answers
A:Under architecture planning workshop conditions, Increase warehouse size repeatedly without checking role grants or the denied object privilege. That is a mistake for a different cloud services authentication boundary task, where An engineer receives an authorization error before a simple SELECT begins even though the warehouse is running and has idle capacity. It does not directly defeat the present cross-region snowflake account planning requirement, whose proper treatment is: Plan explicit cross-region collaboration or replication and review cloud and region boundaries before selecting the transfer path.
C:Under architecture planning workshop conditions, Grant access to a nonexistent consumer account identifier and assume Snowflake creates a working user interface automatically.
D:That is a mistake for a different cross-region data listing fulfillment task, where A provider and a consumer operate in different supported regions and want catalog-based access without assuming a same-region direct share works unchanged. Under architecture planning workshop conditions, Assume granting the consumer's account name in a remote region is always identical to a local share without any additional setup.
Question 903
[Architecture planning workshop] The team proposes: Use the account, database, schema, and object hierarchy and reference the table using database.schema.table where appropriate. Its actual requirement is: An internal platform architecture group is assessing the initial design. A developer tries to locate a table by naming a warehouse as its parent and cannot determine where the object should be created. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension.
- A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
- SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
- A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
Explanation
Correct Answer
C:SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name. This is an outcome test of the specified account and schema object hierarchy action under the architecture planning workshop conditions. Warehouses provide compute; they are not parents of schemas or tables within the Snowflake object catalog.
Incorrect Answers
A:Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension. This is an outcome for a different requirement: An administrator suspends every reporting warehouse overnight and the operations manager fears that previously committed tables will be erased. It cannot by itself validate the proposed account and schema object hierarchy action; the appropriate test is: SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
B:In this architecture planning workshop context, A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership. This is an outcome for a different requirement: Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. It cannot by itself validate the proposed account and schema object hierarchy action; the appropriate test is: SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
D:In this architecture planning workshop 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 account and schema object hierarchy action; the appropriate test is: SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
Question 904
[Partner onboarding review] A privacy reviewer checks a collaboration rollout before new partner access is granted. Two advertisers want to calculate joint audience overlap while preventing either company from freely inspecting the other's raw person-level records. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Configure an external table and its stage/integration and maintain the external file metadata as required.
- Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition.
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Evaluate a Snowflake Data Clean Room with approved collaboration templates and privacy controls for the intended aggregate analysis.
Explanation
Correct Answer
D:Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results. In this partner onboarding review 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 data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It is not the primary action for the stated privacy-preserving data clean room need.
B: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. It is not the primary action for the stated privacy-preserving data clean room need.
C:That action is relevant when A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. Data Clean Rooms enable governed joint analytics with protections around raw participant data and supported query results.
Question 905
[Security control assessment] The team proposes: Plan an explicit OWNERSHIP transfer with the appropriate grant-management options and test dependent grants before cutover. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A pipeline service role has object OWNERSHIP but its replacement needs controlled transfer with minimal risk to existing privilege chains. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
- A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
- SHOW GRANTS and a controlled session verify inherited SELECT works while ungranted DDL remains forbidden.
- A session test with the intended role context shows the expected access and CURRENT_ROLE identifies primary context.
Explanation
Correct Answer
A:SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations. This is an outcome test of the specified ownership transfer safety action under the security control assessment conditions. Ownership is a distinct powerful privilege; transferring it can affect existing grants and operational control.
Incorrect Answers
B:In this security control assessment context, A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership. This is an outcome for a different requirement: Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. It cannot by itself validate the proposed ownership transfer safety action; the appropriate test is: SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
C:In this security control assessment context, SHOW GRANTS and a controlled session verify inherited SELECT works while ungranted DDL remains forbidden. This is an outcome for a different requirement: 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 cannot by itself validate the proposed ownership transfer safety action; the appropriate test is: SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
D:In this security control assessment context, A session test with the intended role context shows the expected access and CURRENT_ROLE identifies primary context. This is an outcome for a different requirement: A user has an approved reporting role and a separate engineering role but a worksheet unexpectedly lacks SELECT even though the second role has the grant. It cannot by itself validate the proposed ownership transfer safety action; the appropriate test is: SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
Question 906
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Use a supported API integration and external function pattern after confirming cloud/platform and security requirements.
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Create a secure direct share for eligible objects and grant it to the approved consumer account under supported region and cloud conditions.
- Configure an authorized storage integration and external stage with the required cloud trust and path restrictions.
Explanation
Correct Answer
B:Reader accounts can let consumers without their own full Snowflake account access provider-shared data, subject to provisioning and cost controls. In this collaboration operating audit setting, the intended validation is: The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
Incorrect Answers
A:That action is relevant when A Snowflake SQL process must invoke an allowed remote service through an established API gateway, with credentials controlled outside analyst worksheets. It is not the primary action for the stated reader account for external consumer need.
C:That action is relevant when A Snowflake data provider wants a business partner who already has a Snowflake account to query governed datasets without copying daily CSV exports. Reader accounts can let consumers without their own full Snowflake account access provider-shared data, subject to provisioning and cost controls.
D:That action is relevant when A cloud operations group needs to load CSVs from a controlled S3 bucket but security prohibits permanent cloud storage secrets in SQL scripts. It is not the primary action for the stated reader account for external consumer need.
Question 907
[Production migration readiness] A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which Snowflake action best meets this specific requirement?
- Use Snowpark for Python with an appropriately provisioned execution context and pushdown-compatible dataframe operations.
- Test a larger warehouse size or a more efficient query plan to give the expensive join adequate resources.
- Evaluate a Snowpark-optimized warehouse with adequate memory and workload-specific configuration.
- Keep supported DataFrame operations in Snowflake and inspect query execution before invoking local collect operations.
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 production migration readiness 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 data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. Use Snowpark for Python with an appropriately provisioned execution context and pushdown-compatible dataframe operations.
B:That action is relevant when A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. It is not the primary action for the stated snowpark optimized workload isolation need.
D:That action is relevant when Python engineers built Snowpark DataFrame transformations and want to avoid accidental collection of millions of protected records to a laptop. Snowpark-optimized warehouses provide a higher memory profile that can help memory-intensive Snowpark computations, subject to the workload's actual bottleneck.
Question 908
[Optimization regression test] A team is validating a targeted tuning plan against documented workloads and costs. A dashboard repeatedly calculates the same expensive aggregate over a large base table while the source changes incrementally. The conclusion must be justified with observable verification rather than an undocumented assumption. 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.
- Treat the suspended warehouse's local cache as a permanent table copy that must remain available after shutdown.
- Assume switching on the service guarantees every simple SELECT is accelerated without checking eligibility.
- Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
Explanation
Correct Answer
D:The supportable direction is: Evaluate a supported materialized view for the recurring aggregation and quantify maintenance and query benefit. Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
Incorrect Answers
A:That is a mistake for a different secure view exposure boundary task, where A data provider must hide sensitive query definition details while exposing a restricted projection of source data to consumers. Under optimization regression test conditions, Grant consumers direct ownership of every sensitive base table and rely on a regular view to undo those grants.
B:It does not directly defeat the present materialized view precomputation requirement, whose proper treatment is: Evaluate a supported materialized view for the recurring aggregation and quantify maintenance and query benefit.
C:That is a mistake for a different query acceleration service suitability task, where Analytical reports experience sporadic expensive, selective scan work that can benefit from offloading qualifying fragments. It does not directly defeat the present materialized view precomputation requirement, whose proper treatment is: Evaluate a supported materialized view for the recurring aggregation and quantify maintenance and query benefit.
Question 909
[Collaboration operating audit] A platform owner must demonstrate that the proposed sharing model respects its access and recovery boundary. A production permanent table was dropped within its configured retention period, and an operator needs a self-service recovery plan rather than a support escalation. 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 users can run SELECT AT against arbitrary Fail-safe snapshots after Time Travel expires.
- Expect reducing warehouse size to automatically increase cluster count when MAX_CLUSTER_COUNT remains one.
- Require a transient table to provide the same Fail-safe recovery guarantees as a permanent audited table.
- Give the general reporting group SECURITYADMIN to avoid maintaining a custom analysis role.
Explanation
Correct Answer
A:The discriminating technical reason is: Time Travel supports self-service historical access during configured retention; Fail-safe is not an ordinary user-queryable history store. The supportable direction is: Use applicable Time Travel UNDROP or historical recovery inside retention, recognizing that Fail-safe is a separate Snowflake-managed last resort.
Incorrect Answers
B:That is a mistake for a different multi-cluster scale out versus scale up task, where Thirty concurrent dashboards have low individual runtimes but high wait times, and the account can use multi-cluster warehouses. Under collaboration operating audit conditions, Expect reducing warehouse size to automatically increase cluster count when MAX_CLUSTER_COUNT remains one.
C:That is a mistake for a different transient staging table lifecycle task, where An ingestion team keeps rebuildable intermediate records with no requirement for Snowflake-managed Fail-safe recovery. Under collaboration operating audit conditions, Require a transient table to provide the same Fail-safe recovery guarantees as a permanent audited table.
D:That is a mistake for a different custom roles versus system roles task, where A new team proposes using SYSADMIN as the day-to-day analyst role solely because it conveniently creates warehouses. Under collaboration operating audit conditions, Give the general reporting group SECURITYADMIN to avoid maintaining a custom analysis role.
Question 910
[Pipeline incident investigation] The team proposes: Configure an authorized storage integration and external stage with the required cloud trust and path restrictions. Its actual requirement is: An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. A cloud operations group needs to load CSVs from a controlled S3 bucket but security prohibits permanent cloud storage secrets in SQL scripts. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- LIST on the stage shows the expected files and COPY INTO loads exactly the reconciled input rows.
- A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible.
- The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged.
- The exported object files have the expected schema, row counts, and authorized destination path.
Explanation
Correct Answer
B:A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible. This is an outcome test of the specified external stage cloud identity integration action under the pipeline incident investigation conditions. Storage integrations provide an identity-based bridge for supported cloud storage access and are safer than embedding long-lived secrets.
Incorrect Answers
A:In this pipeline incident investigation context, LIST on the stage shows the expected files and COPY INTO loads exactly the reconciled input rows. This is an outcome for a different requirement: A team needs a stable staging location where several engineers can PUT source files and run repeatable bulk loads for the same project. It cannot by itself validate the proposed external stage cloud identity integration action; the appropriate test is: A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible.
C:In this pipeline incident investigation context, The same SELECT succeeds after a precisely scoped grant and the original warehouse size remains unchanged. This is an outcome for a different requirement: An engineer receives an authorization error before a simple SELECT begins even though the warehouse is running and has idle capacity. It cannot by itself validate the proposed external stage cloud identity integration action; the appropriate test is: A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible.
D: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 external stage cloud identity integration action; the appropriate test is: A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible.