100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 280
A complex nightly join repeatedly spills to remote disk while the warehouse is otherwise idle Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Remote spill decreases and elapsed execution time improves under matched inputs
- Enable a network policy for the query user
- Test a larger warehouse and inspect Query Profile spill metrics
- Block release while: Memory-intensive execution keeps spilling after the change
- Create an additional tiny warehouse for an unrelated job
- Add a database role without changing compute
Explanation
Correct Answers
A:Acceptance evidence: Remote spill decreases and elapsed execution time improves under matched inputs. Completing configuration alone is insufficient.
C:Test a larger warehouse and inspect Query Profile spill metrics. This addresses the stated condition without bypassing the required boundary.
D:Unresolved failure: Memory-intensive execution keeps spilling after the change. Correct and test it before acceptance.
Incorrect Answers
B:The problem: A complex nightly join repeatedly spills to remote disk while the warehouse is otherwise idle. The appropriate decision: Test a larger warehouse and inspect Query Profile spill metrics.
E:The problem: A complex nightly join repeatedly spills to remote disk while the warehouse is otherwise idle. The appropriate decision: Test a larger warehouse and inspect Query Profile spill metrics.
F:The problem: A complex nightly join repeatedly spills to remote disk while the warehouse is otherwise idle. The appropriate decision: Test a larger warehouse and inspect Query Profile spill metrics.
Question 281
A transient intermediate dataset does not require Fail-safe recovery like permanent production records The team proposes: Use a transient table for the supported short-lived workload. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
- Storage/retention behavior matches the approved reduced-protection requirement
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
C:Acceptance evidence: Storage/retention behavior matches the approved reduced-protection requirement. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Storage/retention behavior matches the approved reduced-protection requirement.
B:This observation is insufficient. The stronger validation is: Storage/retention behavior matches the approved reduced-protection requirement.
D:This observation is insufficient. The stronger validation is: Storage/retention behavior matches the approved reduced-protection requirement.
Question 282
A latency-sensitive support application needs prompt scale-out during spikes of simultaneous reads Which unresolved finding would be a valid reason to block acceptance after the change?
- The configured policy favors savings over needed latency responsiveness
- Change and rollback evidence is retained with the release
- The team confirms: New clusters are provisioned promptly when query concurrency rises
- The relevant users retain exactly their approved access
Explanation
Correct Answer
A:Unresolved failure: The configured policy favors savings over needed latency responsiveness. Correct and test it before acceptance.
Incorrect Answers
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The configured policy favors savings over needed latency responsiveness.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The configured policy favors savings over needed latency responsiveness.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The configured policy favors savings over needed latency responsiveness.
Question 283
A dynamic table falls behind its required freshness objective The team proposes: Inspect refresh history, upstream dependencies, compute and supported query limitations. Which test outcome is the strongest direct evidence that this change works?
- A job status is green without comparing source and target record counts
- The staged file appears in LIST but no destination row is validated
- Actual refresh lag returns within the documented objective
- One connector starts but no expected event arrives
Explanation
Correct Answer
C:Acceptance evidence: Actual refresh lag returns within the documented objective. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Actual refresh lag returns within the documented objective.
B:This observation is insufficient. The stronger validation is: Actual refresh lag returns within the documented objective.
D:This observation is insufficient. The stronger validation is: Actual refresh lag returns within the documented objective.
Question 284
An external Iceberg catalog is updated by another engine and Snowflake queries show older metadata Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- Queries return stale metadata compared with the authoritative Iceberg catalog
- The team confirms: Snowflake reflects the expected Iceberg snapshot after metadata synchronization
Explanation
Correct Answer
C:Unresolved failure: Queries return stale metadata compared with the authoritative Iceberg catalog. 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: Queries return stale metadata compared with the authoritative Iceberg catalog.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Queries return stale metadata compared with the authoritative Iceberg catalog.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Queries return stale metadata compared with the authoritative Iceberg catalog.
Question 285
A consumer wants to modify a source table provided through standard Secure Data Sharing Which technical action is most appropriate under this requirement?
- Delete source rows as part of a consumer query
- Grant INSERT against the provider's original shared table as a default
- Keep shared provider data read-only and build derived consumer-owned tables where modifications are required
- Alter provider ownership to the consumer
Explanation
Correct Answer
C:Keep shared provider data read-only and build derived consumer-owned tables where modifications are required. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A consumer wants to modify a source table provided through standard Secure Data Sharing. The appropriate decision: Keep shared provider data read-only and build derived consumer-owned tables where modifications are required.
B:The problem: A consumer wants to modify a source table provided through standard Secure Data Sharing. The appropriate decision: Keep shared provider data read-only and build derived consumer-owned tables where modifications are required.
D:The problem: A consumer wants to modify a source table provided through standard Secure Data Sharing. The appropriate decision: Keep shared provider data read-only and build derived consumer-owned tables where modifications are required.
Question 286
A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table Which technical action is most appropriate under this requirement?
- Create a static view and call it a change stream
- Use a supported stream on the source table and consume change records transactionally
- Force repeated full snapshots without deduplication
- Use Time Travel retention as a stream consumption offset
Explanation
Correct Answer
B:Use a supported stream on the source table and consume change records transactionally. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table. The appropriate decision: Use a supported stream on the source table and consume change records transactionally.
C:The problem: A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table. The appropriate decision: Use a supported stream on the source table and consume change records transactionally.
D:The problem: A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table. The appropriate decision: Use a supported stream on the source table and consume change records transactionally.
Question 287
A monthly finance report needs the top three transactions per customer group The team proposes: Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering. 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
- Each customer has the intended top-ranked rows
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
Explanation
Correct Answer
C:Acceptance evidence: Each customer has the intended top-ranked rows. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Each customer has the intended top-ranked rows.
B:This observation is insufficient. The stronger validation is: Each customer has the intended top-ranked rows.
D:This observation is insufficient. The stronger validation is: Each customer has the intended top-ranked rows.
Question 288
A company wants to integrate SQL analytics with familiar Python packages without downloading raw files Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Data egress to external notebooks is incorrectly treated as required
- Change and rollback evidence is retained with the release
- The team confirms: The transformed result is materialized and access-controlled inside Snowflake
Explanation
Correct Answer
B:Unresolved failure: Data egress to external notebooks is incorrectly treated as required. 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: Data egress to external notebooks is incorrectly treated as required.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Data egress to external notebooks is incorrectly treated as required.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Data egress to external notebooks is incorrectly treated as required.
Question 289
A newly created task is present in metadata but never runs according to schedule Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Task history contains successful scheduled runs
- A suspended or unauthorized task is mistaken for an active pipeline
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: A suspended or unauthorized task is mistaken for an active pipeline. Correct and test it before acceptance.
Incorrect Answers
A:“The team confirms: Task history contains successful scheduled runs” describes a target or safeguard, not the release-blocking failure. The defect: A suspended or unauthorized task is mistaken for an active pipeline.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A suspended or unauthorized task is mistaken for an active pipeline.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A suspended or unauthorized task is mistaken for an active pipeline.
Question 290
A governance team assumes Fail-safe is an ordinary end-user time-machine for SQL restores The team proposes: Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- Recovery responsibilities and retention expectations are documented separately
- An unrelated compute counter improves with no correctness check
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: Recovery responsibilities and retention expectations are documented separately. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
C:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
D:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
SnowPro Core COF-C03 Practice Tests