100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 300
A machine-learning feature pipeline repeatedly computes wide transformations and uses excessive remote spill The team proposes: Break down the transformations and benchmark warehouse memory versus intermediate materialization. Which test outcome is the strongest direct evidence that this change works?
- A single warm-cache run is cited without representative execution metrics
- The query finishes but returns a different business total
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The chosen design reduces spill while retaining validated feature outputs
Explanation
Correct Answer
D:Acceptance evidence: The chosen design reduces spill while retaining validated feature outputs. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
B:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
C:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
Question 301
A table shows heavy reclustering credit consumption despite only a few unselective reports Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: Unnecessary automatic reclustering continues without business benefit
- Apply clustering keys to every small lookup table
- Double retention to improve pruning
- Remove or revise clustering keys that do not justify maintenance cost
- Reduce all roles to PUBLIC as a cost control
- Credit consumption falls while actual critical-query latency remains acceptable
Explanation
Correct Answers
A:Unresolved failure: Unnecessary automatic reclustering continues without business benefit. Correct and test it before acceptance.
D:Remove or revise clustering keys that do not justify maintenance cost. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: Credit consumption falls while actual critical-query latency remains acceptable. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
C:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
E:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
Question 302
A team repeatedly queries stream contents without consuming them and expects the offset to advance Which unresolved finding would be a valid reason to block acceptance after the change?
- Changes are reprocessed because a simple SELECT was treated as consumption
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- The team confirms: The stream's consumed change set advances following the committed operation
Explanation
Correct Answer
A:Unresolved failure: Changes are reprocessed because a simple SELECT was treated as consumption. Correct and test it before acceptance.
Incorrect Answers
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Changes are reprocessed because a simple SELECT was treated as consumption.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Changes are reprocessed because a simple SELECT was treated as consumption.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Changes are reprocessed because a simple SELECT was treated as consumption.
Question 303
A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table The team proposes: Use a supported stream on the source table and consume change records transactionally. Which test outcome is the strongest direct evidence that this change works?
- One connector starts but no expected event arrives
- A job status is green without comparing source and target record counts
- The downstream job processes the intended change rows without a full table rescan
- The staged file appears in LIST but no destination row is validated
Explanation
Correct Answer
C:Acceptance evidence: The downstream job processes the intended change rows without a full table rescan. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The downstream job processes the intended change rows without a full table rescan.
B:This observation is insufficient. The stronger validation is: The downstream job processes the intended change rows without a full table rescan.
D:This observation is insufficient. The stronger validation is: The downstream job processes the intended change rows without a full table rescan.
Question 304
A team wants several connectors to share a cloud API but avoid unreviewed external access Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- External data egress occurs without a reviewed trust boundary
- The team confirms: Authorized requests succeed while unapproved destinations or credentials are blocked
- The relevant users retain exactly their approved access
Explanation
Correct Answer
B:Unresolved failure: External data egress occurs without a reviewed trust boundary. Correct and test it before acceptance.
Incorrect Answers
A:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: External data egress occurs without a reviewed trust boundary.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: External data egress occurs without a reviewed trust boundary.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: External data egress occurs without a reviewed trust boundary.
Question 305
Security policy requires Snowflake logins only from designated corporate network ranges Which technical action is most appropriate under this requirement?
- Grant table SELECT to the corporate VPN
- Use a row access policy as a login firewall
- Apply an appropriate network policy to the supported account or user scope
- Disable query result reuse to block IP ranges
Explanation
Correct Answer
C:Apply an appropriate network policy to the supported account or user scope. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
B:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
D:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
Question 306
A data science team wants Python DataFrame transformations executed close to Snowflake data Which technical action is most appropriate under this requirement?
- Replace transformations with a table comment
- Grant OWNERSHIP of all tables to Python developers
- Download all data into every developer laptop by default
- Use Snowpark with appropriately scoped compute and dependencies
Explanation
Correct Answer
D:Use Snowpark with appropriately scoped compute and dependencies. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A data science team wants Python DataFrame transformations executed close to Snowflake data. The appropriate decision: Use Snowpark with appropriately scoped compute and dependencies.
B:The problem: A data science team wants Python DataFrame transformations executed close to Snowflake data. The appropriate decision: Use Snowpark with appropriately scoped compute and dependencies.
C:The problem: A data science team wants Python DataFrame transformations executed close to Snowflake data. The appropriate decision: Use Snowpark with appropriately scoped compute and dependencies.
Question 307
A cost team cannot identify which warehouses consumed last week's credits Which technical action is most appropriate under this requirement?
- Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views
- Use a masking policy to lower compute charges
- Assume suspended warehouses accrue the same active compute minutes
- Count database names as a proxy for credits
Explanation
Correct Answer
A:Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
C:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
D:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
Question 308
A task should run only when a source stream actually has pending changes Which technical action is most appropriate under this requirement?
- Use a task WHEN condition with the supported stream-has-data predicate
- Schedule an unconditional heavy full-table scan every second
- Use a materialized view name as a predicate
- Set a network policy to check stream offsets
Explanation
Correct Answer
A:Use a task WHEN condition with the supported stream-has-data predicate. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
C:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
D:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
Question 309
A provider wants to distribute a data product discoverably to external Snowflake customers Which technical action is most appropriate under this requirement?
- Use only a table rename instead of a listing
- Grant PUBLIC SELECT on the production database
- Create a governed Snowflake Marketplace listing with the approved offer and access model
- Publish raw provider credentials in the listing description
Explanation
Correct Answer
C:Create a governed Snowflake Marketplace listing with the approved offer and access model. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A provider wants to distribute a data product discoverably to external Snowflake customers. The appropriate decision: Create a governed Snowflake Marketplace listing with the approved offer and access model.
B:The problem: A provider wants to distribute a data product discoverably to external Snowflake customers. The appropriate decision: Create a governed Snowflake Marketplace listing with the approved offer and access model.
D:The problem: A provider wants to distribute a data product discoverably to external Snowflake customers. The appropriate decision: Create a governed Snowflake Marketplace listing with the approved offer and access model.
Question 310
A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Duplicated databases create unnecessary reconciliation work
- Change and rollback evidence is retained with the release
- The team confirms: Three workloads have isolated compute and one authoritative dataset
Explanation
Correct Answer
B:Unresolved failure: Duplicated databases create unnecessary reconciliation work. Correct and test it before acceptance.
Incorrect Answers
A:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Duplicated databases create unnecessary reconciliation work.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Duplicated databases create unnecessary reconciliation work.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Duplicated databases create unnecessary reconciliation work.
SnowPro Core COF-C03 Practice Tests