100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 60
A materialized view speeds up a dashboard but creates unexpected background maintenance charges Which technical action is most appropriate under this requirement?
- Treat a view SQL definition as a zero-cost cache
- Create more materialized views on every column automatically
- Compare query savings with materialized-view refresh and storage costs
- Assume materialized views have no maintenance credits
Explanation
Correct Answer
C:Compare query savings with materialized-view refresh and storage costs. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A materialized view speeds up a dashboard but creates unexpected background maintenance charges. The appropriate decision: Compare query savings with materialized-view refresh and storage costs.
B:The problem: A materialized view speeds up a dashboard but creates unexpected background maintenance charges. The appropriate decision: Compare query savings with materialized-view refresh and storage costs.
D:The problem: A materialized view speeds up a dashboard but creates unexpected background maintenance charges. The appropriate decision: Compare query savings with materialized-view refresh and storage costs.
Question 61
A report filters a huge event table on a selective date range but scans almost all partitions Which technical action is most appropriate under this requirement?
- Review partition pruning and effective clustering around the repeated filter
- Change database names as a predicate optimization
- Disable query history to improve partition selection
- Increase maximum clusters without inspecting scanned partitions
Explanation
Correct Answer
A:Review partition pruning and effective clustering around the repeated filter. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A report filters a huge event table on a selective date range but scans almost all partitions. The appropriate decision: Review partition pruning and effective clustering around the repeated filter.
C:The problem: A report filters a huge event table on a selective date range but scans almost all partitions. The appropriate decision: Review partition pruning and effective clustering around the repeated filter.
D:The problem: A report filters a huge event table on a selective date range but scans almost all partitions. The appropriate decision: Review partition pruning and effective clustering around the repeated filter.
Question 62
A query on a semi-structured attribute compares a JSON number stored as text to an integer Which unresolved finding would be a valid reason to block acceptance after the change?
- String comparisons incorrectly order numeric-like values
- The relevant users retain exactly their approved access
- The team confirms: The filter returns the intended records without lexical numeric ordering errors
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: String comparisons incorrectly order numeric-like values. 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: String comparisons incorrectly order numeric-like values.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: String comparisons incorrectly order numeric-like values.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: String comparisons incorrectly order numeric-like values.
Question 63
A masking policy uses CURRENT_ROLE but a consumer has several other granted roles Which unresolved finding would be a valid reason to block acceptance after the change?
- Policy authors assume every granted role influences CURRENT_ROLE identically
- The relevant users retain exactly their approved access
- The team confirms: The consumer's masking outcome matches documented active-role behavior
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Policy authors assume every granted role influences CURRENT_ROLE identically. 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: Policy authors assume every granted role influences CURRENT_ROLE identically.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Policy authors assume every granted role influences CURRENT_ROLE identically.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Policy authors assume every granted role influences CURRENT_ROLE identically.
Question 64
An optimization proposal adds search optimization to a tiny reference table with infrequent lookups Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: A new optimization costs more than its benefit
- Force all users onto one tiny warehouse without measuring latency
- Estimate maintenance overhead and query savings before enabling the service
- Enable every optimization service on every table automatically
- Disable usage tracking to conceal overhead
- Feature cost is justified only for the actual query workload
Explanation
Correct Answers
A:Unresolved failure: A new optimization costs more than its benefit. Correct and test it before acceptance.
C:Estimate maintenance overhead and query savings before enabling the service. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: Feature cost is justified only for the actual query workload. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: An optimization proposal adds search optimization to a tiny reference table with infrequent lookups. The appropriate decision: Estimate maintenance overhead and query savings before enabling the service.
D:The problem: An optimization proposal adds search optimization to a tiny reference table with infrequent lookups. The appropriate decision: Estimate maintenance overhead and query savings before enabling the service.
E:The problem: An optimization proposal adds search optimization to a tiny reference table with infrequent lookups. The appropriate decision: Estimate maintenance overhead and query savings before enabling the service.
Question 65
An overnight warehouse runs indefinitely after jobs finish and the team has a strict spending budget Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Use a view name to cap credits
- Block release while: Operational budgets are exceeded by unused compute
- Set auto-suspend and monitor warehouse credit usage against a policy
- Turn off query monitoring without adjusting idle behavior
- Idle credit consumption declines after the configured threshold
- Make the warehouse permanently larger
Explanation
Correct Answers
B:Unresolved failure: Operational budgets are exceeded by unused compute. Correct and test it before acceptance.
C:Set auto-suspend and monitor warehouse credit usage against a policy. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: Idle credit consumption declines after the configured threshold. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: An overnight warehouse runs indefinitely after jobs finish and the team has a strict spending budget. The appropriate decision: Set auto-suspend and monitor warehouse credit usage against a policy.
D:The problem: An overnight warehouse runs indefinitely after jobs finish and the team has a strict spending budget. The appropriate decision: Set auto-suspend and monitor warehouse credit usage against a policy.
F:The problem: An overnight warehouse runs indefinitely after jobs finish and the team has a strict spending budget. The appropriate decision: Set auto-suspend and monitor warehouse credit usage against a policy.
Question 66
A script needs a scratch table scoped to the current session and cleaned up automatically Which technical action is most appropriate under this requirement?
- Set all database roles to ACCOUNTADMIN for cleanup
- Store the scratch values in an external share
- Use a temporary table instead of a shared permanent object
- Create a permanent table with a global name
Explanation
Correct Answer
C:Use a temporary table instead of a shared permanent object. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A script needs a scratch table scoped to the current session and cleaned up automatically. The appropriate decision: Use a temporary table instead of a shared permanent object.
B:The problem: A script needs a scratch table scoped to the current session and cleaned up automatically. The appropriate decision: Use a temporary table instead of a shared permanent object.
D:The problem: A script needs a scratch table scoped to the current session and cleaned up automatically. The appropriate decision: Use a temporary table instead of a shared permanent object.
Question 67
An analyst wants to know why a query scanned many bytes when filters should have been selective Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Change SQL capitalization as a storage-pruning strategy
- Block release while: The team chooses a costly tuning feature without understanding the scan
- The diagnosis identifies whether scan cost comes from predicate selectivity or missing pruning
- Count Snowflake roles as the bytes scanned
- Use row access policies to hide query cost
- Open the Query Profile and inspect table scan and pruning statistics
Explanation
Correct Answers
B:Unresolved failure: The team chooses a costly tuning feature without understanding the scan. Correct and test it before acceptance.
C:Acceptance evidence: The diagnosis identifies whether scan cost comes from predicate selectivity or missing pruning. Completing configuration alone is insufficient.
F:Open the Query Profile and inspect table scan and pruning statistics. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
D:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
E:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
Question 68
A query performs remote disk spill despite little concurrency on its warehouse The team proposes: Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring. 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
- A single warm-cache run is cited without representative execution metrics
- Remote-spill bytes fall on representative runs
- The query finishes but returns a different business total
Explanation
Correct Answer
C:Acceptance evidence: Remote-spill bytes fall on representative runs. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Remote-spill bytes fall on representative runs.
B:This observation is insufficient. The stronger validation is: Remote-spill bytes fall on representative runs.
D:This observation is insufficient. The stronger validation is: Remote-spill bytes fall on representative runs.
Question 69
A team needs to compare cold and warm query timings without conflating result-cache reuse Which unresolved finding would be a valid reason to block acceptance after the change?
- An unchanged result cache hit is misreported as engine speedup
- The relevant users retain exactly their approved access
- The team confirms: Performance conclusions distinguish execution improvements from cached-result retrieval
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: An unchanged result cache hit is misreported as engine speedup. 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 unchanged result cache hit is misreported as engine speedup.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: An unchanged result cache hit is misreported as engine speedup.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: An unchanged result cache hit is misreported as engine speedup.
Question 70
A data product contract promises stable column names but the provider wants to rename source fields 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: Consumer queries continue to resolve the documented schema during approved changes
- Breaking source schema changes cause downstream consumer failures
Explanation
Correct Answer
D:Unresolved failure: Breaking source schema changes cause downstream consumer failures. 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: Breaking source schema changes cause downstream consumer failures.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Breaking source schema changes cause downstream consumer failures.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Breaking source schema changes cause downstream consumer failures.
SnowPro Core COF-C03 Practice Tests