100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 780
A development warehouse sits idle for hours after short interactive queries Which unresolved finding would be a valid reason to block acceptance after the change?
- Idle compute continues consuming credits without useful work
- The team confirms: Warehouse billing intervals stop after the intended idle threshold
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Idle compute continues consuming credits without useful work. Correct and test it before acceptance.
Incorrect Answers
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Idle compute continues consuming credits without useful work.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Idle compute continues consuming credits without useful work.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Idle compute continues consuming credits without useful work.
Question 781
A restricted support role needs to review user metadata without being able to manage all grants Which proposal best pairs a technically correct change with the outcome that would validate it?
- Grant MANAGE GRANTS for every help-desk lookup; no direct validation of The role can view authorized metadata but cannot grant broad data permissions
- Share a SYSADMIN password with support; no direct validation of The role can view authorized metadata but cannot grant broad data permissions
- Create a least-privilege access path aligned with supported metadata privileges; verify The role can view authorized metadata but cannot grant broad data permissions
- Assign ACCOUNTADMIN as a read-only role; no direct validation of The role can view authorized metadata but cannot grant broad data permissions
Explanation
Correct Answer
C:Create a least-privilege access path aligned with supported metadata privileges. Verify: The role can view authorized metadata but cannot grant broad data permissions.
Incorrect Answers
A:Required correction: Create a least-privilege access path aligned with supported metadata privileges. Evidence: The role can view authorized metadata but cannot grant broad data permissions.
B:Required correction: Create a least-privilege access path aligned with supported metadata privileges. Evidence: The role can view authorized metadata but cannot grant broad data permissions.
D:Required correction: Create a least-privilege access path aligned with supported metadata privileges. Evidence: The role can view authorized metadata but cannot grant broad data permissions.
Question 782
A consumer account queries provider-owned shared tables but is uncertain where query compute is billed The team proposes: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. 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 consumer's query credits are attributable to its chosen warehouse
- The listing is visible while unauthorized access is not tested
Explanation
Correct Answer
C:Acceptance evidence: The consumer's query credits are attributable to its chosen warehouse. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The consumer's query credits are attributable to its chosen warehouse.
B:This observation is insufficient. The stronger validation is: The consumer's query credits are attributable to its chosen warehouse.
D:This observation is insufficient. The stronger validation is: The consumer's query credits are attributable to its chosen warehouse.
Question 783
A CSV file begins with a header row that must not become a data record The team proposes: Configure the appropriate CSV file-format header handling. Which test outcome is the strongest direct evidence that this change works?
- The first imported row matches actual business data rather than column names
- One connector starts but no expected event arrives
- The staged file appears in LIST but no destination row is validated
- A job status is green without comparing source and target record counts
Explanation
Correct Answer
A:Acceptance evidence: The first imported row matches actual business data rather than column names. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The first imported row matches actual business data rather than column names.
C:This observation is insufficient. The stronger validation is: The first imported row matches actual business data rather than column names.
D:This observation is insufficient. The stronger validation is: The first imported row matches actual business data rather than column names.
Question 784
A finance app must calculate a conversion ratio without divide-by-zero runtime failures Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Assume all denominators are positive without checks
- Change warehouse size to alter arithmetic behavior
- Zero denominators yield a documented safe result rather than a runtime error
- Mask source columns instead of guarding division
- Use NULLIF or a suitable safe-division expression when denominators can be zero
Explanation
Correct Answers
C:Acceptance evidence: Zero denominators yield a documented safe result rather than a runtime error. Completing configuration alone is insufficient.
E:Use NULLIF or a suitable safe-division expression when denominators can be zero. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A finance app must calculate a conversion ratio without divide-by-zero runtime failures. The appropriate decision: Use NULLIF or a suitable safe-division expression when denominators can be zero.
B:The problem: A finance app must calculate a conversion ratio without divide-by-zero runtime failures. The appropriate decision: Use NULLIF or a suitable safe-division expression when denominators can be zero.
D:The problem: A finance app must calculate a conversion ratio without divide-by-zero runtime failures. The appropriate decision: Use NULLIF or a suitable safe-division expression when denominators can be zero.
Question 785
A reporting job has unpredictable execution length and operators confuse query timeout with warehouse idle timeout Which technical action is most appropriate under this requirement?
- Use AUTO_SUSPEND as an application request timeout
- Put timeout controls in an unrelated stage definition
- Configure statement timeout and auto-suspend independently for their separate purposes
- Set only STATEMENT_TIMEOUT and assume it suspends idle compute
Explanation
Correct Answer
C: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.
B: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.
D: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 786
External operational records from a supported third-party SaaS system need managed ingestion The team proposes: Assess an approved Openflow or supported connector matching that source and security requirements. Which test outcome is the strongest direct evidence that this change works?
- One connector starts but no expected event arrives
- The connector ingests expected records with documented access and error visibility
- A job status is green without comparing source and target record counts
- The staged file appears in LIST but no destination row is validated
Explanation
Correct Answer
B:Acceptance evidence: The connector ingests expected records with documented access and error visibility. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The connector ingests expected records with documented access and error visibility.
C:This observation is insufficient. The stronger validation is: The connector ingests expected records with documented access and error visibility.
D:This observation is insufficient. The stronger validation is: The connector ingests expected records with documented access and error visibility.
Question 787
A platform team wants a derived table to refresh automatically toward a configured freshness target The team proposes: Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG. Which test outcome is the strongest direct evidence that this change works?
- One connector starts but no expected event arrives
- The staged file appears in LIST but no destination row is validated
- A job status is green without comparing source and target record counts
- Refresh history and downstream data freshness meet the specified lag expectation
Explanation
Correct Answer
D:Acceptance evidence: Refresh history and downstream data freshness meet the specified lag expectation. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Refresh history and downstream data freshness meet the specified lag expectation.
B:This observation is insufficient. The stronger validation is: Refresh history and downstream data freshness meet the specified lag expectation.
C:This observation is insufficient. The stronger validation is: Refresh history and downstream data freshness meet the specified lag expectation.
Question 788
A legacy source sends variable JSON schemas but downstream analysts require selected typed columns Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: The consumer queries stable typed columns while raw documents remain available
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- Consumers depend on shifting raw payload structures without a stable contract
Explanation
Correct Answer
D:Unresolved failure: Consumers depend on shifting raw payload structures without a stable contract. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Consumers depend on shifting raw payload structures without a stable contract.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Consumers depend on shifting raw payload structures without a stable contract.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Consumers depend on shifting raw payload structures without a stable contract.
Question 789
A data mart must calculate a rolling seven-day metric per store 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
- The team confirms: Each store's rolling values match independently recomputed windows
- The metric accidentally crosses store boundaries or frames the wrong dates
Explanation
Correct Answer
D:Unresolved failure: The metric accidentally crosses store boundaries or frames the wrong dates. 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 metric accidentally crosses store boundaries or frames the wrong dates.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The metric accidentally crosses store boundaries or frames the wrong dates.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The metric accidentally crosses store boundaries or frames the wrong dates.
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.
SnowPro Core COF-C03 Practice Tests