100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 790
An optimization proposal adds search optimization to a tiny reference table with infrequent lookups The team proposes: Estimate maintenance overhead and query savings before enabling the service. Which test outcome is the strongest direct evidence that this change works?
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The query finishes but returns a different business total
- Feature cost is justified only for the actual query workload
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
C:Acceptance evidence: Feature cost is justified only for the actual query workload. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Feature cost is justified only for the actual query workload.
B:This observation is insufficient. The stronger validation is: Feature cost is justified only for the actual query workload.
D:This observation is insufficient. The stronger validation is: Feature cost is justified only for the actual query workload.
Question 791
A transient intermediate dataset does not require Fail-safe recovery like permanent production records Which technical action is most appropriate under this requirement?
- Configure a network policy to shorten storage lifecycle
- Use a permanent table while claiming it has no Fail-safe
- Use a transient table for the supported short-lived workload
- Convert warehouse cache into durable dataset storage
Explanation
Correct Answer
C:Use a transient table for the supported short-lived workload. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
B:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
D:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
Question 792
A zero-copy cloned dataset is modified independently and billing unexpectedly increases Which technical action is most appropriate under this requirement?
- Disable virtual warehouses to stop cloned table storage costs
- Promise clones never consume additional storage
- Use session variables to prevent copy-on-write
- Explain and measure copy-on-write storage divergence between original and clone
Explanation
Correct Answer
D:Explain and measure copy-on-write storage divergence between original and clone. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A zero-copy cloned dataset is modified independently and billing unexpectedly increases. The appropriate decision: Explain and measure copy-on-write storage divergence between original and clone.
B:The problem: A zero-copy cloned dataset is modified independently and billing unexpectedly increases. The appropriate decision: Explain and measure copy-on-write storage divergence between original and clone.
C:The problem: A zero-copy cloned dataset is modified independently and billing unexpectedly increases. The appropriate decision: Explain and measure copy-on-write storage divergence between original and clone.
Question 793
An ingestion team wants to load only a controlled subset of files from a shared stage Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- The team confirms: Only the intended input files contribute rows to the target table
- Change and rollback evidence is retained with the release
- Unrelated files from the shared stage enter the dataset
Explanation
Correct Answer
D:Unresolved failure: Unrelated files from the shared stage enter the dataset. 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: Unrelated files from the shared stage enter the dataset.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Unrelated files from the shared stage enter the dataset.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Unrelated files from the shared stage enter the dataset.
Question 794
A zero-copy cloned dataset is modified independently and billing unexpectedly increases The team proposes: Explain and measure copy-on-write storage divergence between original and clone. Which test outcome is the strongest direct evidence that this change works?
- Changed micro-partitions contribute additional storage while unchanged regions remain shared
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
A:Acceptance evidence: Changed micro-partitions contribute additional storage while unchanged regions remain shared. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Changed micro-partitions contribute additional storage while unchanged regions remain shared.
C:This observation is insufficient. The stronger validation is: Changed micro-partitions contribute additional storage while unchanged regions remain shared.
D:This observation is insufficient. The stronger validation is: Changed micro-partitions contribute additional storage while unchanged regions remain shared.
Question 795
A storage integration grants too broad access to a cloud bucket used for ingestion Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- The external stage becomes a general-purpose cloud-storage bypass
- The team confirms: The integration can read allowed prefixes while denied prefixes remain inaccessible
Explanation
Correct Answer
C:Unresolved failure: The external stage becomes a general-purpose cloud-storage bypass. 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: The external stage becomes a general-purpose cloud-storage bypass.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The external stage becomes a general-purpose cloud-storage bypass.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: The external stage becomes a general-purpose cloud-storage bypass.
Question 796
A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout Which unresolved finding would be a valid reason to block acceptance after the change?
- An idle timer cancels critical SQL unexpectedly due to conflated settings
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- The team confirms: Long-running statements and idle periods follow the distinct defined policies
Explanation
Correct Answer
A:Unresolved failure: An idle timer cancels critical SQL unexpectedly due to conflated settings. 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: An idle timer cancels critical SQL unexpectedly due to conflated settings.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: An idle timer cancels critical SQL unexpectedly due to conflated settings.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: An idle timer cancels critical SQL unexpectedly due to conflated settings.
Question 797
A mistaken DELETE must be undone within the table's configured retention window Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Use supported Time Travel query or restoration syntax to recover the prior state
- Change the warehouse autosuspend setting to undo DELETE
- Recovered rows match the recorded pre-delete snapshot
- Look for deleted records only in query result cache
- Run another DELETE to reverse the first DELETE
Explanation
Correct Answers
A:Use supported Time Travel query or restoration syntax to recover the prior state. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Recovered rows match the recorded pre-delete snapshot. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A mistaken DELETE must be undone within the table's configured retention window. The appropriate decision: Use supported Time Travel query or restoration syntax to recover the prior state.
D:The problem: A mistaken DELETE must be undone within the table's configured retention window. The appropriate decision: Use supported Time Travel query or restoration syntax to recover the prior state.
E:The problem: A mistaken DELETE must be undone within the table's configured retention window. The appropriate decision: Use supported Time Travel query or restoration syntax to recover the prior state.
Question 798
A query spends most time waiting to start while execution itself is quick Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Inspect Query Profile queue time and warehouse concurrency before resizing for CPU
- Interpret queue wait as remote disk spill
- Change table retention instead of concurrency
- Add clustering keys without addressing admission pressure
- Queue wait decreases after a suitable concurrency change
Explanation
Correct Answers
A:Inspect Query Profile queue time and warehouse concurrency before resizing for CPU. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: Queue wait decreases after a suitable concurrency change. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A query spends most time waiting to start while execution itself is quick. The appropriate decision: Inspect Query Profile queue time and warehouse concurrency before resizing for CPU.
C:The problem: A query spends most time waiting to start while execution itself is quick. The appropriate decision: Inspect Query Profile queue time and warehouse concurrency before resizing for CPU.
D:The problem: A query spends most time waiting to start while execution itself is quick. The appropriate decision: Inspect Query Profile queue time and warehouse concurrency before resizing for CPU.
Question 799
An operations team wants a catalog of its internal and purchased listings while respecting owner approvals The team proposes: Use supported listings and governed access request workflows. Which test outcome is the strongest direct evidence that this change works?
- Only internal-provider access is demonstrated instead of the intended consumer role
- The provider sees a shared object but the recipient cannot query it
- The listing is visible while unauthorized access is not tested
- Consumers access only subscribed or approved data products
Explanation
Correct Answer
D:Acceptance evidence: Consumers access only subscribed or approved data products. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Consumers access only subscribed or approved data products.
B:This observation is insufficient. The stronger validation is: Consumers access only subscribed or approved data products.
C:This observation is insufficient. The stronger validation is: Consumers access only subscribed or approved data products.
Question 800
A data pipeline needs automatic ingestion whenever new files arrive in a cloud stage Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Enable a result cache setting to subscribe to storage events
- Use a task to rename every input file but never ingest
- New staged files are loaded without manual COPY execution
- Set up Snowpipe with the supported auto-ingest event mechanism
- Create a normal table without a pipe and assume notifications trigger load
Explanation
Correct Answers
C:Acceptance evidence: New staged files are loaded without manual COPY execution. Completing configuration alone is insufficient.
D:Set up Snowpipe with the supported auto-ingest event mechanism. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A data pipeline needs automatic ingestion whenever new files arrive in a cloud stage. The appropriate decision: Set up Snowpipe with the supported auto-ingest event mechanism.
B:The problem: A data pipeline needs automatic ingestion whenever new files arrive in a cloud stage. The appropriate decision: Set up Snowpipe with the supported auto-ingest event mechanism.
E:The problem: A data pipeline needs automatic ingestion whenever new files arrive in a cloud stage. The appropriate decision: Set up Snowpipe with the supported auto-ingest event mechanism.
SnowPro Core COF-C03 Practice Tests