SnowPro Core COF-C03 Practice Test 87
Question 860
A deployment team has configured this Snowflake capability: Create a view or secure view with the appropriate authorization model. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- The reporting service successfully connects and retrieves authorized columns.
- Authorized roles see only expected columns and unauthorized roles are denied source access.
- A controlled timeout test stops the excessive statement and idle compute later suspends.
- CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context.
Explanation
Correct Answer
B:Views define reusable query projections; they are different from full materialized table copies. The stated acceptance evidence is: Authorized roles see only expected columns and unauthorized roles are denied source access. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:ODBC supports data access from compatible client applications and integrates with standard Snowflake authentication. That explains the role of “The reporting service successfully connects and retrieves authorized columns”, but the present requirement calls for “Authorized roles see only expected columns and unauthorized roles are denied source access”: Views define reusable query projections; they are different from full materialized table copies.
C:Runtime limits and idle suspension control separate cost-risk conditions and should be verified independently. That explains the role of “A controlled timeout test stops the excessive statement and idle compute later suspends”, but the present requirement calls for “Authorized roles see only expected columns and unauthorized roles are denied source access”: Views define reusable query projections; they are different from full materialized table copies.
D:Client preferences can set active role or warehouse, and implicit defaults may surprise administrators. That explains the role of “CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context”, but the present requirement calls for “Authorized roles see only expected columns and unauthorized roles are denied source access”: Views define reusable query projections; they are different from full materialized table copies.
Question 861
A deployment team has configured this Snowflake capability: Use supported zero-copy cloning for the schema and validate dependent objects. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- Query history shows successful execution against source tables with no local data export requirement.
- The clone is ready quickly, initial storage growth is small and subsequent writes are isolated.
- An evaluation batch produces field values and low-confidence cases enter a review queue.
- Warehouse history shows suspension during idle periods and automatic restart on new work.
Explanation
Correct Answer
B:Cloning initially shares underlying immutable micro-partitions and creates a logically independent object namespace. The stated acceptance evidence is: The clone is ready quickly, initial storage growth is small and subsequent writes are isolated. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Snowflake runs analytical SQL where managed data resides, reducing avoidable exports and preserving governance controls. That explains the role of “Query history shows successful execution against source tables with no local data export requirement”, but the present requirement calls for “The clone is ready quickly, initial storage growth is small and subsequent writes are isolated”: Cloning initially shares underlying immutable micro-partitions and creates a logically independent object namespace.
C:Document-oriented AI extracts information from unstructured content but may require validation for difficult scans. That explains the role of “An evaluation batch produces field values and low-confidence cases enter a review queue”, but the present requirement calls for “The clone is ready quickly, initial storage growth is small and subsequent writes are isolated”: Cloning initially shares underlying immutable micro-partitions and creates a logically independent object namespace.
D:Auto-suspend stops idle compute while auto-resume restarts it for eligible queries. That explains the role of “Warehouse history shows suspension during idle periods and automatic restart on new work”, but the present requirement calls for “The clone is ready quickly, initial storage growth is small and subsequent writes are isolated”: Cloning initially shares underlying immutable micro-partitions and creates a logically independent object namespace.
Question 862
A deployment team has configured this Snowflake capability: Evaluate clustering only against table size and selective range-filter access patterns. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- Credit consumption and queued time are measured to confirm the desired cost-latency compromise.
- A repository scan finds no credential and the authenticated job still connects successfully.
- A known business question produces an inspectable SQL statement and correct authorized result.
- Clustering-depth and pruning statistics improve for the selected filter predicates.
Explanation
Correct Answer
D:Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index. The stated acceptance evidence is: Clustering-depth and pruning statistics improve for the selected filter predicates. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Economy favors better cluster utilization before adding parallel compute capacity. That explains the role of “Credit consumption and queued time are measured to confirm the desired cost-latency compromise”, but the present requirement calls for “Clustering-depth and pruning statistics improve for the selected filter predicates”: Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index.
B:Programmatic connectivity should use managed secrets or stronger approved authentication rather than exposing passwords. That explains the role of “A repository scan finds no credential and the authenticated job still connects successfully”, but the present requirement calls for “Clustering-depth and pruning statistics improve for the selected filter predicates”: Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index.
C:Cortex Analyst translates natural language over structured data using semantic information rather than retrieving raw document snippets. That explains the role of “A known business question produces an inspectable SQL statement and correct authorized result”, but the present requirement calls for “Clustering-depth and pruning statistics improve for the selected filter predicates”: Snowflake clustering reorganizes micro-partition locality and is not a user-managed row index.
Question 863
A deployment team has configured this Snowflake capability: Store semi-structured payloads in VARIANT and extract typed fields in downstream queries. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- The processing job meets its memory and runtime targets without unacceptable compute cost.
- A repository scan finds no credential and the authenticated job still connects successfully.
- The JSON path expressions return expected nested fields and data types.
- CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context.
Explanation
Correct Answer
C:VARIANT holds flexible structured values without forcing one rigid input schema for every record. The stated acceptance evidence is: The JSON path expressions return expected nested fields and data types. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Snowpark-optimized warehouses target resource-intensive Snowpark workloads rather than ordinary short SQL queries. That explains the role of “The processing job meets its memory and runtime targets without unacceptable compute cost”, but the present requirement calls for “The JSON path expressions return expected nested fields and data types”: VARIANT holds flexible structured values without forcing one rigid input schema for every record.
B:Programmatic connectivity should use managed secrets or stronger approved authentication rather than exposing passwords. That explains the role of “A repository scan finds no credential and the authenticated job still connects successfully”, but the present requirement calls for “The JSON path expressions return expected nested fields and data types”: VARIANT holds flexible structured values without forcing one rigid input schema for every record.
D:Client preferences can set active role or warehouse, and implicit defaults may surprise administrators. That explains the role of “CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context”, but the present requirement calls for “The JSON path expressions return expected nested fields and data types”: VARIANT holds flexible structured values without forcing one rigid input schema for every record.
Question 864
A deployment team has configured this Snowflake capability: Keep external table storage ownership and refresh metadata responsibilities explicit. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- The first authorized query after suspension succeeds and the warehouse transitions to STARTED.
- The worksheet executes the test query and its history displays the selected execution context.
- A suspended warehouse leaves the table and its stored bytes accessible after compute resumes.
- After an authorized metadata refresh, query results reflect the new external object listing.
Explanation
Correct Answer
D:External tables reference data outside Snowflake-managed table storage and require consistent metadata handling. The stated acceptance evidence is: After an authorized metadata refresh, query results reflect the new external object listing. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Auto-resume lets an eligible statement start stopped compute without manual intervention. That explains the role of “The first authorized query after suspension succeeds and the warehouse transitions to STARTED”, but the present requirement calls for “After an authorized metadata refresh, query results reflect the new external object listing”: External tables reference data outside Snowflake-managed table storage and require consistent metadata handling.
B:Snowsight provides the web authoring and monitoring interface while preserving normal SQL permissions. That explains the role of “The worksheet executes the test query and its history displays the selected execution context”, but the present requirement calls for “After an authorized metadata refresh, query results reflect the new external object listing”: External tables reference data outside Snowflake-managed table storage and require consistent metadata handling.
C:Snowflake stores optimized table data in cloud object storage, independently of transient warehouse compute. That explains the role of “A suspended warehouse leaves the table and its stored bytes accessible after compute resumes”, but the present requirement calls for “After an authorized metadata refresh, query results reflect the new external object listing”: External tables reference data outside Snowflake-managed table storage and require consistent metadata handling.
Question 865
A deployment team has configured this Snowflake capability: Evaluate supported Snowflake Cortex AI SQL functions under approved data security controls. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- Operations can create governed database objects without an infrastructure patching or local server installation workflow.
- A guarded SQL test produces a summary for approved test rows with expected warehouse or service charges.
- The table remains visible in metadata and can be queried after the warehouse is resumed.
- After the session closes, querying the temporary table from a new session fails as expected.
Explanation
Correct Answer
B:Cortex functions can perform language processing close to Snowflake data subject to availability and policy. The stated acceptance evidence is: A guarded SQL test produces a summary for approved test rows with expected warehouse or service charges. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Snowflake provisions and maintains platform infrastructure and service upgrades, leaving customers responsible for data and access design. That explains the role of “Operations can create governed database objects without an infrastructure patching or local server installation workflow”, but the present requirement calls for “A guarded SQL test produces a summary for approved test rows with expected warehouse or service charges”: Cortex functions can perform language processing close to Snowflake data subject to availability and policy.
C:Warehouse lifecycle controls active compute rather than durable database storage. That explains the role of “The table remains visible in metadata and can be queried after the warehouse is resumed”, but the present requirement calls for “A guarded SQL test produces a summary for approved test rows with expected warehouse or service charges”: Cortex functions can perform language processing close to Snowflake data subject to availability and policy.
D:Temporary tables have session lifetime, unlike permanent tables that persist independently of a session. That explains the role of “After the session closes, querying the temporary table from a new session fails as expected”, but the present requirement calls for “A guarded SQL test produces a summary for approved test rows with expected warehouse or service charges”: Cortex functions can perform language processing close to Snowflake data subject to availability and policy.
Question 866
A deployment team has configured this Snowflake capability: Use Cortex Analyst with an authorized semantic model for structured-data question answering. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- A corrected approved identity and network policy allows a session to establish before a query runs.
- The execution profile shows expensive operators and the warehouse's run state and spill metrics.
- After the session closes, querying the temporary table from a new session fails as expected.
- A known business question produces an inspectable SQL statement and correct authorized result.
Explanation
Correct Answer
D:Cortex Analyst translates natural language over structured data using semantic information rather than retrieving raw document snippets. The stated acceptance evidence is: A known business question produces an inspectable SQL statement and correct authorized result. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Connection and authentication failures precede warehouse execution and are not solved by adding compute capacity. That explains the role of “A corrected approved identity and network policy allows a session to establish before a query runs”, but the present requirement calls for “A known business question produces an inspectable SQL statement and correct authorized result”: Cortex Analyst translates natural language over structured data using semantic information rather than retrieving raw document snippets.
B:Joins and scans consume warehouse processing resources; healthy session services do not guarantee fast execution. That explains the role of “The execution profile shows expensive operators and the warehouse's run state and spill metrics”, but the present requirement calls for “A known business question produces an inspectable SQL statement and correct authorized result”: Cortex Analyst translates natural language over structured data using semantic information rather than retrieving raw document snippets.
C:Temporary tables have session lifetime, unlike permanent tables that persist independently of a session. That explains the role of “After the session closes, querying the temporary table from a new session fails as expected”, but the present requirement calls for “A known business question produces an inspectable SQL statement and correct authorized result”: Cortex Analyst translates natural language over structured data using semantic information rather than retrieving raw document snippets.
Question 867
A deployment team has configured this Snowflake capability: Use Cortex Search with an approved indexed unstructured text corpus. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- The query plan uses the materialized view and measured total costs meet the service objective.
- Known test queries retrieve the intended passages and respect documented access restrictions.
- Query history shows ETL statements running on the approved ETL warehouse.
- Warehouse load history shows reduced queueing during spikes under the chosen policy.
Explanation
Correct Answer
B:Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern. The stated acceptance evidence is: Known test queries retrieve the intended passages and respect documented access restrictions. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Materialized views persist selected computed results but impose storage and maintenance costs. That explains the role of “The query plan uses the materialized view and measured total costs meet the service objective”, but the present requirement calls for “Known test queries retrieve the intended passages and respect documented access restrictions”: Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern.
C:Session warehouse context controls the compute resource charged for a query. That explains the role of “Query history shows ETL statements running on the approved ETL warehouse”, but the present requirement calls for “Known test queries retrieve the intended passages and respect documented access restrictions”: Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern.
D:Standard policy starts clusters more aggressively to limit waiting under rising concurrency. That explains the role of “Warehouse load history shows reduced queueing during spikes under the chosen policy”, but the present requirement calls for “Known test queries retrieve the intended passages and respect documented access restrictions”: Search provides semantic retrieval over textual content for a retrieval-augmented question-answering pattern.
Question 868
A deployment team has configured this Snowflake capability: Use Snowflake Notebooks where available with governed compute and access. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- Object definitions remain available after the active warehouse suspends.
- A notebook executes Python and SQL cells using the intended role and records reproducible outputs.
- The contracted environment meets documented dedicated deployment and regulatory constraints.
- Query history shows successful execution against source tables with no local data export requirement.
Explanation
Correct Answer
B:Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports. The stated acceptance evidence is: A notebook executes Python and SQL cells using the intended role and records reproducible outputs. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Cloud services maintains catalog and optimizer metadata independently from the compute clusters that execute statements. That explains the role of “Object definitions remain available after the active warehouse suspends”, but the present requirement calls for “A notebook executes Python and SQL cells using the intended role and records reproducible outputs”: Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports.
C:VPS is a specialized Snowflake deployment model for organizations with heightened isolation requirements. That explains the role of “The contracted environment meets documented dedicated deployment and regulatory constraints”, but the present requirement calls for “A notebook executes Python and SQL cells using the intended role and records reproducible outputs”: Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports.
D:Snowflake runs analytical SQL where managed data resides, reducing avoidable exports and preserving governance controls. That explains the role of “Query history shows successful execution against source tables with no local data export requirement”, but the present requirement calls for “A notebook executes Python and SQL cells using the intended role and records reproducible outputs”: Native notebooks support iterative code, SQL and visual analysis without requiring uncontrolled data exports.
Question 869
A deployment team has configured this Snowflake capability: Use Streamlit in Snowflake for the approved internal application pattern. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- An approved user opens the Streamlit application and sees current authorized table results.
- Query history shows successful execution against source tables with no local data export requirement.
- CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context.
- A controlled timeout test stops the excessive statement and idle compute later suspends.
Explanation
Correct Answer
A:Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls. The stated acceptance evidence is: An approved user opens the Streamlit application and sees current authorized table results. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
B:Snowflake runs analytical SQL where managed data resides, reducing avoidable exports and preserving governance controls. That explains the role of “Query history shows successful execution against source tables with no local data export requirement”, but the present requirement calls for “An approved user opens the Streamlit application and sees current authorized table results”: Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls.
C:Client preferences can set active role or warehouse, and implicit defaults may surprise administrators. That explains the role of “CURRENT_ROLE and CURRENT_WAREHOUSE reflect the audited intended context”, but the present requirement calls for “An approved user opens the Streamlit application and sees current authorized table results”: Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls.
D:Runtime limits and idle suspension control separate cost-risk conditions and should be verified independently. That explains the role of “A controlled timeout test stops the excessive statement and idle compute later suspends”, but the present requirement calls for “An approved user opens the Streamlit application and sees current authorized table results”: Streamlit supports rapid Python application user interfaces with Snowflake-backed data and access controls.
Question 870
A deployment team has configured this Snowflake capability: Use the Snowpark DataFrame API in a supported Snowflake runtime. After promoting the configuration to the intended environment, auditors want observable evidence rather than a successful Save click. Which test outcome most convincingly verifies the capability is functioning as intended?
- Usage views distinguish warehouse credits from storage footprint over the reporting period.
- The revised profile shows lower remote spill and acceptable query latency at a measured credit cost.
- The reporting service successfully connects and retrieves authorized columns.
- The Snowpark job runs on the assigned warehouse and returns the expected transformed row set.
Explanation
Correct Answer
D:Snowpark expresses data operations that Snowflake can execute close to governed persisted data. The stated acceptance evidence is: The Snowpark job runs on the assigned warehouse and returns the expected transformed row set. Operational verification is stronger than an assumption based on saving a configuration.
Incorrect Answers
A:Compute and storage are independently metered in Snowflake and require different monitoring and control mechanisms. That explains the role of “Usage views distinguish warehouse credits from storage footprint over the reporting period”, but the present requirement calls for “The Snowpark job runs on the assigned warehouse and returns the expected transformed row set”: Snowpark expresses data operations that Snowflake can execute close to governed persisted data.
B:Larger warehouse sizes add processing and memory resources that can reduce spill for a single heavy query. That explains the role of “The revised profile shows lower remote spill and acceptable query latency at a measured credit cost”, but the present requirement calls for “The Snowpark job runs on the assigned warehouse and returns the expected transformed row set”: Snowpark expresses data operations that Snowflake can execute close to governed persisted data.
C:ODBC supports data access from compatible client applications and integrates with standard Snowflake authentication. That explains the role of “The reporting service successfully connects and retrieves authorized columns”, but the present requirement calls for “The Snowpark job runs on the assigned warehouse and returns the expected transformed row set”: Snowpark expresses data operations that Snowflake can execute close to governed persisted data.