100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 20
A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Put timeout controls in an unrelated stage definition
- Long-running statements and idle periods follow the distinct defined policies
- Set only STATEMENT_TIMEOUT and assume it suspends idle compute
- Configure statement timeout and auto-suspend independently for their separate purposes
- Use AUTO_SUSPEND as an application request timeout
Explanation
Correct Answers
B:Acceptance evidence: Long-running statements and idle periods follow the distinct defined policies. Completing configuration alone is insufficient.
D:Configure statement timeout and auto-suspend independently for their separate purposes. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout. The appropriate decision: Configure statement timeout and auto-suspend independently for their separate purposes.
C:The problem: A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout. The appropriate decision: Configure statement timeout and auto-suspend independently for their separate purposes.
E:The problem: A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout. The appropriate decision: Configure statement timeout and auto-suspend independently for their separate purposes.
Question 21
A cross-region consumer requires data collaboration but direct same-region share assumptions do not apply Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: A same-region capability is assumed to work without cross-region design
- Change only the consumer warehouse name to move regions
- Publish all files to an unrestricted web bucket
- The consumer receives the approved data product through a verified supported regional path
- Attempt a direct same-region share to an unsupported remote region
- Evaluate supported cross-region listing and replication arrangements for the accounts and editions
Explanation
Correct Answers
A:Unresolved failure: A same-region capability is assumed to work without cross-region design. Correct and test it before acceptance.
D:Acceptance evidence: The consumer receives the approved data product through a verified supported regional path. Completing configuration alone is insufficient.
F:Evaluate supported cross-region listing and replication arrangements for the accounts and editions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A cross-region consumer requires data collaboration but direct same-region share assumptions do not apply. The appropriate decision: Evaluate supported cross-region listing and replication arrangements for the accounts and editions.
C:The problem: A cross-region consumer requires data collaboration but direct same-region share assumptions do not apply. The appropriate decision: Evaluate supported cross-region listing and replication arrangements for the accounts and editions.
E:The problem: A cross-region consumer requires data collaboration but direct same-region share assumptions do not apply. The appropriate decision: Evaluate supported cross-region listing and replication arrangements for the accounts and editions.
Question 22
An operations policy allows removal of staged files only after an accountable load Which technical action is most appropriate under this requirement?
- Purge all stage files immediately on arrival
- Disable COPY_HISTORY to reduce cleanup warnings
- Set the warehouse to X-SMALL as a file-deletion gate
- Use COPY purge settings or REMOVE only after verified successful ingestion
Explanation
Correct Answer
D:Use COPY purge settings or REMOVE only after verified successful ingestion. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An operations policy allows removal of staged files only after an accountable load. The appropriate decision: Use COPY purge settings or REMOVE only after verified successful ingestion.
B:The problem: An operations policy allows removal of staged files only after an accountable load. The appropriate decision: Use COPY purge settings or REMOVE only after verified successful ingestion.
C:The problem: An operations policy allows removal of staged files only after an accountable load. The appropriate decision: Use COPY purge settings or REMOVE only after verified successful ingestion.
Question 23
An auditor finds repeated direct grants to individual users and wants consistent offboarding Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Put identity control in a file format definition
- Assign privileges to governed roles and grant those roles to users
- Removing a user-role assignment revokes its associated access consistently
- Disable access histories to hide old grants
- Block release while: Individual ad hoc grants survive employee role changes
- Grant OWNERSHIP to each user on every table
Explanation
Correct Answers
B:Assign privileges to governed roles and grant those roles to users. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Removing a user-role assignment revokes its associated access consistently. Completing configuration alone is insufficient.
E:Unresolved failure: Individual ad hoc grants survive employee role changes. Correct and test it before acceptance.
Incorrect Answers
A:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
D:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
F:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
Question 24
A JSON stage includes multiple variant event types and downstream needs only one event category Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Force all staged data into a VARCHAR table without filtering
- Block release while: Unrelated event types are loaded into the wrong model
- Use supported COPY selection or staged transformations to filter and map relevant records
- Change query result format to remove unrelated events
- The target landing table contains only the approved events with traceable load output
- Use a network policy as a row-level ingestion filter
Explanation
Correct Answers
B:Unresolved failure: Unrelated event types are loaded into the wrong model. Correct and test it before acceptance.
C:Use supported COPY selection or staged transformations to filter and map relevant records. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: The target landing table contains only the approved events with traceable load output. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A JSON stage includes multiple variant event types and downstream needs only one event category. The appropriate decision: Use supported COPY selection or staged transformations to filter and map relevant records.
D:The problem: A JSON stage includes multiple variant event types and downstream needs only one event category. The appropriate decision: Use supported COPY selection or staged transformations to filter and map relevant records.
F:The problem: A JSON stage includes multiple variant event types and downstream needs only one event category. The appropriate decision: Use supported COPY selection or staged transformations to filter and map relevant records.
Question 25
A small internal API needs a containerized service near governed Snowflake data Which unresolved finding would be a valid reason to block acceptance after the change?
- The solution assumes an ordinary SQL warehouse alone hosts arbitrary container workloads
- The relevant users retain exactly their approved access
- The team confirms: The service executes in the authorized compute pool and follows network policy
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: The solution assumes an ordinary SQL warehouse alone hosts arbitrary container workloads. 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: The solution assumes an ordinary SQL warehouse alone hosts arbitrary container workloads.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The solution assumes an ordinary SQL warehouse alone hosts arbitrary container workloads.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The solution assumes an ordinary SQL warehouse alone hosts arbitrary container workloads.
Question 26
A restricted support role needs to review user metadata without being able to manage all grants 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: The role can view authorized metadata but cannot grant broad data permissions
- Read-only support work unexpectedly confers global grant authority
Explanation
Correct Answer
D:Unresolved failure: Read-only support work unexpectedly confers global grant authority. 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: Read-only support work unexpectedly confers global grant authority.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Read-only support work unexpectedly confers global grant authority.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Read-only support work unexpectedly confers global grant authority.
Question 27
A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Add more DISTINCT operations as a universal tuning fix
- Remove the redundant join or adjust grain after inspecting intermediate cardinalities
- Increase warehouse size without investigating the join
- The correct aggregate result is produced with fewer processed rows
- Block release while: Compute and cost are wasted masking incorrect join multiplicity
- Change user login policies to reduce join rows
Explanation
Correct Answers
B:Remove the redundant join or adjust grain after inspecting intermediate cardinalities. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: The correct aggregate result is produced with fewer processed rows. Completing configuration alone is insufficient.
E:Unresolved failure: Compute and cost are wasted masking incorrect join multiplicity. Correct and test it before acceptance.
Incorrect Answers
A:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
C:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
F:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
Question 28
A team assumes a warehouse resource monitor also caps every serverless service credit in the account Which technical action is most appropriate under this requirement?
- Set an unrelated VARCHAR limit as the service budget
- Assume all serverless workloads run inside the monitored warehouse
- Grant SELECT as a cost-control action
- Distinguish warehouse resource monitor scope from supported budgets and service-specific cost controls
Explanation
Correct Answer
D:Distinguish warehouse resource monitor scope from supported budgets and service-specific cost controls. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A team assumes a warehouse resource monitor also caps every serverless service credit in the account. The appropriate decision: Distinguish warehouse resource monitor scope from supported budgets and service-specific cost controls.
B:The problem: A team assumes a warehouse resource monitor also caps every serverless service credit in the account. The appropriate decision: Distinguish warehouse resource monitor scope from supported budgets and service-specific cost controls.
C:The problem: A team assumes a warehouse resource monitor also caps every serverless service credit in the account. The appropriate decision: Distinguish warehouse resource monitor scope from supported budgets and service-specific cost controls.
Question 29
The data stewardship team cannot explain where a downstream metric originated Which technical action is most appropriate under this requirement?
- Use a network rule as the source lineage record
- Change auto-suspend to create lineage metadata
- Rename downstream metrics instead of tracing dependencies
- Use supported lineage metadata and trace the source-to-consumer relationships
Explanation
Correct Answer
D:Use supported lineage metadata and trace the source-to-consumer relationships. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: The data stewardship team cannot explain where a downstream metric originated. The appropriate decision: Use supported lineage metadata and trace the source-to-consumer relationships.
B:The problem: The data stewardship team cannot explain where a downstream metric originated. The appropriate decision: Use supported lineage metadata and trace the source-to-consumer relationships.
C:The problem: The data stewardship team cannot explain where a downstream metric originated. The appropriate decision: Use supported lineage metadata and trace the source-to-consumer relationships.
Question 30
A quality team needs recurring null-rate checks on a critical table Which proposal best pairs a technically correct change with the outcome that would validate it?
- Use supported data metric functions or a governed quality check for the relevant table; verify Repeated checks report the expected null-rate and flag bad batches
- Apply Time Travel retention to make nulls disappear; no direct validation of Repeated checks report the expected null-rate and flag bad batches
- Use warehouse size as a null-value quality metric; no direct validation of Repeated checks report the expected null-rate and flag bad batches
- Grant PUBLIC SELECT as a substitute for checking records; no direct validation of Repeated checks report the expected null-rate and flag bad batches
Explanation
Correct Answer
A:Use supported data metric functions or a governed quality check for the relevant table. Verify: Repeated checks report the expected null-rate and flag bad batches.
Incorrect Answers
B:Required correction: Use supported data metric functions or a governed quality check for the relevant table. Evidence: Repeated checks report the expected null-rate and flag bad batches.
C:Required correction: Use supported data metric functions or a governed quality check for the relevant table. Evidence: Repeated checks report the expected null-rate and flag bad batches.
D:Required correction: Use supported data metric functions or a governed quality check for the relevant table. Evidence: Repeated checks report the expected null-rate and flag bad batches.
SnowPro Core COF-C03 Practice Tests