Snowflake SnowPro Core COF-C03 Practice Test 19 - Prepaway
Practice Exams:

Pass Snowflake SnowPro Core COF-C03 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium Bundle
$14.99
$74.99 $89.98

SnowPro Core COF-C03 Premium Bundle


  • Premium File 116 Questions & Answers. Last update: Nov 17, 2026
  • Study Guide 222 Pages

Snowflake SnowPro Core COF-C03 Practice Test 19

Question 180

The Snowflake data engineering team at a regional bank plans to: Inspect dynamic table target lag, dependency graph, compute configuration and refresh policies under representative workload. The issue affecting customer risk analytics and branch transaction reports is: A dynamically refreshed reporting dataset is consistently older than the declared freshness target even though source tables update. Which finding best distinguishes this cause from other Snowflake failures?

  1. Task run history shows downstream execution is not gated on completion of the intended upstream dependency.
  2. Refresh history reports lag or scheduling constraints and downstream refresh dependencies exceed the configured target.
  3. Service traces show time spent creating and notifying object-storage files rather than processing incoming rows.
  4. The cloud storage path contains fresh files and the pipe is running, yet notification integration or event subscription is missing.

Correct Answer: B

Explanation

A.

Task run history shows downstream execution is not gated on completion of the intended upstream dependency. Task orchestration must represent data dependencies rather than assuming independent schedules stay aligned. For customer risk analytics and branch transaction reports at a regional bank, refresh history reports lag or scheduling constraints and downstream refresh dependencies exceed the configured target. Instead, inspect dynamic table target lag, dependency graph, compute configuration and refresh policies under representative workload.

B.

Refresh history reports lag or scheduling constraints and downstream refresh dependencies exceed the configured target. Dynamic tables maintain derived data through managed refresh behavior subject to supported target lag and compute. To address this, inspect dynamic table target lag, dependency graph, compute configuration and refresh policies under representative workload. Confirm that a seeded data change appears in the published table within the approved achievable freshness window.

C.

Service traces show time spent creating and notifying object-storage files rather than processing incoming rows. Snowpipe Streaming handles row or event ingestion differently from file-oriented Snowpipe. For customer risk analytics and branch transaction reports at a regional bank, refresh history reports lag or scheduling constraints and downstream refresh dependencies exceed the configured target. Instead, inspect dynamic table target lag, dependency graph, compute configuration and refresh policies under representative workload.

D.

The cloud storage path contains fresh files and the pipe is running, yet notification integration or event subscription is missing. Snowpipe file ingestion depends on event notification or an explicit REST request, not simply a stored pipe definition. For customer risk analytics and branch transaction reports at a regional bank, refresh history reports lag or scheduling constraints and downstream refresh dependencies exceed the configured target. Instead, inspect dynamic table target lag, dependency graph, compute configuration and refresh policies under representative workload.

Question 181

For sales aggregates and supplier order tracking at a wholesale retailer, an engineer diagnoses: A security team grants a database role to a user and expects the user to choose it directly as their active session role. The observation is: Role hierarchy records show the database role is not granted through an account role with supported activation. The response is: Grant the database role to an appropriate account role and grant that account role to approved users. Which principle best explains the decision?

  1. Database roles scope database privileges and are activated through account-role inheritance.
  2. Snowflake authorization can aggregate primary and enabled secondary role privileges.
  3. Snowflake role authorization must cover both referenced data and chosen execution warehouse.
  4. Snowflake authentication mechanisms should match workload identity and credential lifecycle needs.

Correct Answer: A

Explanation

A.

Database roles scope database privileges and are activated through account-role inheritance. For sales aggregates and supplier order tracking at a wholesale retailer, role hierarchy records show the database role is not granted through an account role with supported activation. The corresponding fix is to grant the database role to an appropriate account role and grant that account role to approved users. A successful test shows the user's supported active account role inherits authorized database object privileges but no unrelated account-wide access.

B.

Snowflake authorization can aggregate primary and enabled secondary role privileges. This choice does not explain the observed failure mechanism. For sales aggregates and supplier order tracking at a wholesale retailer, role hierarchy records show the database role is not granted through an account role with supported activation. The controlling principle is that database roles scope database privileges and are activated through account-role inheritance.

C.

Snowflake role authorization must cover both referenced data and chosen execution warehouse. This choice does not explain the observed failure mechanism. For sales aggregates and supplier order tracking at a wholesale retailer, role hierarchy records show the database role is not granted through an account role with supported activation. The controlling principle is that database roles scope database privileges and are activated through account-role inheritance.

D.

Snowflake authentication mechanisms should match workload identity and credential lifecycle needs. This choice does not explain the observed failure mechanism. For sales aggregates and supplier order tracking at a wholesale retailer, role hierarchy records show the database role is not granted through an account role with supported activation. The controlling principle is that database roles scope database privileges and are activated through account-role inheritance.

Question 182

An operations review of service ticket history and contracted usage billing at a managed service provider reports: An external small business lacks a Snowflake account, and an operator proposes a reader account with broad internal table visibility. The differentiating observation is: Reader-account role grants include schemas unrelated to the explicit shared reporting requirement. Which proposed fix and test pair most directly addresses the failure?

  1. Configure a supported secure data share with least privilege and document relevant region/account constraints. — verification: An authorized consumer queries the shared object while no unmanaged full dataset export is required.
  2. Use supported clean room constraints and approved collaboration templates to restrict outputs and data access. — verification: The approved overlap statistic is available while individual participant records cannot be exported.
  3. Create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. — verification: The partner reads the intended report but cannot enumerate unrelated provider data.
  4. Choose an appropriate private listing and governed access workflow before publishing the data product. — verification: Only authorized pilot consumers can discover and access the test listing while other accounts cannot.

Correct Answer: C

Explanation

A.

Configure a supported secure data share with least privilege and document relevant region/account constraints. Verify that an authorized consumer queries the shared object while no unmanaged full dataset export is required. This action and its verification do not address the identified failure together. For service ticket history and contracted usage billing at a managed service provider, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The appropriate correction is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. Confirm that the partner reads the intended report but cannot enumerate unrelated provider data.

B.

Use supported clean room constraints and approved collaboration templates to restrict outputs and data access. Verify that the approved overlap statistic is available while individual participant records cannot be exported. This action and its verification do not address the identified failure together. For service ticket history and contracted usage billing at a managed service provider, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The appropriate correction is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. Confirm that the partner reads the intended report but cannot enumerate unrelated provider data.

C.

Create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. Verify that the partner reads the intended report but cannot enumerate unrelated provider data. For service ticket history and contracted usage billing at a managed service provider, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. Reader accounts enable supported consumption without requiring a separate self-managed Snowflake account, but scope still matters.

D.

Choose an appropriate private listing and governed access workflow before publishing the data product. Verify that only authorized pilot consumers can discover and access the test listing while other accounts cannot. This action and its verification do not address the identified failure together. For service ticket history and contracted usage billing at a managed service provider, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The appropriate correction is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. Confirm that the partner reads the intended report but cannot enumerate unrelated provider data.

Question 183

The Snowflake data engineering team at a publishing group investigating subscription events and finance reporting notes: A deployment pipeline runs Snowflake SQL from a repository but pulls an unreviewed experimental branch in production. Evidence: Resolved Git repository stage or branch reference differs from the approved tagged release. They plan: Pin supported Git integration workflow to approved repository paths and immutable reviewed versions before execution. Which technical principle justifies the correction?

  1. Source integration needs version control and approval just like any other production schema deployment.
  2. External network and API integrations should constrain egress destinations and execution privileges.
  3. Snowflake connectivity spans internal roles and external provider identity policy.
  4. Unloading data creates an outbound data-governance boundary that requires destination authorization.

Correct Answer: A

Explanation

A.

Source integration needs version control and approval just like any other production schema deployment. For subscription events and finance reporting at a publishing group, resolved Git repository stage or branch reference differs from the approved tagged release. To correct it, pin supported Git integration workflow to approved repository paths and immutable reviewed versions before execution. A successful test shows a controlled release executes only reviewed SQL and rejects unapproved branch changes.

B.

External network and API integrations should constrain egress destinations and execution privileges. This choice does not explain the observed failure mechanism. For subscription events and finance reporting at a publishing group, resolved Git repository stage or branch reference differs from the approved tagged release. The controlling principle is that source integration needs version control and approval just like any other production schema deployment.

C.

Snowflake connectivity spans internal roles and external provider identity policy. This choice does not explain the observed failure mechanism. For subscription events and finance reporting at a publishing group, resolved Git repository stage or branch reference differs from the approved tagged release. The controlling principle is that source integration needs version control and approval just like any other production schema deployment.

D.

Unloading data creates an outbound data-governance boundary that requires destination authorization. This choice does not explain the observed failure mechanism. For subscription events and finance reporting at a publishing group, resolved Git repository stage or branch reference differs from the approved tagged release. The controlling principle is that source integration needs version control and approval just like any other production schema deployment.

Question 184

Administrators at a payments processor plan: Reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. They are addressing the following problem in settlement reconciliation and fraud-monitoring datasets: An integration user loses the ability to list cloud object files after a cloud IAM role policy change. Which test demonstrates resolution?

  1. A controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.
  2. A permitted endpoint call works while an unrelated destination cannot be contacted through the integration.
  3. A test client reads the sanctioned table and remains unable to query a restricted table.
  4. A controlled release executes only reviewed SQL and rejects unapproved branch changes.

Correct Answer: A

Explanation

A.

A controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Snowflake connectivity spans internal roles and external provider identity policy. To address this, reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access.

B.

A permitted endpoint call works while an unrelated destination cannot be contacted through the integration. External network and API integrations should constrain egress destinations and execution privileges. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Verify that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

C.

A test client reads the sanctioned table and remains unable to query a restricted table. Snowflake drivers inherit or specify security and execution context separately from successful transport authentication. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Verify that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

D.

A controlled release executes only reviewed SQL and rejects unapproved branch changes. Source integration needs version control and approval just like any other production schema deployment. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Verify that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

Question 185

An operations review of settlement reconciliation and fraud-monitoring datasets at a payments processor reports: An integration user loses the ability to list cloud object files after a cloud IAM role policy change. The differentiating observation is: Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Which proposed fix and test pair most directly addresses the failure?

  1. Define a scoped supported API integration with reviewed network rules and controlled invocation privileges. — verification: A permitted endpoint call works while an unrelated destination cannot be contacted through the integration.
  2. Set and audit approved client connection role, warehouse and namespace parameters with least privilege. — verification: A test client reads the sanctioned table and remains unable to query a restricted table.
  3. Validate supported stage directory table refresh or notification configuration with file access privileges. — verification: A controlled new document appears in the governed directory inventory and is retrievable by approved users.
  4. Reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. — verification: A controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

Correct Answer: D

Explanation

A.

Define a scoped supported API integration with reviewed network rules and controlled invocation privileges. Verify that a permitted endpoint call works while an unrelated destination cannot be contacted through the integration. This action and its verification do not address the identified failure together. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. The appropriate correction is to reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. Confirm that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

B.

Set and audit approved client connection role, warehouse and namespace parameters with least privilege. Verify that a test client reads the sanctioned table and remains unable to query a restricted table. This action and its verification do not address the identified failure together. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. The appropriate correction is to reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. Confirm that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

C.

Validate supported stage directory table refresh or notification configuration with file access privileges. Verify that a controlled new document appears in the governed directory inventory and is retrievable by approved users. This action and its verification do not address the identified failure together. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. The appropriate correction is to reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. Confirm that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible.

D.

Reconcile supported external cloud IAM trust and path permissions for the Snowflake storage integration without adding broad access. Verify that a controlled staged-file list succeeds for approved prefixes and a disallowed prefix remains inaccessible. For settlement reconciliation and fraud-monitoring datasets at a payments processor, Snowflake storage integration remains defined but external cloud audit logs show denied object reads by the delegated principal. Snowflake connectivity spans internal roles and external provider identity policy.

Question 186

The Snowflake data engineering case at a telecommunications provider concerns network event logs and account churn models. Problem: A team turns on query acceleration for a workload whose results are incorrect because of a many-to-many join explosion. Evidence: Execution profile shows large row fan-out and the correctness test fails even when extra compute is available. Which paired corrective action and verification is best?

  1. Fix join semantics first and evaluate supported acceleration only after the query returns correct results. — verification: A validated query produces correct row counts and any enabled acceleration demonstrably improves measured runtime.
  2. Choose an optimization suited to large aggregate access, such as SQL restructuring or appropriate precomputation, after benchmarking. — verification: The aggregate meets target runtime with a documented cost tradeoff and no unnecessary search-index expense.
  3. Evaluate materialized view usage, maintenance and alternatives before retaining the precomputation. — verification: The revised approach meets report SLA at lower combined query and maintenance cost.
  4. Correct join cardinality or pre-aggregate event data at the required grain before publishing financial metrics. — verification: A seeded order contributes its intended total once and query row expansion returns to expected levels.

Correct Answer: A

Explanation

A.

Fix join semantics first and evaluate supported acceleration only after the query returns correct results. Verify that a validated query produces correct row counts and any enabled acceleration demonstrably improves measured runtime. For network event logs and account churn models at a telecommunications provider, execution profile shows large row fan-out and the correctness test fails even when extra compute is available. Extra query compute cannot correct incorrect SQL semantics.

B.

Choose an optimization suited to large aggregate access, such as SQL restructuring or appropriate precomputation, after benchmarking. Verify that the aggregate meets target runtime with a documented cost tradeoff and no unnecessary search-index expense. Search optimization is designed for selective access patterns, not all-table analytic scans. For network event logs and account churn models at a telecommunications provider, execution profile shows large row fan-out and the correctness test fails even when extra compute is available. The appropriate correction is to fix join semantics first and evaluate supported acceleration only after the query returns correct results. Confirm that a validated query produces correct row counts and any enabled acceleration demonstrably improves measured runtime.

C.

Evaluate materialized view usage, maintenance and alternatives before retaining the precomputation. Verify that the revised approach meets report SLA at lower combined query and maintenance cost. Materialized views trade faster repeated reads for storage and refresh maintenance. For network event logs and account churn models at a telecommunications provider, execution profile shows large row fan-out and the correctness test fails even when extra compute is available. The appropriate correction is to fix join semantics first and evaluate supported acceleration only after the query returns correct results. Confirm that a validated query produces correct row counts and any enabled acceleration demonstrably improves measured runtime.

D.

Correct join cardinality or pre-aggregate event data at the required grain before publishing financial metrics. Verify that a seeded order contributes its intended total once and query row expansion returns to expected levels. Join cardinality affects both query cost and semantic result correctness. For network event logs and account churn models at a telecommunications provider, execution profile shows large row fan-out and the correctness test fails even when extra compute is available. The appropriate correction is to fix join semantics first and evaluate supported acceleration only after the query returns correct results. Confirm that a validated query produces correct row counts and any enabled acceleration demonstrably improves measured runtime.

Question 187

At a telecommunications provider, a Snowflake analyst supporting network event logs and account churn models finds: Business users ask an AI analyst for net revenue but the semantic model describes gross invoice amount as net revenue. They confirm: Generated SQL and semantic-model metrics select the wrong field even though source invoice rows are accurate. Select the action and acceptance-test pair best matched to these facts.

  1. Inspect Cortex Search service ingestion, refresh and source selection, then validate indexed content access and freshness. — verification: A controlled search locates the approved updated policy while respecting source access constraints.
  2. Review and correct the approved semantic model metric definition and test natural-language-to-SQL outputs against reference cases. — verification: The seeded net-revenue query matches a reviewed SQL baseline across sample periods.
  3. Align supported Streamlit execution context, app roles and underlying data access with intended user audiences. — verification: A permitted viewer sees only approved aggregates and cannot retrieve underlying restricted rows.
  4. Evaluate a supported Snowpark DataFrame or UDF design with governed package access and verify execution near Snowflake data. — verification: A representative transformation completes without bulk workstation export and produces matching approved results.

Correct Answer: B

Explanation

A.

Inspect Cortex Search service ingestion, refresh and source selection, then validate indexed content access and freshness. Verify that a controlled search locates the approved updated policy while respecting source access constraints. A retrieval service needs its own indexed-data freshness and authorization controls. For network event logs and account churn models at a telecommunications provider, generated SQL and semantic-model metrics select the wrong field even though source invoice rows are accurate. The appropriate correction is to review and correct the approved semantic model metric definition and test natural-language-to-SQL outputs against reference cases. Confirm that the seeded net-revenue query matches a reviewed SQL baseline across sample periods.

B.

Review and correct the approved semantic model metric definition and test natural-language-to-SQL outputs against reference cases. Verify that the seeded net-revenue query matches a reviewed SQL baseline across sample periods. For network event logs and account churn models at a telecommunications provider, generated SQL and semantic-model metrics select the wrong field even though source invoice rows are accurate. Natural language analytics accuracy depends on governed metric definitions and source semantics.

C.

Align supported Streamlit execution context, app roles and underlying data access with intended user audiences. Verify that a permitted viewer sees only approved aggregates and cannot retrieve underlying restricted rows. Application interfaces do not replace authorization checks at the data and execution boundary. For network event logs and account churn models at a telecommunications provider, generated SQL and semantic-model metrics select the wrong field even though source invoice rows are accurate. The appropriate correction is to review and correct the approved semantic model metric definition and test natural-language-to-SQL outputs against reference cases. Confirm that the seeded net-revenue query matches a reviewed SQL baseline across sample periods.

D.

Evaluate a supported Snowpark DataFrame or UDF design with governed package access and verify execution near Snowflake data. Verify that a representative transformation completes without bulk workstation export and produces matching approved results. Snowpark enables supported programming-language computations within the Snowflake processing environment. For network event logs and account churn models at a telecommunications provider, generated SQL and semantic-model metrics select the wrong field even though source invoice rows are accurate. The appropriate correction is to review and correct the approved semantic model metric definition and test natural-language-to-SQL outputs against reference cases. Confirm that the seeded net-revenue query matches a reviewed SQL baseline across sample periods.

Question 188

In verification logs and service risk scoring at an identity verification firm, a validated correction is proposed: Tune workload concurrency with suitable warehouse isolation or multi-cluster scaling before altering correct query SQL. It responds to: A query runs quickly in isolation but takes minutes during the busiest hour, and engineers rewrite SQL unnecessarily. Choose the best measurable success criterion.

  1. A seeded expensive query is assigned to the correct operational owner in cost reporting.
  2. A representative query reduces spill while preserving results and stays within cost limits.
  3. Peak reports complete within queue wait targets while isolated query execution time stays stable.
  4. An unchanged eligible repeated query demonstrates the expected cache behavior without stale results.

Correct Answer: C

Explanation

A.

A seeded expensive query is assigned to the correct operational owner in cost reporting. This choice does not explain the observed failure mechanism. For verification logs and service risk scoring at an identity verification firm, query History separates long queued time from short actual execution and shows many simultaneous sessions. Verify that peak reports complete within queue wait targets while isolated query execution time stays stable.

B.

A representative query reduces spill while preserving results and stays within cost limits. This choice does not explain the observed failure mechanism. For verification logs and service risk scoring at an identity verification firm, query History separates long queued time from short actual execution and shows many simultaneous sessions. Verify that peak reports complete within queue wait targets while isolated query execution time stays stable.

C.

Peak reports complete within queue wait targets while isolated query execution time stays stable. For verification logs and service risk scoring at an identity verification firm, query History separates long queued time from short actual execution and shows many simultaneous sessions. Total query latency includes queue time as well as execution and compilation. To address this, tune workload concurrency with suitable warehouse isolation or multi-cluster scaling before altering correct query SQL.

D.

An unchanged eligible repeated query demonstrates the expected cache behavior without stale results. This choice does not explain the observed failure mechanism. For verification logs and service risk scoring at an identity verification firm, query History separates long queued time from short actual execution and shows many simultaneous sessions. Verify that peak reports complete within queue wait targets while isolated query execution time stays stable.

Question 189

The Snowflake data engineering team at a regional transit agency investigating fleet schedules and passenger ridership datasets notes: A FinOps team sees high daily query spend but cannot attribute it to the dashboard or scheduled transform responsible. Evidence: Query history contains query IDs but service account and tagging conventions do not map runs to owning workloads. They plan: Introduce governed query tags and accountable job identity mapping with account usage reporting. Which technical principle justifies the correction?

  1. Total query latency includes queue time as well as execution and compilation.
  2. Query Profile distinguishes memory spill from excessive table scans and pruning inefficiency.
  3. Query optimization governance needs observable workload attribution, not only raw credits.
  4. Extra query compute cannot correct incorrect SQL semantics.

Correct Answer: C

Explanation

A.

Total query latency includes queue time as well as execution and compilation. This choice does not explain the observed failure mechanism. For fleet schedules and passenger ridership datasets at a regional transit agency, query history contains query IDs but service account and tagging conventions do not map runs to owning workloads. The controlling principle is that query optimization governance needs observable workload attribution, not only raw credits.

B.

Query Profile distinguishes memory spill from excessive table scans and pruning inefficiency. This choice does not explain the observed failure mechanism. For fleet schedules and passenger ridership datasets at a regional transit agency, query history contains query IDs but service account and tagging conventions do not map runs to owning workloads. The controlling principle is that query optimization governance needs observable workload attribution, not only raw credits.

C.

Query optimization governance needs observable workload attribution, not only raw credits. For fleet schedules and passenger ridership datasets at a regional transit agency, query history contains query IDs but service account and tagging conventions do not map runs to owning workloads. The corresponding fix is to introduce governed query tags and accountable job identity mapping with account usage reporting. A successful test shows a seeded expensive query is assigned to the correct operational owner in cost reporting.

D.

Extra query compute cannot correct incorrect SQL semantics. This choice does not explain the observed failure mechanism. For fleet schedules and passenger ridership datasets at a regional transit agency, query history contains query IDs but service account and tagging conventions do not map runs to owning workloads. The controlling principle is that query optimization governance needs observable workload attribution, not only raw credits.

Question 190

During a change review for population program aggregates and access reviews at a public health agency, the team finds: An external small business lacks a Snowflake account, and an operator proposes a reader account with broad internal table visibility. Investigation shows: Reader-account role grants include schemas unrelated to the explicit shared reporting requirement. What is the most appropriate next Snowflake action?

  1. Create a supported reader-account collaboration path with scoped shared objects and approved consumer roles.
  2. Configure a supported secure data share with least privilege and document relevant region/account constraints.
  3. Use supported clean room constraints and approved collaboration templates to restrict outputs and data access.
  4. Choose an appropriate private listing and governed access workflow before publishing the data product.

Correct Answer: A

Explanation

A.

Create a supported reader-account collaboration path with scoped shared objects and approved consumer roles. For population program aggregates and access reviews at a public health agency, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. Reader accounts enable supported consumption without requiring a separate self-managed Snowflake account, but scope still matters. A suitable check should show that the partner reads the intended report but cannot enumerate unrelated provider data.

B.

Configure a supported secure data share with least privilege and document relevant region/account constraints. Snowflake secure sharing can provide governed access without traditional physical data copying. For population program aggregates and access reviews at a public health agency, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The better-matched action is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles.

C.

Use supported clean room constraints and approved collaboration templates to restrict outputs and data access. Clean rooms can support collaboration on sensitive data under controlled computations and output rules. For population program aggregates and access reviews at a public health agency, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The better-matched action is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles.

D.

Choose an appropriate private listing and governed access workflow before publishing the data product. Marketplace listing audience and share-grant design are independent governance controls. For population program aggregates and access reviews at a public health agency, reader-account role grants include schemas unrelated to the explicit shared reporting requirement. The better-matched action is to create a supported reader-account collaboration path with scoped shared objects and approved consumer roles.

SnowPro Core COF-C03 Practice Tests