Snowflake SnowPro Core COF-C03 Practice Test 88
Question 870
[Post-rollout service review] A reviewer recommends: Inspect partition pruning and clustering characteristics before choosing a supported data-organizing strategy. The requirement remains: An operations group is reassessing the installed data platform after a representative workload trial. A fact table stores billions of events, yet a selective date predicate often scans nearly every partition because records are scattered across the table. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- External tables expose externally stored data through Snowflake-managed metadata rather than copying all rows into a normal native table.
- Snowflake automatically stores micro-partition metadata; pruning is effective when filter values narrow which partitions can contain rows.
- Iceberg tables provide an open-format table metadata layer; catalog integration and write permissions depend on their chosen management model.
- Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
Explanation
Correct Answer
B:In this post-rollout service review context, Snowflake automatically stores micro-partition metadata; pruning is effective when filter values narrow which partitions can contain rows. The recommendation is linked to observable evidence for this exact case: Query Profile shows fewer partitions scanned for the date-filtered workload after the chosen organization change. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns external table over data lake, not the requirement in this case. It does not justify the specific micro-partition pruning metadata action or its validation path: Query Profile shows fewer partitions scanned for the date-filtered workload after the chosen organization change.
C:That option concerns iceberg interoperability decision, not the requirement in this case. It does not justify the specific micro-partition pruning metadata action or its validation path: Query Profile shows fewer partitions scanned for the date-filtered workload after the chosen organization change.
D:Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
Question 871
[Partner onboarding review] A privacy reviewer checks a collaboration rollout before new partner access is granted. 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 release needs an operationally defensible choice without accidentally changing unrelated access or data. Which specific design mistake would most directly defeat the intended result?
- Assume a database is automatically replicated to every account merely because all accounts share the same organization.
- Publish every regulated subsidiary dataset to an unrestricted public marketplace listing to approximate membership control.
- Assume granting the consumer's account name in a remote region is always identical to a local share without any additional setup.
- Assume CLONE DATABASE in one account silently creates an always-current replica in every other geography.
Explanation
Correct Answer
C:The supportable direction is: Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition. Assume granting the consumer's account name in a remote region is always identical to a local share without any additional setup.
Incorrect Answers
A:Under partner onboarding review conditions, Assume a database is automatically replicated to every account merely because all accounts share the same organization. It does not directly defeat the present cross-region data listing fulfillment requirement, whose proper treatment is: Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition.
B:That is a mistake for a different private data exchange collaboration task, where Several subsidiaries must exchange curated datasets inside a controlled organizational community rather than list them publicly. It does not directly defeat the present cross-region data listing fulfillment requirement, whose proper treatment is: Choose a cross-region or cross-cloud listing and fulfillment configuration supported by their accounts and Snowflake edition.
D: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 partner onboarding review conditions, Assume CLONE DATABASE in one account silently creates an always-current replica in every other geography.
Question 872
[Pipeline incident investigation] The team proposes: Use the table's built-in stage where suitable and load into the target using supported commands. Its actual requirement is: An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. An analyst must stage a small support file used only to load one existing target table, with no need for a shared named-stage contract. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- The exported object files have the expected schema, row counts, and authorized destination path.
- A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible.
- SELECT against the external table returns staged records after location metadata has been refreshed appropriately.
- A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
Explanation
Correct Answer
D:A staged file is visible through the table-stage reference and a controlled COPY loads the intended table. This is an outcome test of the specified table stage file landing action under the pipeline incident investigation conditions. A table stage gives a convenient table-associated internal landing location without creating a separate named stage.
Incorrect Answers
A:In this pipeline incident investigation context, The exported object files have the expected schema, row counts, and authorized destination path. This is an outcome for a different requirement: A downstream finance application requires an export of curated query results to an approved cloud storage path for a partner batch job. It cannot by itself validate the proposed table stage file landing action; the appropriate test is: A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
B:A constrained LIST or COPY INTO test succeeds for the permitted bucket path while prohibited paths stay inaccessible. This is an outcome for a different requirement: A cloud operations group needs to load CSVs from a controlled S3 bucket but security prohibits permanent cloud storage secrets in SQL scripts. It cannot by itself validate the proposed table stage file landing action; the appropriate test is: A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
C:In this pipeline incident investigation 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 table stage file landing action; the appropriate test is: A staged file is visible through the table-stage reference and a controlled COPY loads the intended table.
Question 873
[Security control assessment] The team proposes: Use a managed access schema and put the relevant grant authority under the schema owner or a role with MANAGE GRANTS. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
- The client connects with a valid bounded token and is denied after token expiry or removal of necessary privileges.
- 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.
Explanation
Correct Answer
A:A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can. This is an outcome test of the specified managed access schema grants action under the security control assessment conditions. Managed access centralizes grant management and changes who can authorize privileges on contained objects.
Incorrect Answers
B:The client connects with a valid bounded token and is denied after token expiry or removal of necessary privileges. This is an outcome for a different requirement: A managed business application requires scoped delegated Snowflake access on behalf of an authorized person without collecting their database password. It cannot by itself validate the proposed managed access schema grants action; the appropriate test is: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
C:SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations. This is an outcome for a different requirement: A pipeline service role has object OWNERSHIP but its replacement needs controlled transfer with minimal risk to existing privilege chains. It cannot by itself validate the proposed managed access schema grants action; the appropriate test is: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
D: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 managed access schema grants action; the appropriate test is: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
Question 874
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. 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?
- Implement the entire multi-statement DML orchestration as a simple expression-only UDF and assume both objects behave identically.
- Assume adding a conventional user-managed B-tree index is the only way Snowflake can prune native tables.
- Enable clustering on every tiny scratch table because all tables benefit equally without additional compute charges.
- Use MERGE to rewrite base table records as the only available method for a cross-tab SELECT.
Explanation
Correct Answer
B:The discriminating technical reason is: Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning. Assume adding a conventional user-managed B-tree index is the only way Snowflake can prune native tables.
Incorrect Answers
A:Under query performance review conditions, Implement the entire multi-statement DML orchestration as a simple expression-only UDF and assume both objects behave identically.
C:That is a mistake for a different automatic clustering cost tradeoff task, where A very large orders table receives steady inserts and selective date filters have poor clustering; the team needs a durable performance-versus-credit decision.
D:Under query performance review conditions, Use MERGE to rewrite base table records as the only available method for a cross-tab SELECT.
Question 875
[Security control assessment] The team proposes: Configure the available private connectivity option for the eligible edition and cloud, then validate DNS and routing. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A sensitive integration requires clients to use supported private cloud networking instead of routing all traffic through public endpoints. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- An approved corporate source can connect while a test connection from an excluded source is rejected.
- The account's edition and configured private endpoint show a private connection path, and network tests reject unintended access.
- Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used.
- A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
Explanation
Correct Answer
C:Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used. This is an outcome test of the specified private network endpoint verification action under the security control assessment conditions. Private endpoint routing is an infrastructure-level feature independent of Snowflake object permissions.
Incorrect Answers
A: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 private network endpoint verification action; the appropriate test is: Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used.
B:In this security control assessment 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 private network endpoint verification action; the appropriate test is: Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used.
D:In this security control assessment context, A test user signs in through the approved identity provider and receives only the expected Snowflake role access. This is an outcome for a different requirement: An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. It cannot by itself validate the proposed private network endpoint verification action; the appropriate test is: Network-path evidence shows traffic using the configured private endpoint and public-route attempts are not used.
Question 876
[Production compliance review] A reviewer recommends: Use an appropriately supported programmatic identity with managed key-pair authentication and rotation controls. The requirement remains: A compliance reviewer is checking which safeguard actually enforces the stated boundary. An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- 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.
- Access control and query planning belong to Snowflake cloud services; extra warehouse CPU does not grant missing privileges.
- Storage integrations provide an identity-based bridge for supported cloud storage access and are safer than embedding long-lived secrets.
- Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
Explanation
Correct Answer
D:In this production compliance review context, Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling. The recommendation is linked to observable evidence for this exact case: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns customer-managed encryption key option, not the requirement in this case. It does not justify the specific workload identity key-pair authentication action or its validation path: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
B:For the production compliance review conditions, Access control and query planning belong to Snowflake cloud services; extra warehouse CPU does not grant missing privileges. That explanation applies to a different cloud services authentication boundary problem: An engineer receives an authorization error before a simple SELECT begins even though the warehouse is running and has idle capacity. It does not justify the specific workload identity key-pair authentication action or its validation path: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
C:Storage integrations provide an identity-based bridge for supported cloud storage access and are safer than embedding long-lived secrets.
Question 877
[Production cutover rehearsal] A data integration group runs a controlled replay with representative files or events. A 20GB batch contains uncertain date strings and the operator needs to discover load errors without committing partially incorrect target records. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Start a destructive truncation and full reload without inspecting parsing failures in the incoming files.
- Use an unrelated Snowflake warehouse as a file-storage namespace and assume tables automatically locate files by warehouse.
- Export the entire database to CSV and reload it as the only supported cloning approach.
- Run COPY INTO the target table while claiming that the statement creates outbound partner CSV files.
Explanation
Correct Answer
A:The discriminating technical reason is: Validation mode checks parsing and load conditions for supported files without making the ordinary production table mutation. The supportable direction is: Run COPY INTO with an appropriate VALIDATION_MODE or targeted preflight to inspect errors before committing the production load.
Incorrect Answers
B:Under production cutover rehearsal conditions, Use an unrelated Snowflake warehouse as a file-storage namespace and assume tables automatically locate files by warehouse. That is a mistake for a different table stage file landing task, where 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 does not directly defeat the present copy into validation preflight requirement, whose proper treatment is: Run COPY INTO with an appropriate VALIDATION_MODE or targeted preflight to inspect errors before committing the production load.
C:Under production cutover rehearsal conditions, Export the entire database to CSV and reload it as the only supported cloning approach.
D:Under production cutover rehearsal conditions, Run COPY INTO the target table while claiming that the statement creates outbound partner CSV files. That is a mistake for a different copy into location for unload task, where A downstream finance application requires an export of curated query results to an approved cloud storage path for a partner batch job. It does not directly defeat the present copy into validation preflight requirement, whose proper treatment is: Run COPY INTO with an appropriate VALIDATION_MODE or targeted preflight to inspect errors before committing the production load.
Question 878
[Optimization regression test] A reviewer recommends: Inspect queued time and concurrency load, then isolate workloads or add supported multi-cluster capacity. The requirement remains: A team is validating a targeted tuning plan against documented workloads and costs. A business-intelligence warehouse serves hundreds of short requests and most end-user delay occurs before the queries actually start. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Scaling out adds clusters to handle concurrency, while scaling up changes resources for each individual cluster.
- A concurrency bottleneck is principally about simultaneous slots rather than the CPU needs of one query.
- Adding clusters addresses concurrent workload pressure, whereas making one cluster larger is not the same as increasing cluster count.
- Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time.
Explanation
Correct Answer
B:In this optimization regression test context, A concurrency bottleneck is principally about simultaneous slots rather than the CPU needs of one query. The recommendation is linked to observable evidence for this exact case: Queued time drops on the same load test and per-query execution time remains stable while cluster usage is visible. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:For the optimization regression test conditions, Scaling out adds clusters to handle concurrency, while scaling up changes resources for each individual cluster. That explanation applies to a different multi-cluster scale out versus scale up problem: Thirty concurrent dashboards have low individual runtimes but high wait times, and the account can use multi-cluster warehouses. It does not justify the specific query queueing load analysis action or its validation path: Queued time drops on the same load test and per-query execution time remains stable while cluster usage is visible.
C:That explanation applies to a different multi-cluster concurrency scaling problem: During a product launch dozens of short BI queries queue even though each individual query already finishes quickly once it starts.
D: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.
Question 879
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. Several analytics teams need the same small deterministic transformation that returns one scalar value and is naturally expressed in SQL. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Open the query's profile and compare execution operators, partitions scanned, bytes processed, and spill indicators before tuning.
- Implement an authorized stored procedure in a supported language and test its transactional and error-handling semantics.
- Create a scoped SQL user-defined function and grant the appropriate usage privileges to consuming roles.
- Create a properly authorized scheduled task using a supported warehouse or serverless configuration, then resume it.
Explanation
Correct Answer
C:A SQL UDF encapsulates reusable expression logic, whereas a scheduled task is meant for orchestration, not a scalar call per row. In this query performance review setting, the intended validation is: SELECT using the function gives the same result as the underlying expression for a boundary-value test set.
Incorrect Answers
A:That action is relevant when 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. It is not the primary action for the stated sql udf reusable expression need.
B:That action is relevant when An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. It is not the primary action for the stated sql udf reusable expression need.
D:That action is relevant when A cleanup procedure should execute every hour without an operator opening Snowsight, and its success history must be auditable. It is not the primary action for the stated sql udf reusable expression need.
Question 880
[Production cutover rehearsal] The team proposes: Select a strict COPY INTO error policy such as ABORT_STATEMENT and reconcile source counts before releasing downstream results. Its actual requirement is: A data integration group runs a controlled replay with representative files or events. A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- Table type and retention settings match the policy and a controlled within-retention restoration test succeeds.
- The test clone is independently writable and initial storage growth is small compared with a full reload of every source table.
- After cloning, test changes in the clone do not modify the source and storage growth is associated with diverging partitions.
- The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.
Explanation
Correct Answer
D:The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows. This is an outcome test of the specified copy into error-handling choice action under the production cutover rehearsal conditions. COPY error behavior determines whether load execution aborts or continues past bad rows; strict policy fits completeness-sensitive feeds.
Incorrect Answers
A:In this production cutover rehearsal context, Table type and retention settings match the policy and a controlled within-retention restoration test succeeds. This is an outcome for a different requirement: An audited production dataset requires recovery mechanisms beyond a short staging lifecycle, and accidental deletion is a realistic threat. It cannot by itself validate the proposed copy into error-handling choice action; the appropriate test is: The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.
B:In this production cutover rehearsal context, The test clone is independently writable and initial storage growth is small compared with a full reload of every source table. This is an outcome for a different requirement: A product team needs a quick editable test copy of a large database but cannot afford to duplicate all stored bytes immediately. It cannot by itself validate the proposed copy into error-handling choice action; the appropriate test is: The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.
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 copy into error-handling choice action; the appropriate test is: The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.