SnowPro Core COF-C03 Practice Test 33
Question 320
An architecture reviewer proposes the following solution: Query the committed Snowflake table from the second warehouse under an authorized role. The business and technical requirement is: A staging-table load finishes and the data must be visible to a different virtual warehouse in the same account. Which explanation most accurately justifies this choice?
- Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls.
- Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern.
- Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports.
- Committed persisted storage is shared across warehouses; a data copy is not inherently required between compute clusters.
Explanation
Correct Answer
D:Committed persisted storage is shared across warehouses; a data copy is not inherently required between compute clusters. This mechanism explains why the proposed action fits the scenario: Query the committed Snowflake table from the second warehouse under an authorized role. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use Streamlit in Snowflake for the approved internal application pattern. That explains the role of “Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls”, but the present requirement calls for “Committed persisted storage is shared across warehouses; a data copy is not inherently required between compute clusters”: This mechanism explains why the proposed action fits the scenario: Query the committed Snowflake table from the second warehouse under an authorized role.
B:This mechanism explains why the proposed action fits the scenario: Use Cortex Search with an approved indexed unstructured text corpus. That explains the role of “Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern”, but the present requirement calls for “Committed persisted storage is shared across warehouses; a data copy is not inherently required between compute clusters”: This mechanism explains why the proposed action fits the scenario: Query the committed Snowflake table from the second warehouse under an authorized role.
C:This mechanism explains why the proposed action fits the scenario: Use Snowflake Notebooks where available with governed compute and access. That explains the role of “Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports”, but the present requirement calls for “Committed persisted storage is shared across warehouses; a data copy is not inherently required between compute clusters”: This mechanism explains why the proposed action fits the scenario: Query the committed Snowflake table from the second warehouse under an authorized role.
Question 321
An architecture reviewer proposes the following solution: Use supported data classification and semantic labeling to locate sensitive columns. The business and technical requirement is: A finance table includes email addresses and national identifiers that must be identified across hundreds of schemas. Which explanation most accurately justifies this choice?
- Automated or assisted classification helps discover and manage sensitive data across a large catalog.
- Managing identities and accessing all customer tables are distinct authorization duties.
- Authorization revocation separates identity lifecycle from destructive changes to stored data.
- Compute, serverless features and storage have different cost drivers and should not be collapsed into one figure.
Explanation
Correct Answer
A:Automated or assisted classification helps discover and manage sensitive data across a large catalog. This mechanism explains why the proposed action fits the scenario: Use supported data classification and semantic labeling to locate sensitive columns. Confirm the design against supported platform behavior.
Incorrect Answers
B:This mechanism explains why the proposed action fits the scenario: Use user-management privileges or the appropriate system administration role without broad data grants. That explains the role of “Managing identities and accessing all customer tables are distinct authorization duties”, but the present requirement calls for “Automated or assisted classification helps discover and manage sensitive data across a large catalog”: This mechanism explains why the proposed action fits the scenario: Use supported data classification and semantic labeling to locate sensitive columns.
C:This mechanism explains why the proposed action fits the scenario: Revoke their assigned access roles or object grants through the controlled role hierarchy. That explains the role of “Authorization revocation separates identity lifecycle from destructive changes to stored data”, but the present requirement calls for “Automated or assisted classification helps discover and manage sensitive data across a large catalog”: This mechanism explains why the proposed action fits the scenario: Use supported data classification and semantic labeling to locate sensitive columns.
D:This mechanism explains why the proposed action fits the scenario: Analyze Snowflake cost and account usage records by metering category. That explains the role of “Compute, serverless features and storage have different cost drivers and should not be collapsed into one figure”, but the present requirement calls for “Automated or assisted classification helps discover and manage sensitive data across a large catalog”: This mechanism explains why the proposed action fits the scenario: Use supported data classification and semantic labeling to locate sensitive columns.
Question 322
An architecture reviewer proposes the following solution: Create a Snowflake task with an appropriate schedule and execution context. The business and technical requirement is: A daily transformation SQL statement should run at an established time even when nobody opens a worksheet. Which explanation most accurately justifies this choice?
- Pattern and prefix controls prevent unrelated files from being included in a data ingestion batch.
- File granularity and format affect parallelism and parsing overhead for warehouse-based loads.
- COPY INTO location supports unloading query output to stage files rather than adding rows to a table.
- Tasks execute statements on defined schedules, so manual worksheet sessions are unnecessary.
Explanation
Correct Answer
D:Tasks execute statements on defined schedules, so manual worksheet sessions are unnecessary. This mechanism explains why the proposed action fits the scenario: Create a Snowflake task with an appropriate schedule and execution context. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use COPY INTO with a carefully tested PATTERN or specific staged prefix. That explains the role of “Pattern and prefix controls prevent unrelated files from being included in a data ingestion batch”, but the present requirement calls for “Tasks execute statements on defined schedules, so manual worksheet sessions are unnecessary”: This mechanism explains why the proposed action fits the scenario: Create a Snowflake task with an appropriate schedule and execution context.
B:This mechanism explains why the proposed action fits the scenario: Tune staged file sizing and compression based on Snowflake loading best practices. That explains the role of “File granularity and format affect parallelism and parsing overhead for warehouse-based loads”, but the present requirement calls for “Tasks execute statements on defined schedules, so manual worksheet sessions are unnecessary”: This mechanism explains why the proposed action fits the scenario: Create a Snowflake task with an appropriate schedule and execution context.
C:This mechanism explains why the proposed action fits the scenario: Use COPY INTO an external stage location with an approved file format and storage integration. That explains the role of “COPY INTO location supports unloading query output to stage files rather than adding rows to a table”, but the present requirement calls for “Tasks execute statements on defined schedules, so manual worksheet sessions are unnecessary”: This mechanism explains why the proposed action fits the scenario: Create a Snowflake task with an appropriate schedule and execution context.
Question 323
An architecture reviewer proposes the following solution: Enable AUTO_RESUME after verifying user role USAGE and operational expectations. The business and technical requirement is: A team pauses a warehouse to reduce spending but users need queries to recover on the next scheduled dashboard refresh. Which explanation most accurately justifies this choice?
- Directory tables maintain a queryable file inventory instead of scanning raw object storage listings manually.
- A UDF encapsulates deterministic reusable expression logic in a governed database object.
- Document AI can extract structured information from unstructured documents but needs confidence and quality checks.
- A resumable warehouse starts compute on a permitted statement without an administrator manually restarting it.
Explanation
Correct Answer
D:A resumable warehouse starts compute on a permitted statement without an administrator manually restarting it. This mechanism explains why the proposed action fits the scenario: Enable AUTO_RESUME after verifying user role USAGE and operational expectations. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Enable or refresh supported stage directory tables and inspect their file metadata. That explains the role of “Directory tables maintain a queryable file inventory instead of scanning raw object storage listings manually”, but the present requirement calls for “A resumable warehouse starts compute on a permitted statement without an administrator manually restarting it”: This mechanism explains why the proposed action fits the scenario: Enable AUTO_RESUME after verifying user role USAGE and operational expectations.
B:This mechanism explains why the proposed action fits the scenario: Create a supported SQL UDF with clear input and output types. That explains the role of “A UDF encapsulates deterministic reusable expression logic in a governed database object”, but the present requirement calls for “A resumable warehouse starts compute on a permitted statement without an administrator manually restarting it”: This mechanism explains why the proposed action fits the scenario: Enable AUTO_RESUME after verifying user role USAGE and operational expectations.
C:This mechanism explains why the proposed action fits the scenario: Evaluate supported Snowflake document processing AI features with human validation gates. That explains the role of “Document AI can extract structured information from unstructured documents but needs confidence and quality checks”, but the present requirement calls for “A resumable warehouse starts compute on a permitted statement without an administrator manually restarting it”: This mechanism explains why the proposed action fits the scenario: Enable AUTO_RESUME after verifying user role USAGE and operational expectations.
Question 324
An architecture reviewer proposes the following solution: Configure authorized database replication and monitor refresh status. The business and technical requirement is: A data provider wants to synchronize a set of supported databases across two accounts without relying on nightly CSV exports. Which explanation most accurately justifies this choice?
- Secure views can project approved data to recipients while protecting provider-owned source logic and columns.
- Provider-owned grants control consumer access independently of data persistence.
- Replication propagates supported database state between accounts rather than rebuilding tables through files.
- Native Apps package provider logic and installable capabilities under a controlled privilege and lifecycle model.
Explanation
Correct Answer
C:Replication propagates supported database state between accounts rather than rebuilding tables through files. This mechanism explains why the proposed action fits the scenario: Configure authorized database replication and monitor refresh status. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Expose a governed secure view through a direct share rather than granting raw base-table access. That explains the role of “Secure views can project approved data to recipients while protecting provider-owned source logic and columns”, but the present requirement calls for “Replication propagates supported database state between accounts rather than rebuilding tables through files”: This mechanism explains why the proposed action fits the scenario: Configure authorized database replication and monitor refresh status.
B:This mechanism explains why the proposed action fits the scenario: Remove that consumer from the authorized share or revoke the relevant shared object grants. That explains the role of “Provider-owned grants control consumer access independently of data persistence”, but the present requirement calls for “Replication propagates supported database state between accounts rather than rebuilding tables through files”: This mechanism explains why the proposed action fits the scenario: Configure authorized database replication and monitor refresh status.
D:This mechanism explains why the proposed action fits the scenario: Evaluate the Snowflake Native App Framework and applicable Marketplace distribution options. That explains the role of “Native Apps package provider logic and installable capabilities under a controlled privilege and lifecycle model”, but the present requirement calls for “Replication propagates supported database state between accounts rather than rebuilding tables through files”: This mechanism explains why the proposed action fits the scenario: Configure authorized database replication and monitor refresh status.
Question 325
An architecture reviewer proposes the following solution: Rely on Snowflake-managed micro-partition metadata and inspect pruning in the query profile. The business and technical requirement is: A query planner needs table statistics to prune unnecessary micro-partitions before the physical execution phase. Which explanation most accurately justifies this choice?
- Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index.
- Permanent tables provide standard data protection behavior and Fail-safe subject to edition and retention settings.
- Materialized views persist selected computed results but impose storage and maintenance costs.
- Metadata such as value ranges helps the optimizer eliminate irrelevant partitions before expensive scans.
Explanation
Correct Answer
D:Metadata such as value ranges helps the optimizer eliminate irrelevant partitions before expensive scans. This mechanism explains why the proposed action fits the scenario: Rely on Snowflake-managed micro-partition metadata and inspect pruning in the query profile. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Evaluate clustering only against table size and selective range-filter access patterns. That explains the role of “Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index”, but the present requirement calls for “Metadata such as value ranges helps the optimizer eliminate irrelevant partitions before expensive scans”: This mechanism explains why the proposed action fits the scenario: Rely on Snowflake-managed micro-partition metadata and inspect pruning in the query profile.
B:This mechanism explains why the proposed action fits the scenario: Use a PERMANENT table with approved Time Travel retention. That explains the role of “Permanent tables provide standard data protection behavior and Fail-safe subject to edition and retention settings”, but the present requirement calls for “Metadata such as value ranges helps the optimizer eliminate irrelevant partitions before expensive scans”: This mechanism explains why the proposed action fits the scenario: Rely on Snowflake-managed micro-partition metadata and inspect pruning in the query profile.
C:This mechanism explains why the proposed action fits the scenario: Evaluate a materialized view for the stable expensive aggregation pattern and quantify upkeep cost. That explains the role of “Materialized views persist selected computed results but impose storage and maintenance costs”, but the present requirement calls for “Metadata such as value ranges helps the optimizer eliminate irrelevant partitions before expensive scans”: This mechanism explains why the proposed action fits the scenario: Rely on Snowflake-managed micro-partition metadata and inspect pruning in the query profile.
Question 326
An architecture reviewer proposes the following solution: Create and apply governed Snowflake object tags with approved allowed values where suitable. The business and technical requirement is: An organization wants consistent governance tags for data-owner department and retention category across database objects. Which explanation most accurately justifies this choice?
- Tags attach reusable metadata that downstream inventory and governance queries can evaluate.
- Non-password authentication reduces secrets exposure and supports controlled service identity lifecycle.
- Account activity history connects query operations to principals and execution context for investigation.
- MFA raises assurance beyond a single compromised password or reused secret.
Explanation
Correct Answer
A:Tags attach reusable metadata that downstream inventory and governance queries can evaluate. This mechanism explains why the proposed action fits the scenario: Create and apply governed Snowflake object tags with approved allowed values where suitable. Confirm the design against supported platform behavior.
Incorrect Answers
B:This mechanism explains why the proposed action fits the scenario: Configure Snowflake-supported key-pair or approved token authentication and rotate credentials securely. That explains the role of “Non-password authentication reduces secrets exposure and supports controlled service identity lifecycle”, but the present requirement calls for “Tags attach reusable metadata that downstream inventory and governance queries can evaluate”: This mechanism explains why the proposed action fits the scenario: Create and apply governed Snowflake object tags with approved allowed values where suitable.
C:This mechanism explains why the proposed action fits the scenario: Inspect Snowflake access and query history using properly privileged monitoring views. That explains the role of “Account activity history connects query operations to principals and execution context for investigation”, but the present requirement calls for “Tags attach reusable metadata that downstream inventory and governance queries can evaluate”: This mechanism explains why the proposed action fits the scenario: Create and apply governed Snowflake object tags with approved allowed values where suitable.
D:This mechanism explains why the proposed action fits the scenario: Enforce the supported MFA and authentication policy for the target user population. That explains the role of “MFA raises assurance beyond a single compromised password or reused secret”, but the present requirement calls for “Tags attach reusable metadata that downstream inventory and governance queries can evaluate”: This mechanism explains why the proposed action fits the scenario: Create and apply governed Snowflake object tags with approved allowed values where suitable.
Question 327
An architecture reviewer proposes the following solution: Create a supported task graph with dependency links between tasks. The business and technical requirement is: A pipeline must run cleansing only after ingestion validation succeeds, then refresh a reporting table. Which explanation most accurately justifies this choice?
- JDBC enables programmatic Java SQL access while Snowflake roles govern object permissions.
- The ODBC interface is designed for compatible reporting clients rather than a one-off SQL worksheet.
- Task DAGs express ordered execution and permit management of dependent pipeline steps.
- The supported connector provides SQL execution over an authenticated client session.
Explanation
Correct Answer
C:Task DAGs express ordered execution and permit management of dependent pipeline steps. This mechanism explains why the proposed action fits the scenario: Create a supported task graph with dependency links between tasks. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use the supported Snowflake JDBC driver with correct account and authentication configuration. That explains the role of “JDBC enables programmatic Java SQL access while Snowflake roles govern object permissions”, but the present requirement calls for “Task DAGs express ordered execution and permit management of dependent pipeline steps”: This mechanism explains why the proposed action fits the scenario: Create a supported task graph with dependency links between tasks.
B:This mechanism explains why the proposed action fits the scenario: Configure a Snowflake ODBC driver and approved connection profile. That explains the role of “The ODBC interface is designed for compatible reporting clients rather than a one-off SQL worksheet”, but the present requirement calls for “Task DAGs express ordered execution and permit management of dependent pipeline steps”: This mechanism explains why the proposed action fits the scenario: Create a supported task graph with dependency links between tasks.
D:This mechanism explains why the proposed action fits the scenario: Use the official Snowflake Python Connector with the intended secure session settings. That explains the role of “The supported connector provides SQL execution over an authenticated client session”, but the present requirement calls for “Task DAGs express ordered execution and permit management of dependent pipeline steps”: This mechanism explains why the proposed action fits the scenario: Create a supported task graph with dependency links between tasks.
Question 328
An architecture reviewer proposes the following solution: Benchmark a smaller warehouse with representative query sizes and verify service-level objectives. The business and technical requirement is: A warehouse is oversized and finishing most queries in seconds while credits spike without any queueing. Which explanation most accurately justifies this choice?
- XML data requires format-aware parsing and path access rather than treating tags as CSV delimiters.
- Parsing JSON converts text into structured semi-structured values suitable for path operations.
- Path access reads nested semi-structured fields and absent paths require careful NULL semantics.
- Overprovisioned compute can waste credits; sizing should be driven by latency and load evidence.
Explanation
Correct Answer
D:Overprovisioned compute can waste credits; sizing should be driven by latency and load evidence. This mechanism explains why the proposed action fits the scenario: Benchmark a smaller warehouse with representative query sizes and verify service-level objectives. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use a supported XML file format and Snowflake XML parsing or query functions. That explains the role of “XML data requires format-aware parsing and path access rather than treating tags as CSV delimiters”, but the present requirement calls for “Overprovisioned compute can waste credits; sizing should be driven by latency and load evidence”: This mechanism explains why the proposed action fits the scenario: Benchmark a smaller warehouse with representative query sizes and verify service-level objectives.
B:This mechanism explains why the proposed action fits the scenario: Apply a supported PARSE_JSON conversion and store or query VARIANT values. That explains the role of “Parsing JSON converts text into structured semi-structured values suitable for path operations”, but the present requirement calls for “Overprovisioned compute can waste credits; sizing should be driven by latency and load evidence”: This mechanism explains why the proposed action fits the scenario: Benchmark a smaller warehouse with representative query sizes and verify service-level objectives.
C:This mechanism explains why the proposed action fits the scenario: Use VARIANT path traversal with a safe cast or null handling for optional attributes. That explains the role of “Path access reads nested semi-structured fields and absent paths require careful NULL semantics”, but the present requirement calls for “Overprovisioned compute can waste credits; sizing should be driven by latency and load evidence”: This mechanism explains why the proposed action fits the scenario: Benchmark a smaller warehouse with representative query sizes and verify service-level objectives.
Question 329
An architecture reviewer proposes the following solution: Distinguish same-environment clone use from supported cross-account or cross-region replication and failover. The business and technical requirement is: An administrator assumes any Zero-Copy Clone automatically replaces a multi-region disaster-recovery replication plan. Which explanation most accurately justifies this choice?
- Marketplace listings provide discovery and subscription workflows beyond an ad-hoc bilateral share.
- Cloning and replication solve different recovery boundaries; a local test clone is not geographic resilience.
- Individual product authorization reduces inadvertent cross-tenant data access.
- A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks.
Explanation
Correct Answer
B:Cloning and replication solve different recovery boundaries; a local test clone is not geographic resilience. This mechanism explains why the proposed action fits the scenario: Distinguish same-environment clone use from supported cross-account or cross-region replication and failover. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Create an approved Snowflake Marketplace listing for the supported data product. That explains the role of “Marketplace listings provide discovery and subscription workflows beyond an ad-hoc bilateral share”, but the present requirement calls for “Cloning and replication solve different recovery boundaries; a local test clone is not geographic resilience”: This mechanism explains why the proposed action fits the scenario: Distinguish same-environment clone use from supported cross-account or cross-region replication and failover.
C:This mechanism explains why the proposed action fits the scenario: Use separate secured listings or shares with scoped recipients and approved views. That explains the role of “Individual product authorization reduces inadvertent cross-tenant data access”, but the present requirement calls for “Cloning and replication solve different recovery boundaries; a local test clone is not geographic resilience”: This mechanism explains why the proposed action fits the scenario: Distinguish same-environment clone use from supported cross-account or cross-region replication and failover.
D:This mechanism explains why the proposed action fits the scenario: Use CREATE DATABASE CLONE with supported Time Travel options where applicable. That explains the role of “A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks”, but the present requirement calls for “Cloning and replication solve different recovery boundaries; a local test clone is not geographic resilience”: This mechanism explains why the proposed action fits the scenario: Distinguish same-environment clone use from supported cross-account or cross-region replication and failover.
Question 330
An architecture reviewer proposes the following solution: Use Snowsight worksheets with the intended role, database, schema and warehouse context. The business and technical requirement is: A new developer wants to write SQL in the Snowflake web interface with saved worksheets and query history. Which explanation most accurately justifies this choice?
- Iceberg tables support open table storage metadata with specific Snowflake and external catalog ownership modes.
- Independent compute clusters prevent one job from directly consuming the other's warehouse CPUs while sharing managed data.
- Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions.
- Independent warehouses isolate compute usage and query queues even though both read the same storage objects.
Explanation
Correct Answer
C:Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions. This mechanism explains why the proposed action fits the scenario: Use Snowsight worksheets with the intended role, database, schema and warehouse context. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Evaluate a supported externally managed Iceberg table and compatible catalog integration. That explains the role of “Iceberg tables support open table storage metadata with specific Snowflake and external catalog ownership modes”, but the present requirement calls for “Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions”: This mechanism explains why the proposed action fits the scenario: Use Snowsight worksheets with the intended role, database, schema and warehouse context.
B:This mechanism explains why the proposed action fits the scenario: Allocate distinct warehouses to the jobs and use the same authorized database storage objects. That explains the role of “Independent compute clusters prevent one job from directly consuming the other's warehouse CPUs while sharing managed data”, but the present requirement calls for “Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions”: This mechanism explains why the proposed action fits the scenario: Use Snowsight worksheets with the intended role, database, schema and warehouse context.
D:This mechanism explains why the proposed action fits the scenario: Assign each workload its own virtual warehouse while retaining the common tables. That explains the role of “Independent warehouses isolate compute usage and query queues even though both read the same storage objects”, but the present requirement calls for “Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions”: This mechanism explains why the proposed action fits the scenario: Use Snowsight worksheets with the intended role, database, schema and warehouse context.