Snowflake SnowPro Core COF-C03 Practice Test 50 - 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 50

Question 490

For loan servicing analytics and audit trails at a cooperative credit union, an engineer diagnoses: Two analysts compare query cache savings using different roles and assume an exact result cache hit is universally shareable. The observation is: Query contexts differ in security and session conditions and tests do not control source change timing. The response is: Benchmark cache eligibility using consistent authorized roles, parameter settings and unchanged data without exposing protected results. Which principle best explains the decision?

  1. Snowflake persisted query results are reused only when the required consistency and context conditions are met.
  2. Query result reuse depends on relevant session and security conditions as well as SQL text.
  3. Virtual warehouse local data cache behavior differs from the persisted query result cache.
  4. Query Profile distinguishes memory spill from excessive table scans and pruning inefficiency.

Correct Answer: B

Explanation

A.

Snowflake persisted query results are reused only when the required consistency and context conditions are met. This choice does not explain the observed failure mechanism. For loan servicing analytics and audit trails at a cooperative credit union, query contexts differ in security and session conditions and tests do not control source change timing. The controlling principle is that query result reuse depends on relevant session and security conditions as well as SQL text.

B.

Query result reuse depends on relevant session and security conditions as well as SQL text. For loan servicing analytics and audit trails at a cooperative credit union, query contexts differ in security and session conditions and tests do not control source change timing. The documented change is to benchmark cache eligibility using consistent authorized roles, parameter settings and unchanged data without exposing protected results. A successful test shows repeated qualified queries show understood result-cache behavior with authorization preserved.

C.

Virtual warehouse local data cache behavior differs from the persisted query result cache. This choice does not explain the observed failure mechanism. For loan servicing analytics and audit trails at a cooperative credit union, query contexts differ in security and session conditions and tests do not control source change timing. The controlling principle is that query result reuse depends on relevant session and security conditions as well as SQL text.

D.

Query Profile distinguishes memory spill from excessive table scans and pruning inefficiency. This choice does not explain the observed failure mechanism. For loan servicing analytics and audit trails at a cooperative credit union, query contexts differ in security and session conditions and tests do not control source change timing. The controlling principle is that query result reuse depends on relevant session and security conditions as well as SQL text.

Question 491

An operations review of application case metrics and protected citizen records at a benefits agency reports: A ranking query assigns the same top order to multiple customers because the window partition uses a shared region code. The differentiating observation is: A seeded dataset with two customers in the same region produces a shared rank sequence rather than customer-specific ranks. Which proposed fix and test pair most directly addresses the failure?

  1. Deduplicate or deterministically stage source changes at the intended target grain before the approved MERGE. — verification: A synthetic repeated key resolves to one correct target state and replay remains consistent.
  2. Use the correct business key in PARTITION BY with explicit deterministic ORDER BY where needed. — verification: Each test customer has the expected independent ranking without unexpected cross-customer influence.
  3. Use the appropriate LATERAL FLATTEN and reviewed join grain to expand the intended nested elements. — verification: A three-element test array produces three authorized item rows with correct parent identifiers.
  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: B

Explanation

A.

Deduplicate or deterministically stage source changes at the intended target grain before the approved MERGE. Verify that a synthetic repeated key resolves to one correct target state and replay remains consistent. This action and its verification do not address the identified failure together. For application case metrics and protected citizen records at a benefits agency, a seeded dataset with two customers in the same region produces a shared rank sequence rather than customer-specific ranks. The appropriate correction is to use the correct business key in PARTITION BY with explicit deterministic ORDER BY where needed. Confirm that each test customer has the expected independent ranking without unexpected cross-customer influence.

B.

Use the correct business key in PARTITION BY with explicit deterministic ORDER BY where needed. Verify that Each test customer has the expected independent ranking without unexpected cross-customer influence. For application case metrics and protected citizen records at a benefits agency, a seeded dataset with two customers in the same region produces a shared rank sequence rather than customer-specific ranks. Window functions depend on the declared partition and ordering semantics.

C.

Use the appropriate LATERAL FLATTEN and reviewed join grain to expand the intended nested elements. Verify that a three-element test array produces three authorized item rows with correct parent identifiers. This action and its verification do not address the identified failure together. For application case metrics and protected citizen records at a benefits agency, a seeded dataset with two customers in the same region produces a shared rank sequence rather than customer-specific ranks. The appropriate correction is to use the correct business key in PARTITION BY with explicit deterministic ORDER BY where needed. Confirm that each test customer has the expected independent ranking without unexpected cross-customer influence.

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. This action and its verification do not address the identified failure together. For application case metrics and protected citizen records at a benefits agency, a seeded dataset with two customers in the same region produces a shared rank sequence rather than customer-specific ranks. The appropriate correction is to use the correct business key in PARTITION BY with explicit deterministic ORDER BY where needed. Confirm that each test customer has the expected independent ranking without unexpected cross-customer influence.

Question 492

The Snowflake data engineering case at a pharmaceutical wholesaler concerns inventory traceability and shipping records. Problem: A reporting view exposes full national identifiers to a broad analyst role despite a requirement to show only redacted values. Evidence: A low-privilege test session selects cleartext identifiers because no applicable masking policy protects the column. Which paired corrective action and verification is best?

  1. Correct and test a documented row access policy driven by authoritative entitlement mapping without using a broad global exception. — verification: Positive and negative tenant tests return only authorized records for each role.
  2. Attach an approved dynamic data masking policy and verify role-aware evaluation for intended consumers. — verification: Restricted roles receive redacted test values and a specifically authorized role receives only approved detail.
  3. Apply supported sensitive-data classification and governed object tags with review and ownership of findings. — verification: A seeded new sensitive column is detected, labeled appropriately and included in the audit inventory.
  4. Grant the minimal warehouse usage privilege to the approved functional role while preserving object-level data grants. — verification: A query runs on the specified warehouse without granting access to unrelated compute resources.

Correct Answer: B

Explanation

A.

Correct and test a documented row access policy driven by authoritative entitlement mapping without using a broad global exception. Verify that Positive and negative tenant tests return only authorized records for each role. Row-level security requires correct identity-to-row entitlement logic. For inventory traceability and shipping records at a pharmaceutical wholesaler, a low-privilege test session selects cleartext identifiers because no applicable masking policy protects the column. The appropriate correction is to attach an approved dynamic data masking policy and verify role-aware evaluation for intended consumers. Confirm that restricted roles receive redacted test values and a specifically authorized role receives only approved detail.

B.

Attach an approved dynamic data masking policy and verify role-aware evaluation for intended consumers. Verify that Restricted roles receive redacted test values and a specifically authorized role receives only approved detail. For inventory traceability and shipping records at a pharmaceutical wholesaler, a low-privilege test session selects cleartext identifiers because no applicable masking policy protects the column. Dynamic masking can enforce column-value protection according to access context.

C.

Apply supported sensitive-data classification and governed object tags with review and ownership of findings. Verify that a seeded new sensitive column is detected, labeled appropriately and included in the audit inventory. Metadata tags provide governance value only when classification and lifecycle controls are reliable. For inventory traceability and shipping records at a pharmaceutical wholesaler, a low-privilege test session selects cleartext identifiers because no applicable masking policy protects the column. The appropriate correction is to attach an approved dynamic data masking policy and verify role-aware evaluation for intended consumers. Confirm that restricted roles receive redacted test values and a specifically authorized role receives only approved detail.

D.

Grant the minimal warehouse usage privilege to the approved functional role while preserving object-level data grants. Verify that a query runs on the specified warehouse without granting access to unrelated compute resources. Snowflake role authorization must cover both referenced data and chosen execution warehouse. For inventory traceability and shipping records at a pharmaceutical wholesaler, a low-privilege test session selects cleartext identifiers because no applicable masking policy protects the column. The appropriate correction is to attach an approved dynamic data masking policy and verify role-aware evaluation for intended consumers. Confirm that restricted roles receive redacted test values and a specifically authorized role receives only approved detail.

Question 493

Administrators at an e-commerce marketplace plan: Separate warehouse compute lifecycle from durable database storage and enable supported auto-suspend with a safe restart test. They are addressing the following problem in shopping funnel events and merchant sales reporting: An operations team assumes suspending its only virtual warehouse will erase permanent customer data and keeps compute running all night. Which test demonstrates resolution?

  1. Retained datasets meet business recovery requirements and storage growth falls independently of warehouse performance changes.
  2. Morning queries meet agreed latency while batch jobs retain controlled throughput without new unauthorized data copies.
  3. An idle warehouse suspends, compute charges stop for idle time, and an authorized new query resumes access to unchanged table rows.
  4. A controlled account check demonstrates that the chosen production configuration actually enforces the documented control.

Correct Answer: C

Explanation

A.

Retained datasets meet business recovery requirements and storage growth falls independently of warehouse performance changes. Compute-credit consumption and managed storage usage are distinct cost drivers. For shopping funnel events and merchant sales reporting at an e-commerce marketplace, billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension. A meaningful check confirms that an idle warehouse suspends, compute charges stop for idle time, and an authorized new query resumes access to unchanged table rows.

B.

Morning queries meet agreed latency while batch jobs retain controlled throughput without new unauthorized data copies. Independent virtual warehouses support workload isolation over shared centralized data. For shopping funnel events and merchant sales reporting at an e-commerce marketplace, billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension. A meaningful check confirms that an idle warehouse suspends, compute charges stop for idle time, and an authorized new query resumes access to unchanged table rows.

C.

An idle warehouse suspends, compute charges stop for idle time, and an authorized new query resumes access to unchanged table rows. For shopping funnel events and merchant sales reporting at an e-commerce marketplace, billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension. Snowflake separates independently scalable query compute from persistent managed table storage. The corresponding fix is to separate warehouse compute lifecycle from durable database storage and enable supported auto-suspend with a safe restart test.

D.

A controlled account check demonstrates that the chosen production configuration actually enforces the documented control. Snowflake editions differ in available advanced security and resilience capabilities. For shopping funnel events and merchant sales reporting at an e-commerce marketplace, billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension. A meaningful check confirms that an idle warehouse suspends, compute charges stop for idle time, and an authorized new query resumes access to unchanged table rows.

Question 494

A Snowflake analyst supporting instrument results and governed case metadata at a medical testing laboratory intends: Configure a supported secure data share with least privilege and document relevant region/account constraints. The reported condition is: A partner refuses a data collaboration because it assumes a Snowflake direct share must physically copy the entire source table. Identify the most decisive diagnostic record.

  1. Reader-account role grants include schemas unrelated to the explicit shared reporting requirement.
  2. Collaboration design includes a same-region direct share and governed consumer read access without a bulk export request.
  3. A trial query returns person-level matching keys instead of allowed aggregate or privacy-controlled results.
  4. Application manifest and permission review show requested access outside the stated data-processing use case.

Correct Answer: B

Explanation

A.

Reader-account role grants include schemas unrelated to the explicit shared reporting requirement. This choice does not explain the observed failure mechanism. For instrument results and governed case metadata at a medical testing laboratory, collaboration design includes a same-region direct share and governed consumer read access without a bulk export request. The better-matched action is to configure a supported secure data share with least privilege and document relevant region/account constraints.

B.

Collaboration design includes a same-region direct share and governed consumer read access without a bulk export request. Snowflake secure sharing can provide governed access without traditional physical data copying. The documented change is to configure a supported secure data share with least privilege and document relevant region/account constraints. The acceptance check is whether an authorized consumer queries the shared object while no unmanaged full dataset export is required; the reported setting is: a snowflake analyst supporting instrument results and governed case metadata at a medical testing laboratory intends: configure a supported secure data share with least privilege and document relevant regi.

C.

A trial query returns person-level matching keys instead of allowed aggregate or privacy-controlled results. This choice does not explain the observed failure mechanism. For instrument results and governed case metadata at a medical testing laboratory, collaboration design includes a same-region direct share and governed consumer read access without a bulk export request. The better-matched action is to configure a supported secure data share with least privilege and document relevant region/account constraints.

D.

Application manifest and permission review show requested access outside the stated data-processing use case. This choice does not explain the observed failure mechanism. For instrument results and governed case metadata at a medical testing laboratory, collaboration design includes a same-region direct share and governed consumer read access without a bulk export request. The better-matched action is to configure a supported secure data share with least privilege and document relevant region/account constraints.

Question 495

To correct this issue at a water supplier involving asset maintenance logs and quality assurance reports: A product team deletes a table and discovers the configured retention window is shorter than the approved rollback requirement. The team applies: Review supported table type, edition, retention settings and backup strategy against the required recovery objective. What outcome should close the incident?

  1. The recovery runbook gives correct operator actions and timings without claiming direct Fail-safe SQL restore.
  2. A governed clone supports testing without an initial full data rewrite and has a documented storage-cost lifecycle.
  3. An allowed test drop is recoverable within the documented approved window and out-of-window limits are clearly stated.
  4. The approved overlap statistic is available while individual participant records cannot be exported.

Correct Answer: C

Explanation

A.

The recovery runbook gives correct operator actions and timings without claiming direct Fail-safe SQL restore. Fail-safe is distinct from normal user-controlled Time Travel querying and undrop recovery. For asset maintenance logs and quality assurance reports at a water supplier, table metadata reports limited Time Travel retention and the requested point in history lies outside that window. A confirming test shows that an allowed test drop is recoverable within the documented approved window and out-of-window limits are clearly stated.

B.

A governed clone supports testing without an initial full data rewrite and has a documented storage-cost lifecycle. Snowflake zero-copy cloning initially shares immutable micro-partitions while preserving logical object independence. For asset maintenance logs and quality assurance reports at a water supplier, table metadata reports limited Time Travel retention and the requested point in history lies outside that window. A confirming test shows that an allowed test drop is recoverable within the documented approved window and out-of-window limits are clearly stated.

C.

An allowed test drop is recoverable within the documented approved window and out-of-window limits are clearly stated. For asset maintenance logs and quality assurance reports at a water supplier, table metadata reports limited Time Travel retention and the requested point in history lies outside that window. Time Travel provides configurable historical recovery only within supported object retention limits. To correct it, review supported table type, edition, retention settings and backup strategy against the required recovery objective.

D.

The approved overlap statistic is available while individual participant records cannot be exported. Clean rooms can support collaboration on sensitive data under controlled computations and output rules. For asset maintenance logs and quality assurance reports at a water supplier, table metadata reports limited Time Travel retention and the requested point in history lies outside that window. A confirming test shows that an allowed test drop is recoverable within the documented approved window and out-of-window limits are clearly stated.

Question 496

For return history and customer lifetime models at an online retail chain, an engineer diagnoses: A data engineer executes a destructive administrative statement from a worksheet without noticing it inherited an elevated role. The observation is: Worksheet context displays ACCOUNTADMIN while the approved task requires a narrower functional role and the same SQL works with that role. The response is: Change the active worksheet role to a least-privilege approved role and validate session context before executing administrative SQL. Which principle best explains the decision?

  1. Interactive development tools still require supported execution compute and role context.
  2. Snowsight executes SQL within the selected session role, database, schema and warehouse context.
  3. Snowflake session context and object qualification determine how SQL names are resolved.
  4. Warehouse auto-suspend and auto-resume must be configured together for intermittent workloads.

Correct Answer: B

Explanation

A.

Interactive development tools still require supported execution compute and role context. This choice does not explain the observed failure mechanism. For return history and customer lifetime models at an online retail chain, worksheet context displays ACCOUNTADMIN while the approved task requires a narrower functional role and the same SQL works with that role. The controlling principle is that snowsight executes SQL within the selected session role, database, schema and warehouse context.

B.

Snowsight executes SQL within the selected session role, database, schema and warehouse context. For return history and customer lifetime models at an online retail chain, worksheet context displays ACCOUNTADMIN while the approved task requires a narrower functional role and the same SQL works with that role. To address this, change the active worksheet role to a least-privilege approved role and validate session context before executing administrative SQL. A successful test shows the permitted operation succeeds under the correct role and an unrelated privileged action is denied.

C.

Snowflake session context and object qualification determine how SQL names are resolved. This choice does not explain the observed failure mechanism. For return history and customer lifetime models at an online retail chain, worksheet context displays ACCOUNTADMIN while the approved task requires a narrower functional role and the same SQL works with that role. The controlling principle is that snowsight executes SQL within the selected session role, database, schema and warehouse context.

D.

Warehouse auto-suspend and auto-resume must be configured together for intermittent workloads. This choice does not explain the observed failure mechanism. For return history and customer lifetime models at an online retail chain, worksheet context displays ACCOUNTADMIN while the approved task requires a narrower functional role and the same SQL works with that role. The controlling principle is that snowsight executes SQL within the selected session role, database, schema and warehouse context.

Question 497

The network event logs and account churn models team at a telecommunications provider records: Trust Center findings continue to appear but a decommissioned distribution list receives their alert notifications. Logs confirm: Notification configuration references an unmonitored destination and the latest known control finding has no ticket. The recommended action is: Update approved alert and notification destinations and verify escalation through the current security ownership process. What underlying Snowflake solution principle applies?

  1. Dynamic masking can enforce column-value protection according to access context.
  2. Row-level security requires correct identity-to-row entitlement logic.
  3. Resource monitors act on associated virtual-warehouse credit usage rather than any unrelated account cost automatically.
  4. Security monitoring requires actionable ownership and alert delivery, not just a healthy detection engine.

Correct Answer: D

Explanation

A.

Dynamic masking can enforce column-value protection according to access context. This choice does not explain the observed failure mechanism. For network event logs and account churn models at a telecommunications provider, notification configuration references an unmonitored destination and the latest known control finding has no ticket. The controlling principle is that security monitoring requires actionable ownership and alert delivery, not just a healthy detection engine.

B.

Row-level security requires correct identity-to-row entitlement logic. This choice does not explain the observed failure mechanism. For network event logs and account churn models at a telecommunications provider, notification configuration references an unmonitored destination and the latest known control finding has no ticket. The controlling principle is that security monitoring requires actionable ownership and alert delivery, not just a healthy detection engine.

C.

Resource monitors act on associated virtual-warehouse credit usage rather than any unrelated account cost automatically. This choice does not explain the observed failure mechanism. For network event logs and account churn models at a telecommunications provider, notification configuration references an unmonitored destination and the latest known control finding has no ticket. The controlling principle is that security monitoring requires actionable ownership and alert delivery, not just a healthy detection engine.

D.

Security monitoring requires actionable ownership and alert delivery, not just a healthy detection engine. For network event logs and account churn models at a telecommunications provider, notification configuration references an unmonitored destination and the latest known control finding has no ticket. The corresponding fix is to update approved alert and notification destinations and verify escalation through the current security ownership process. A successful test shows a synthetic policy finding reaches an accountable security queue with evidence and response tracking.

Question 498

The Snowflake data engineering team at a public university plans to: Separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely. The issue affecting student analytics and research-grant reporting is: An analyst downsizes warehouse compute hoping to reduce a growing table-storage bill caused by duplicate historical records. Which finding best distinguishes this cause from other Snowflake failures?

  1. Billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension.
  2. Query history shows overlapping workloads and queuing despite healthy underlying cloud storage availability.
  3. Notebook execution context points to an inactive or unauthorized warehouse while role grants to the data objects are already correct.
  4. Consumption reports show storage bytes rising while warehouse execution credits remain relatively stable.

Correct Answer: D

Explanation

A.

Billing history shows uninterrupted warehouse credits during idle hours while table storage remains intact through prior controlled suspension. Snowflake separates independently scalable query compute from persistent managed table storage. For student analytics and research-grant reporting at a public university, consumption reports show storage bytes rising while warehouse execution credits remain relatively stable. The better-matched action is to separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

B.

Query history shows overlapping workloads and queuing despite healthy underlying cloud storage availability. Independent virtual warehouses support workload isolation over shared centralized data. For student analytics and research-grant reporting at a public university, consumption reports show storage bytes rising while warehouse execution credits remain relatively stable. The better-matched action is to separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

C.

Notebook execution context points to an inactive or unauthorized warehouse while role grants to the data objects are already correct. Interactive development tools still require supported execution compute and role context. For student analytics and research-grant reporting at a public university, consumption reports show storage bytes rising while warehouse execution credits remain relatively stable. The better-matched action is to separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

D.

Consumption reports show storage bytes rising while warehouse execution credits remain relatively stable. Compute-credit consumption and managed storage usage are distinct cost drivers. The documented change is to separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely. The acceptance check is whether retained datasets meet business recovery requirements and storage growth falls independently of warehouse performance changes; the reported setting is: the snowflake data engineering team at a public university plans to: separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

Question 499

During a change review for meter ingestion and maintenance trend analysis at a renewable energy utility, the team finds: An account team promises an edition-dependent governance control to auditors without checking the account's subscribed Snowflake edition. Investigation shows: Feature evaluation indicates the required control is not available at the current account edition and its trial behavior differs from production. What is the most appropriate next Snowflake action?

  1. Separate warehouse compute lifecycle from durable database storage and enable supported auto-suspend with a safe restart test.
  2. Inspect query planning, object statistics, metadata and query shape before changing compute sizing.
  3. Verify official feature and edition availability and select an approved edition or alternative control before making compliance claims.
  4. Separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

Correct Answer: C

Explanation

A.

Separate warehouse compute lifecycle from durable database storage and enable supported auto-suspend with a safe restart test. Snowflake separates independently scalable query compute from persistent managed table storage. For meter ingestion and maintenance trend analysis at a renewable energy utility, feature evaluation indicates the required control is not available at the current account edition and its trial behavior differs from production. For this incident, verify official feature and edition availability and select an approved edition or alternative control before making compliance claims.

B.

Inspect query planning, object statistics, metadata and query shape before changing compute sizing. Cloud services coordinate SQL compilation and metadata separately from virtual warehouse execution. For meter ingestion and maintenance trend analysis at a renewable energy utility, feature evaluation indicates the required control is not available at the current account edition and its trial behavior differs from production. For this incident, verify official feature and edition availability and select an approved edition or alternative control before making compliance claims.

C.

Verify official feature and edition availability and select an approved edition or alternative control before making compliance claims. For meter ingestion and maintenance trend analysis at a renewable energy utility, feature evaluation indicates the required control is not available at the current account edition and its trial behavior differs from production. Snowflake editions differ in available advanced security and resilience capabilities. Verify that a controlled account check demonstrates that the chosen production configuration actually enforces the documented control.

D.

Separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely. Compute-credit consumption and managed storage usage are distinct cost drivers. For meter ingestion and maintenance trend analysis at a renewable energy utility, feature evaluation indicates the required control is not available at the current account edition and its trial behavior differs from production. For this incident, verify official feature and edition availability and select an approved edition or alternative control before making compliance claims.

Question 500

The student analytics and research-grant reporting environment at a public university has an incident: A finance warehouse auto-suspends overnight but scheduled morning jobs fail because the service cannot resume it. The difference-making observation is: Warehouse state is suspended, the scheduling role has usage permissions, and auto-resume is disabled for the chosen warehouse. Choose the most defensible corrective response.

  1. Review warehouse auto-resume and approved execution role settings without disabling cost-saving auto-suspend entirely.
  2. Assess supported multi-cluster warehouse configuration, scaling policy and workload partitioning under realistic concurrency.
  3. Benchmark a supported larger warehouse size and query optimization before adding clusters intended primarily for concurrency.
  4. Separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely.

Correct Answer: A

Explanation

A.

Review warehouse auto-resume and approved execution role settings without disabling cost-saving auto-suspend entirely. For student analytics and research-grant reporting at a public university, warehouse state is suspended, the scheduling role has usage permissions, and auto-resume is disabled for the chosen warehouse. Warehouse auto-suspend and auto-resume must be configured together for intermittent workloads. A confirming result should show that a scheduled test query resumes the warehouse, succeeds and the warehouse later suspends again after inactivity.

B.

Assess supported multi-cluster warehouse configuration, scaling policy and workload partitioning under realistic concurrency. This choice does not explain the observed failure mechanism. For student analytics and research-grant reporting at a public university, warehouse state is suspended, the scheduling role has usage permissions, and auto-resume is disabled for the chosen warehouse. Instead, review warehouse auto-resume and approved execution role settings without disabling cost-saving auto-suspend entirely.

C.

Benchmark a supported larger warehouse size and query optimization before adding clusters intended primarily for concurrency. This choice does not explain the observed failure mechanism. For student analytics and research-grant reporting at a public university, warehouse state is suspended, the scheduling role has usage permissions, and auto-resume is disabled for the chosen warehouse. Instead, review warehouse auto-resume and approved execution role settings without disabling cost-saving auto-suspend entirely.

D.

Separate storage inventory and retention decisions from warehouse sizing and remove only approved redundant data safely. This choice does not explain the observed failure mechanism. For student analytics and research-grant reporting at a public university, warehouse state is suspended, the scheduling role has usage permissions, and auto-resume is disabled for the chosen warehouse. Instead, review warehouse auto-resume and approved execution role settings without disabling cost-saving auto-suspend entirely.

SnowPro Core COF-C03 Practice Tests