SnowPro Core COF-C03 Practice Test 48
Question 470
An architecture reviewer proposes the following solution: Assign each workload its own virtual warehouse while retaining the common tables. The business and technical requirement is: Two BI departments need the same customer dataset but one workload routinely overwhelms the other's queries. Which explanation most accurately justifies this choice?
- Independent warehouses isolate compute usage and query queues even though both read the same storage objects.
- JDBC provides a programmatic database connection for Java applications rather than a browser-only session.
- Client preferences can set active role or warehouse, and implicit defaults may surprise administrators.
- Immutable columnar micro-partitions contain metadata that lets the optimizer avoid unrelated data ranges.
Explanation
Correct Answer
A:Independent warehouses isolate compute usage and query queues even though both read the same storage objects. This mechanism explains why the proposed action fits the scenario: Assign each workload its own virtual warehouse while retaining the common tables. Confirm the design against supported platform behavior.
Incorrect Answers
B:This mechanism explains why the proposed action fits the scenario: Use the Snowflake JDBC driver with the approved credentials and network policy. That explains the role of “JDBC provides a programmatic database connection for Java applications rather than a browser-only session”, but the present requirement calls for “Independent warehouses isolate compute usage and query queues even though both read the same storage objects”: This mechanism explains why the proposed action fits the scenario: Assign each workload its own virtual warehouse while retaining the common tables.
C:This mechanism explains why the proposed action fits the scenario: Inspect session context through SQL functions and connection metadata. That explains the role of “Client preferences can set active role or warehouse, and implicit defaults may surprise administrators”, but the present requirement calls for “Independent warehouses isolate compute usage and query queues even though both read the same storage objects”: This mechanism explains why the proposed action fits the scenario: Assign each workload its own virtual warehouse while retaining the common tables.
D:This mechanism explains why the proposed action fits the scenario: Use Snowflake micro-partition metadata and pruning before adding unnecessary indexes. That explains the role of “Immutable columnar micro-partitions contain metadata that lets the optimizer avoid unrelated data ranges”, but the present requirement calls for “Independent warehouses isolate compute usage and query queues even though both read the same storage objects”: This mechanism explains why the proposed action fits the scenario: Assign each workload its own virtual warehouse while retaining the common tables.
Question 471
An architecture reviewer proposes the following solution: Create the intended role hierarchy using role-to-role grants. The business and technical requirement is: A team wants employees to inherit existing report-reader grants when promoted to a new support-supervisor role. Which explanation most accurately justifies this choice?
- Masking policies condition returned column values based on authorized execution context.
- Role inheritance supplies lower-role privileges to authorized higher roles without copying every object grant manually.
- Data lineage reveals how downstream analytical objects depend on upstream sources.
- Policy definitions themselves are security-sensitive assets and should not be editable by ordinary readers.
Explanation
Correct Answer
B:Role inheritance supplies lower-role privileges to authorized higher roles without copying every object grant manually. This mechanism explains why the proposed action fits the scenario: Create the intended role hierarchy using role-to-role grants. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Attach an appropriate dynamic data masking policy to protected columns. That explains the role of “Masking policies condition returned column values based on authorized execution context”, but the present requirement calls for “Role inheritance supplies lower-role privileges to authorized higher roles without copying every object grant manually”: This mechanism explains why the proposed action fits the scenario: Create the intended role hierarchy using role-to-role grants.
C:This mechanism explains why the proposed action fits the scenario: Inspect supported Snowflake data lineage for the table and view dependency chain. That explains the role of “Data lineage reveals how downstream analytical objects depend on upstream sources”, but the present requirement calls for “Role inheritance supplies lower-role privileges to authorized higher roles without copying every object grant manually”: This mechanism explains why the proposed action fits the scenario: Create the intended role hierarchy using role-to-role grants.
D:This mechanism explains why the proposed action fits the scenario: Delegate policy management to a controlled governance role and review ownership and grants. That explains the role of “Policy definitions themselves are security-sensitive assets and should not be editable by ordinary readers”, but the present requirement calls for “Role inheritance supplies lower-role privileges to authorized higher roles without copying every object grant manually”: This mechanism explains why the proposed action fits the scenario: Create the intended role hierarchy using role-to-role grants.
Question 472
An architecture reviewer proposes the following solution: Use a supported Snowflake storage integration for delegated cloud storage access. The business and technical requirement is: An organization wants recurring data loads from cloud storage but must not store permanent cloud access keys in stage DDL. Which explanation most accurately justifies this choice?
- API integrations govern external-service invocation by Snowflake SQL functions under controlled permissions.
- Dynamic tables manage transformations and refresh scheduling toward a freshness target rather than an exact fixed interval.
- Storage integrations manage cloud authentication using controlled trust and permission assignments.
- A task definition may exist yet remain suspended or unable to run under its effective owner privileges.
Explanation
Correct Answer
C:Storage integrations manage cloud authentication using controlled trust and permission assignments. This mechanism explains why the proposed action fits the scenario: Use a supported Snowflake storage integration for delegated cloud storage access. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Configure a supported API integration with the required external-function security boundary. That explains the role of “API integrations govern external-service invocation by Snowflake SQL functions under controlled permissions”, but the present requirement calls for “Storage integrations manage cloud authentication using controlled trust and permission assignments”: This mechanism explains why the proposed action fits the scenario: Use a supported Snowflake storage integration for delegated cloud storage access.
B:This mechanism explains why the proposed action fits the scenario: Create an eligible dynamic table with TARGET_LAG and a refresh warehouse. That explains the role of “Dynamic tables manage transformations and refresh scheduling toward a freshness target rather than an exact fixed interval”, but the present requirement calls for “Storage integrations manage cloud authentication using controlled trust and permission assignments”: This mechanism explains why the proposed action fits the scenario: Use a supported Snowflake storage integration for delegated cloud storage access.
D:This mechanism explains why the proposed action fits the scenario: Restore the intended task schedule and EXECUTE TASK privileges then RESUME through approved workflow. That explains the role of “A task definition may exist yet remain suspended or unable to run under its effective owner privileges”, but the present requirement calls for “Storage integrations manage cloud authentication using controlled trust and permission assignments”: This mechanism explains why the proposed action fits the scenario: Use a supported Snowflake storage integration for delegated cloud storage access.
Question 473
An architecture reviewer proposes the following solution: Evaluate a materialized view for the stable aggregation with monitored storage and maintenance costs. The business and technical requirement is: A query performs an expensive repeated aggregate over slowly changing source data for a frequently used dashboard. Which explanation most accurately justifies this choice?
- Materialized views store selected precomputed results that can reduce repeated execution work.
- A specialized warehouse might provide better memory characteristics for supported Snowpark jobs.
- LAG accesses preceding rows in a defined sequence without an expensive self-join for each offset.
- Array access supports positional extraction from nested semi-structured values.
Explanation
Correct Answer
A:Materialized views store selected precomputed results that can reduce repeated execution work. This mechanism explains why the proposed action fits the scenario: Evaluate a materialized view for the stable aggregation with monitored storage and maintenance costs. Confirm the design against supported platform behavior.
Incorrect Answers
B:This mechanism explains why the proposed action fits the scenario: Test supported Snowpark-optimized warehouse types against the workload's memory and runtime demands. That explains the role of “A specialized warehouse might provide better memory characteristics for supported Snowpark jobs”, but the present requirement calls for “Materialized views store selected precomputed results that can reduce repeated execution work”: This mechanism explains why the proposed action fits the scenario: Evaluate a materialized view for the stable aggregation with monitored storage and maintenance costs.
C:This mechanism explains why the proposed action fits the scenario: Use LAG in a partitioned, ordered window expression. That explains the role of “LAG accesses preceding rows in a defined sequence without an expensive self-join for each offset”, but the present requirement calls for “Materialized views store selected precomputed results that can reduce repeated execution work”: This mechanism explains why the proposed action fits the scenario: Evaluate a materialized view for the stable aggregation with monitored storage and maintenance costs.
D:This mechanism explains why the proposed action fits the scenario: Use Snowflake VARIANT array indexing with appropriate type casting. That explains the role of “Array access supports positional extraction from nested semi-structured values”, but the present requirement calls for “Materialized views store selected precomputed results that can reduce repeated execution work”: This mechanism explains why the proposed action fits the scenario: Evaluate a materialized view for the stable aggregation with monitored storage and maintenance costs.
Question 474
An architecture reviewer proposes the following solution: Use CREATE DATABASE CLONE with supported Time Travel options where applicable. The business and technical requirement is: A team wants a recoverable copy of a database before applying a risky transformation migration. Which explanation most accurately justifies this choice?
- Reader accounts support consumers without a preexisting Snowflake account under provider-managed arrangements.
- A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks.
- Native Apps package provider logic and installable capabilities under a controlled privilege and lifecycle model.
- Cross-account access requires the provider to grant the intended objects and containing namespace appropriately.
Explanation
Correct Answer
B:A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks. This mechanism explains why the proposed action fits the scenario: Use CREATE DATABASE CLONE with supported Time Travel options where applicable. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use an approved Snowflake Reader Account managed through the provider's sharing workflow. That explains the role of “Reader accounts support consumers without a preexisting Snowflake account under provider-managed arrangements”, but the present requirement calls for “A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks”: This mechanism explains why the proposed action fits the scenario: Use CREATE DATABASE CLONE with supported Time Travel options where applicable.
C: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 “A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks”: This mechanism explains why the proposed action fits the scenario: Use CREATE DATABASE CLONE with supported Time Travel options where applicable.
D:This mechanism explains why the proposed action fits the scenario: Verify share grants and the required database and schema object privileges in the provider account. That explains the role of “Cross-account access requires the provider to grant the intended objects and containing namespace appropriately”, but the present requirement calls for “A zero-copy clone provides an independent logical namespace initially sharing unchanged storage blocks”: This mechanism explains why the proposed action fits the scenario: Use CREATE DATABASE CLONE with supported Time Travel options where applicable.
Question 475
An architecture reviewer proposes the following solution: Evaluate Snowflake Secure Data Sharing as a governed cross-account access pattern. The business and technical requirement is: A regional company wants analysts to exchange authorized datasets without manually shipping full database extracts every night. Which explanation most accurately justifies this choice?
- Programmatic connectivity should use managed secrets or stronger approved authentication rather than exposing passwords.
- Workload warehouse separation isolates query contention and cost attribution across departments.
- Native applications bundle data-platform functionality for controlled installation rather than giving recipients unrestricted SQL source access.
- Secure sharing allows a consumer to query data that the provider authorizes without creating its own full copied dataset.
Explanation
Correct Answer
D:Secure sharing allows a consumer to query data that the provider authorizes without creating its own full copied dataset. This mechanism explains why the proposed action fits the scenario: Evaluate Snowflake Secure Data Sharing as a governed cross-account access pattern. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Move authentication to supported secure identity or credential storage and remove literals from source. That explains the role of “Programmatic connectivity should use managed secrets or stronger approved authentication rather than exposing passwords”, but the present requirement calls for “Secure sharing allows a consumer to query data that the provider authorizes without creating its own full copied dataset”: This mechanism explains why the proposed action fits the scenario: Evaluate Snowflake Secure Data Sharing as a governed cross-account access pattern.
B:This mechanism explains why the proposed action fits the scenario: Assign ingestion to its own appropriately sized virtual warehouse. That explains the role of “Workload warehouse separation isolates query contention and cost attribution across departments”, but the present requirement calls for “Secure sharing allows a consumer to query data that the provider authorizes without creating its own full copied dataset”: This mechanism explains why the proposed action fits the scenario: Evaluate Snowflake Secure Data Sharing as a governed cross-account access pattern.
C:This mechanism explains why the proposed action fits the scenario: Evaluate Snowflake Native App Framework for the supported distribution pattern. That explains the role of “Native applications bundle data-platform functionality for controlled installation rather than giving recipients unrestricted SQL source access”, but the present requirement calls for “Secure sharing allows a consumer to query data that the provider authorizes without creating its own full copied dataset”: This mechanism explains why the proposed action fits the scenario: Evaluate Snowflake Secure Data Sharing as a governed cross-account access pattern.
Question 476
An architecture reviewer proposes the following solution: Grant the necessary ancestor object USAGE privileges to the intended role. The business and technical requirement is: A report fails because the session's current role does not have USAGE on the database and schema despite SELECT on the table. Which explanation most accurately justifies this choice?
- Centralized posture views help detect configuration and security risks that object grants alone miss.
- Current warehouse size alone omits runtime, concurrency, and independent serverless consumption.
- Accessing a table generally requires appropriate usage through the containing database and schema in addition to table rights.
- Idle warehouse compute incurs credit costs until suspended; configuration can prevent recurring waste.
Explanation
Correct Answer
C:Accessing a table generally requires appropriate usage through the containing database and schema in addition to table rights. This mechanism explains why the proposed action fits the scenario: Grant the necessary ancestor object USAGE privileges to the intended role. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Review Snowflake Trust Center findings and supported remediation recommendations. That explains the role of “Centralized posture views help detect configuration and security risks that object grants alone miss”, but the present requirement calls for “Accessing a table generally requires appropriate usage through the containing database and schema in addition to table rights”: This mechanism explains why the proposed action fits the scenario: Grant the necessary ancestor object USAGE privileges to the intended role.
B:This mechanism explains why the proposed action fits the scenario: Evaluate hourly credit usage across all warehouses and Snowflake-managed services. That explains the role of “Current warehouse size alone omits runtime, concurrency, and independent serverless consumption”, but the present requirement calls for “Accessing a table generally requires appropriate usage through the containing database and schema in addition to table rights”: This mechanism explains why the proposed action fits the scenario: Grant the necessary ancestor object USAGE privileges to the intended role.
D:This mechanism explains why the proposed action fits the scenario: Use warehouse auto-suspend with monitored billing rather than depending on someone to stop it manually. That explains the role of “Idle warehouse compute incurs credit costs until suspended; configuration can prevent recurring waste”, but the present requirement calls for “Accessing a table generally requires appropriate usage through the containing database and schema in addition to table rights”: This mechanism explains why the proposed action fits the scenario: Grant the necessary ancestor object USAGE privileges to the intended role.
Question 477
An architecture reviewer proposes the following solution: Configure the CSV file format with the correct delimiter and enclosure options. The business and technical requirement is: A CSV feed sometimes includes delimiter characters inside quoted fields and naive loads split columns incorrectly. Which explanation most accurately justifies this choice?
- File-format parsing rules must match real source encoding and quote conventions.
- JDBC enables programmatic Java SQL access while Snowflake roles govern object permissions.
- DOWNSTREAM delegates refresh scheduling to dependent tables instead of maintaining an independent timer.
- Streams track the table changes visible between transactional consumption points without cloning the full table each time.
Explanation
Correct Answer
A:File-format parsing rules must match real source encoding and quote conventions. This mechanism explains why the proposed action fits the scenario: Configure the CSV file format with the correct delimiter and enclosure options. Confirm the design against supported platform behavior.
Incorrect Answers
B: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 “File-format parsing rules must match real source encoding and quote conventions”: This mechanism explains why the proposed action fits the scenario: Configure the CSV file format with the correct delimiter and enclosure options.
C:This mechanism explains why the proposed action fits the scenario: Set TARGET_LAG=DOWNSTREAM on the appropriate intermediate dynamic table. That explains the role of “DOWNSTREAM delegates refresh scheduling to dependent tables instead of maintaining an independent timer”, but the present requirement calls for “File-format parsing rules must match real source encoding and quote conventions”: This mechanism explains why the proposed action fits the scenario: Configure the CSV file format with the correct delimiter and enclosure options.
D:This mechanism explains why the proposed action fits the scenario: Create a stream on the source table to expose its change data capture records. That explains the role of “Streams track the table changes visible between transactional consumption points without cloning the full table each time”, but the present requirement calls for “File-format parsing rules must match real source encoding and quote conventions”: This mechanism explains why the proposed action fits the scenario: Configure the CSV file format with the correct delimiter and enclosure options.
Question 478
An architecture reviewer proposes the following solution: Consider Query Acceleration Service for eligible selective large scans and aggregations. The business and technical requirement is: A few exceptionally large analytical scans dominate warehouse runtime while ordinary queries are fast. Which explanation most accurately justifies this choice?
- Unstructured file access should respect stage privileges and expiry behavior instead of exposing raw bucket credentials.
- Independent compute minimizes competing memory, CPU and concurrency requirements.
- ECONOMY prioritizes fuller use of existing clusters before starting more compute.
- QAS can offload parts of supported long-running queries to shared compute resources.
Explanation
Correct Answer
D:QAS can offload parts of supported long-running queries to shared compute resources. This mechanism explains why the proposed action fits the scenario: Consider Query Acceleration Service for eligible selective large scans and aggregations. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use supported stage file access mechanisms and scoped file URLs with intended grants. That explains the role of “Unstructured file access should respect stage privileges and expiry behavior instead of exposing raw bucket credentials”, but the present requirement calls for “QAS can offload parts of supported long-running queries to shared compute resources”: This mechanism explains why the proposed action fits the scenario: Consider Query Acceleration Service for eligible selective large scans and aggregations.
B:This mechanism explains why the proposed action fits the scenario: Separate the interactive and transformation workloads into different warehouses. That explains the role of “Independent compute minimizes competing memory, CPU and concurrency requirements”, but the present requirement calls for “QAS can offload parts of supported long-running queries to shared compute resources”: This mechanism explains why the proposed action fits the scenario: Consider Query Acceleration Service for eligible selective large scans and aggregations.
C:This mechanism explains why the proposed action fits the scenario: Choose ECONOMY scaling policy for eligible multi-cluster auto-scale mode when overnight batch queries can wait to save compute credits. That explains the role of “ECONOMY prioritizes fuller use of existing clusters before starting more compute”, but the present requirement calls for “QAS can offload parts of supported long-running queries to shared compute resources”: This mechanism explains why the proposed action fits the scenario: Consider Query Acceleration Service for eligible selective large scans and aggregations.
Question 479
An architecture reviewer proposes the following solution: Explain that Fail-safe is Snowflake-assisted disaster recovery, not a user-queryable historical archive. The business and technical requirement is: An analyst thinks Snowflake Fail-safe allows immediate self-service SELECT against data from three months ago after Time Travel expired. Which explanation most accurately justifies this choice?
- Marketplace listings provide discovery and subscription workflows beyond an ad-hoc bilateral share.
- Time Travel plus cloning can capture retained historical state for independent testing when object support permits.
- Provider-owned grants control consumer access independently of data persistence.
- Fail-safe is a limited recovery layer after Time Travel for eligible permanent tables, not direct SQL Time Travel.
Explanation
Correct Answer
D:Fail-safe is a limited recovery layer after Time Travel for eligible permanent tables, not direct SQL Time Travel. This mechanism explains why the proposed action fits the scenario: Explain that Fail-safe is Snowflake-assisted disaster recovery, not a user-queryable historical archive. 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 “Fail-safe is a limited recovery layer after Time Travel for eligible permanent tables, not direct SQL Time Travel”: This mechanism explains why the proposed action fits the scenario: Explain that Fail-safe is Snowflake-assisted disaster recovery, not a user-queryable historical archive.
B:This mechanism explains why the proposed action fits the scenario: Create an eligible zero-copy clone at the supported Time Travel point and verify its schema. That explains the role of “Time Travel plus cloning can capture retained historical state for independent testing when object support permits”, but the present requirement calls for “Fail-safe is a limited recovery layer after Time Travel for eligible permanent tables, not direct SQL Time Travel”: This mechanism explains why the proposed action fits the scenario: Explain that Fail-safe is Snowflake-assisted disaster recovery, not a user-queryable historical archive.
C: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 “Fail-safe is a limited recovery layer after Time Travel for eligible permanent tables, not direct SQL Time Travel”: This mechanism explains why the proposed action fits the scenario: Explain that Fail-safe is Snowflake-assisted disaster recovery, not a user-queryable historical archive.
Question 480
An architecture reviewer proposes the following solution: Use Snowflake elastic compute with warehouse sizing and lifecycle policies rather than fixed on-premises servers. The business and technical requirement is: A business is comparing its own managed servers with an elastic cloud analytics platform to handle unpredictable reporting demand. Which explanation most accurately justifies this choice?
- Cloud services maintains catalog and optimizer metadata independently from the compute clusters that execute statements.
- Virtual warehouses allow compute provisioning and suspension independently of Snowflake-managed storage.
- Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern.
- Materialized views persist selected computed results but impose storage and maintenance costs.
Explanation
Correct Answer
B:Virtual warehouses allow compute provisioning and suspension independently of Snowflake-managed storage. This mechanism explains why the proposed action fits the scenario: Use Snowflake elastic compute with warehouse sizing and lifecycle policies rather than fixed on-premises servers. Confirm the design against supported platform behavior.
Incorrect Answers
A:This mechanism explains why the proposed action fits the scenario: Use the cloud services layer for metadata and transaction coordination and warehouse compute for query work. That explains the role of “Cloud services maintains catalog and optimizer metadata independently from the compute clusters that execute statements”, but the present requirement calls for “Virtual warehouses allow compute provisioning and suspension independently of Snowflake-managed storage”: This mechanism explains why the proposed action fits the scenario: Use Snowflake elastic compute with warehouse sizing and lifecycle policies rather than fixed on-premises servers.
C: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 “Virtual warehouses allow compute provisioning and suspension independently of Snowflake-managed storage”: This mechanism explains why the proposed action fits the scenario: Use Snowflake elastic compute with warehouse sizing and lifecycle policies rather than fixed on-premises servers.
D: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 “Virtual warehouses allow compute provisioning and suspension independently of Snowflake-managed storage”: This mechanism explains why the proposed action fits the scenario: Use Snowflake elastic compute with warehouse sizing and lifecycle policies rather than fixed on-premises servers.