100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 50
A service wants to compare each event timestamp with the immediately prior event for its device Which technical action is most appropriate under this requirement?
- Use LAG with an appropriate PARTITION BY and deterministic ORDER BY
- Join every event to every other device event
- Use LEAD without checking direction and sorting
- Use COUNT(*) as a predecessor timestamp
Explanation
Correct Answer
A:Use LAG with an appropriate PARTITION BY and deterministic ORDER BY. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
C:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
D:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
Question 51
A source repository must be used to version SQL scripts and notebooks deployed into Snowflake 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 expected approved revision is referenced by the release pipeline
- Change and rollback evidence is retained with the release
- Production SQL runs an unreviewed script version copied from an engineer's laptop
Explanation
Correct Answer
D:Unresolved failure: Production SQL runs an unreviewed script version copied from an engineer's laptop. 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: Production SQL runs an unreviewed script version copied from an engineer's laptop.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Production SQL runs an unreviewed script version copied from an engineer's laptop.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Production SQL runs an unreviewed script version copied from an engineer's laptop.
Question 52
Security policy requires Snowflake logins only from designated corporate network ranges Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Grant table SELECT to the corporate VPN
- Apply an appropriate network policy to the supported account or user scope
- Connections from allowed addresses succeed and denied addresses fail
- Use a row access policy as a login firewall
- Block release while: Sensitive accounts remain reachable from unapproved networks
- Disable query result reuse to block IP ranges
Explanation
Correct Answers
B:Apply an appropriate network policy to the supported account or user scope. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Connections from allowed addresses succeed and denied addresses fail. Completing configuration alone is insufficient.
E:Unresolved failure: Sensitive accounts remain reachable from unapproved networks. Correct and test it before acceptance.
Incorrect Answers
A:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
D:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
F:The problem: Security policy requires Snowflake logins only from designated corporate network ranges. The appropriate decision: Apply an appropriate network policy to the supported account or user scope.
Question 53
After warehouse suspension the same query reads more remote data than before Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Rename SQL statements to force local cache survival
- Distinguish warehouse-local cache from persisted results and measure cold versus warm reads
- Enable MFA as a local cache recovery mechanism
- Cache behavior matches documented resume and execution conditions
- Increase Time Travel retention as a warm warehouse cache
Explanation
Correct Answers
B:Distinguish warehouse-local cache from persisted results and measure cold versus warm reads. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: Cache behavior matches documented resume and execution conditions. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: After warehouse suspension the same query reads more remote data than before. The appropriate decision: Distinguish warehouse-local cache from persisted results and measure cold versus warm reads.
C:The problem: After warehouse suspension the same query reads more remote data than before. The appropriate decision: Distinguish warehouse-local cache from persisted results and measure cold versus warm reads.
E:The problem: After warehouse suspension the same query reads more remote data than before. The appropriate decision: Distinguish warehouse-local cache from persisted results and measure cold versus warm reads.
Question 54
A large cloned analytics schema unexpectedly incurs compute costs after a workload changes Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Zero-copy cloning is presented as zero-cost query execution
- The team confirms: Storage and compute charges are measured separately for the clone workload
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: Zero-copy cloning is presented as zero-cost query execution. 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: Zero-copy cloning is presented as zero-cost query execution.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Zero-copy cloning is presented as zero-cost query execution.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Zero-copy cloning is presented as zero-cost query execution.
Question 55
A query searches for rare substrings in very large text fields using supported predicates The team proposes: Evaluate search optimization where the expression and type are eligible. Which test outcome is the strongest direct evidence that this change works?
- The query finishes but returns a different business total
- A single warm-cache run is cited without representative execution metrics
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- Supported substring lookups improve in measured tests
Explanation
Correct Answer
D:Acceptance evidence: Supported substring lookups improve in measured tests. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Supported substring lookups improve in measured tests.
B:This observation is insufficient. The stronger validation is: Supported substring lookups improve in measured tests.
C:This observation is insufficient. The stronger validation is: Supported substring lookups improve in measured tests.
Question 56
A JSON array contains multiple line items and a report needs one output row per element Which proposal best pairs a technically correct change with the outcome that would validate it?
- Replace FLATTEN with warehouse auto-resume; no direct validation of Each array item produces a traversable row with its position and value
- Use LATERAL FLATTEN on the array expression; verify Each array item produces a traversable row with its position and value
- Call an aggregate COUNT without expanding the array; no direct validation of Each array item produces a traversable row with its position and value
- Turn the JSON into a network policy; no direct validation of Each array item produces a traversable row with its position and value
Explanation
Correct Answer
B:Use LATERAL FLATTEN on the array expression. Verify: Each array item produces a traversable row with its position and value.
Incorrect Answers
A:Required correction: Use LATERAL FLATTEN on the array expression. Evidence: Each array item produces a traversable row with its position and value.
C:Required correction: Use LATERAL FLATTEN on the array expression. Evidence: Each array item produces a traversable row with its position and value.
D:Required correction: Use LATERAL FLATTEN on the array expression. Evidence: Each array item produces a traversable row with its position and value.
Question 57
An array stored inside a VARIANT purchase event must be expanded to order-line rows Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Use an ordinary inner join with no array expansion
- Each array element produces one order-line row linked to the parent event
- Use the supported LATERAL FLATTEN table function over the correct array path
- Group by a JSON string instead of reading its elements
- Cast the array to BOOLEAN to enumerate elements
Explanation
Correct Answers
B:Acceptance evidence: Each array element produces one order-line row linked to the parent event. Completing configuration alone is insufficient.
C:Use the supported LATERAL FLATTEN table function over the correct array path. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An array stored inside a VARIANT purchase event must be expanded to order-line rows. The appropriate decision: Use the supported LATERAL FLATTEN table function over the correct array path.
D:The problem: An array stored inside a VARIANT purchase event must be expanded to order-line rows. The appropriate decision: Use the supported LATERAL FLATTEN table function over the correct array path.
E:The problem: An array stored inside a VARIANT purchase event must be expanded to order-line rows. The appropriate decision: Use the supported LATERAL FLATTEN table function over the correct array path.
Question 58
A dynamic table falls behind its required freshness objective Which unresolved finding would be a valid reason to block acceptance after the change?
- Data consumers receive stale derived results while status appears healthy
- The relevant users retain exactly their approved access
- The team confirms: Actual refresh lag returns within the documented objective
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Data consumers receive stale derived results while status appears healthy. 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: Data consumers receive stale derived results while status appears healthy.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Data consumers receive stale derived results while status appears healthy.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Data consumers receive stale derived results while status appears healthy.
Question 59
An ETL procedure needs to merge new customer records and update matching existing rows The team proposes: Use MERGE with supported matching conditions and update/insert branches. Which test outcome is the strongest direct evidence that this change works?
- The query finishes but returns a different business total
- Existing keys update and new keys insert once under tested source conditions
- A single warm-cache run is cited without representative execution metrics
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
Explanation
Correct Answer
B:Acceptance evidence: Existing keys update and new keys insert once under tested source conditions. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Existing keys update and new keys insert once under tested source conditions.
C:This observation is insufficient. The stronger validation is: Existing keys update and new keys insert once under tested source conditions.
D:This observation is insufficient. The stronger validation is: Existing keys update and new keys insert once under tested source conditions.
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.
SnowPro Core COF-C03 Practice Tests