100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 410
A warehouse consistently experiences skewed query durations and the team only examines averages Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Use one warm-cache query as the entire performance benchmark
- Review query history by workload and profile slow outliers separately
- P95 latency and specific bottleneck classes can be measured and improved
- Erase query history and compare only the fastest run
- Set a network rule to fix slow execution skew
Explanation
Correct Answers
B:Review query history by workload and profile slow outliers separately. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: P95 latency and specific bottleneck classes can be measured and improved. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A warehouse consistently experiences skewed query durations and the team only examines averages. The appropriate decision: Review query history by workload and profile slow outliers separately.
D:The problem: A warehouse consistently experiences skewed query durations and the team only examines averages. The appropriate decision: Review query history by workload and profile slow outliers separately.
E:The problem: A warehouse consistently experiences skewed query durations and the team only examines averages. The appropriate decision: Review query history by workload and profile slow outliers separately.
Question 411
A scheduled pipeline runs a transformation every hour independent of new input The team proposes: Create a task with the required SQL and a valid schedule. Which test outcome is the strongest direct evidence that this change works?
- The task run history shows expected hourly executions
- The staged file appears in LIST but no destination row is validated
- One connector starts but no expected event arrives
- A job status is green without comparing source and target record counts
Explanation
Correct Answer
A:Acceptance evidence: The task run history shows expected hourly executions. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The task run history shows expected hourly executions.
C:This observation is insufficient. The stronger validation is: The task run history shows expected hourly executions.
D:This observation is insufficient. The stronger validation is: The task run history shows expected hourly executions.
Question 412
A security team wants proactive configuration risk findings for its Snowflake account Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Disable security findings to improve the dashboard
- Use only result cache hits as a security score
- Review supported Trust Center findings and apply confirmed remediation
- Relevant findings show remediated settings with retained evidence
- Create a dummy table to represent compliance
Explanation
Correct Answers
C:Review supported Trust Center findings and apply confirmed remediation. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: Relevant findings show remediated settings with retained evidence. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A security team wants proactive configuration risk findings for its Snowflake account. The appropriate decision: Review supported Trust Center findings and apply confirmed remediation.
B:The problem: A security team wants proactive configuration risk findings for its Snowflake account. The appropriate decision: Review supported Trust Center findings and apply confirmed remediation.
E:The problem: A security team wants proactive configuration risk findings for its Snowflake account. The appropriate decision: Review supported Trust Center findings and apply confirmed remediation.
Question 413
A partner already has a Snowflake account and needs read-only access to selected live provider data 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: The consumer queries approved shared objects without copying provider table data
- The partner receives broader source-object access than the contract allows
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: The partner receives broader source-object access than the contract allows. 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: The partner receives broader source-object access than the contract allows.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: The partner receives broader source-object access than the contract allows.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The partner receives broader source-object access than the contract allows.
Question 414
A cross-region consumer requires data collaboration but direct same-region share assumptions do not apply Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- The team confirms: The consumer receives the approved data product through a verified supported regional path
- A same-region capability is assumed to work without cross-region design
- The relevant users retain exactly their approved access
Explanation
Correct Answer
C:Unresolved failure: A same-region capability is assumed to work without cross-region design. 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: A same-region capability is assumed to work without cross-region design.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: A same-region capability is assumed to work without cross-region design.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A same-region capability is assumed to work without cross-region design.
Question 415
Repeated queries become slower immediately after the team suspends its warehouse each minute Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Grant access to an additional role instead of tuning compute
- Warm runs on the same active warehouse improve without assuming cache persists through suspension
- Add a longer table retention period to preserve cache
- Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally
- Change database name for every execution
Explanation
Correct Answers
B:Acceptance evidence: Warm runs on the same active warehouse improve without assuming cache persists through suspension. Completing configuration alone is insufficient.
D:Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: Repeated queries become slower immediately after the team suspends its warehouse each minute. The appropriate decision: Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally.
C:The problem: Repeated queries become slower immediately after the team suspends its warehouse each minute. The appropriate decision: Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally.
E:The problem: Repeated queries become slower immediately after the team suspends its warehouse each minute. The appropriate decision: Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally.
Question 416
A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration 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
- A secondary replica is assumed writable before supported promotion
- The team confirms: The promoted destination accepts authorized writes under approved recovery controls
Explanation
Correct Answer
C:Unresolved failure: A secondary replica is assumed writable before supported promotion. 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: A secondary replica is assumed writable before supported promotion.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A secondary replica is assumed writable before supported promotion.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: A secondary replica is assumed writable before supported promotion.
Question 417
A team manages an Apache Iceberg lake in its own object store and needs Snowflake SQL interoperability Which technical action is most appropriate under this requirement?
- Create an unrelated user stage instead of catalog integration
- Evaluate a Snowflake Iceberg table with the supported catalog and external volume design
- Silently move all data into an ordinary Snowflake managed table
- Query the raw object-store path as if it were already a SQL table
Explanation
Correct Answer
B:Evaluate a Snowflake Iceberg table with the supported catalog and external volume design. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A team manages an Apache Iceberg lake in its own object store and needs Snowflake SQL interoperability. The appropriate decision: Evaluate a Snowflake Iceberg table with the supported catalog and external volume design.
C:The problem: A team manages an Apache Iceberg lake in its own object store and needs Snowflake SQL interoperability. The appropriate decision: Evaluate a Snowflake Iceberg table with the supported catalog and external volume design.
D:The problem: A team manages an Apache Iceberg lake in its own object store and needs Snowflake SQL interoperability. The appropriate decision: Evaluate a Snowflake Iceberg table with the supported catalog and external volume design.
Question 418
A consumer requests counts of distinct active customers by month and region Which unresolved finding would be a valid reason to block acceptance after the change?
- Duplicate events inflate the metric and grouping grain is incorrect
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- The team confirms: The result has one row per requested grain with nonduplicated customer counts
Explanation
Correct Answer
A:Unresolved failure: Duplicate events inflate the metric and grouping grain is incorrect. 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: Duplicate events inflate the metric and grouping grain is incorrect.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Duplicate events inflate the metric and grouping grain is incorrect.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Duplicate events inflate the metric and grouping grain is incorrect.
Question 419
A data provider manages reader accounts and wants to monitor their compute spend 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 team confirms: Reader-account usage is tracked and constrained according to the contract
- Unexpected reader compute costs go unnoticed by the provider
Explanation
Correct Answer
D:Unresolved failure: Unexpected reader compute costs go unnoticed by the provider. 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: Unexpected reader compute costs go unnoticed by the provider.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Unexpected reader compute costs go unnoticed by the provider.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Unexpected reader compute costs go unnoticed by the provider.
Question 420
An application needs narrowly scoped privileges inside one database without account-wide administrative power Which unresolved finding would be a valid reason to block acceptance after the change?
- The database privilege scope expands unnecessarily across the whole account
- Change and rollback evidence is retained with the release
- The team confirms: The application gains scoped object access without broad account-level privileges
- The relevant users retain exactly their approved access
Explanation
Correct Answer
A:Unresolved failure: The database privilege scope expands unnecessarily across the whole account. 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 database privilege scope expands unnecessarily across the whole account.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The database privilege scope expands unnecessarily across the whole account.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The database privilege scope expands unnecessarily across the whole account.
SnowPro Core COF-C03 Practice Tests