100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 110
A team assumes a warehouse resource monitor also caps every serverless service credit in the account Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Each charge category is governed by an appropriate supported mechanism
- Change and rollback evidence is retained with the release
- Serverless service costs escape an incorrectly scoped monitor
- The relevant users retain exactly their approved access
Explanation
Correct Answer
C:Unresolved failure: Serverless service costs escape an incorrectly scoped monitor. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Serverless service costs escape an incorrectly scoped monitor.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Serverless service costs escape an incorrectly scoped monitor.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Serverless service costs escape an incorrectly scoped monitor.
Question 111
An architect wants a policy to apply to all columns carrying a sensitive classification tag where supported Which technical action is most appropriate under this requirement?
- Use a separate query warehouse as a data classification control
- Evaluate tag-based masking governance with tested inherited policy behavior
- Grant all users table ownership to see masked data
- Treat adding a label as proof that masking occurred
Explanation
Correct Answer
B:Evaluate tag-based masking governance with tested inherited policy behavior. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An architect wants a policy to apply to all columns carrying a sensitive classification tag where supported. The appropriate decision: Evaluate tag-based masking governance with tested inherited policy behavior.
C:The problem: An architect wants a policy to apply to all columns carrying a sensitive classification tag where supported. The appropriate decision: Evaluate tag-based masking governance with tested inherited policy behavior.
D:The problem: An architect wants a policy to apply to all columns carrying a sensitive classification tag where supported. The appropriate decision: Evaluate tag-based masking governance with tested inherited policy behavior.
Question 112
A scheduled pipeline runs a transformation every hour independent of new input Which technical action is most appropriate under this requirement?
- Set AUTO_RESUME instead of creating a task
- Create a task with the required SQL and a valid schedule
- Create a view and assume it schedules itself
- Use a masking policy as a scheduler
Explanation
Correct Answer
B:Create a task with the required SQL and a valid schedule. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A scheduled pipeline runs a transformation every hour independent of new input. The appropriate decision: Create a task with the required SQL and a valid schedule.
C:The problem: A scheduled pipeline runs a transformation every hour independent of new input. The appropriate decision: Create a task with the required SQL and a valid schedule.
D:The problem: A scheduled pipeline runs a transformation every hour independent of new input. The appropriate decision: Create a task with the required SQL and a valid schedule.
Question 113
A warehouse consistently experiences skewed query durations and the team only examines averages The team proposes: Review query history by workload and profile slow outliers separately. 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
- P95 latency and specific bottleneck classes can be measured and improved
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
C:Acceptance evidence: P95 latency and specific bottleneck classes can be measured and improved. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: P95 latency and specific bottleneck classes can be measured and improved.
B:This observation is insufficient. The stronger validation is: P95 latency and specific bottleneck classes can be measured and improved.
D:This observation is insufficient. The stronger validation is: P95 latency and specific bottleneck classes can be measured and improved.
Question 114
A governance team assumes Fail-safe is an ordinary end-user time-machine for SQL restores Which proposal best pairs a technically correct change with the outcome that would validate it?
- Use AT BEFORE syntax to query Fail-safe beyond Time Travel; no direct validation of Recovery responsibilities and retention expectations are documented separately
- Disable data protection because Fail-safe is equivalent to backups; no direct validation of Recovery responsibilities and retention expectations are documented separately
- Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path; verify Recovery responsibilities and retention expectations are documented separately
- Restore Fail-safe by querying a client driver cache; no direct validation of Recovery responsibilities and retention expectations are documented separately
Explanation
Correct Answer
C:Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Verify: Recovery responsibilities and retention expectations are documented separately.
Incorrect Answers
A:Required correction: Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Evidence: Recovery responsibilities and retention expectations are documented separately.
B:Required correction: Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Evidence: Recovery responsibilities and retention expectations are documented separately.
D:Required correction: Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Evidence: Recovery responsibilities and retention expectations are documented separately.
Question 115
A legacy source sends variable JSON schemas but downstream analysts require selected typed columns The team proposes: Extract and cast needed VARIANT paths in a governed SQL view. Which test outcome is the strongest direct evidence that this change works?
- The consumer queries stable typed columns while raw documents remain available
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
Explanation
Correct Answer
A:Acceptance evidence: The consumer queries stable typed columns while raw documents remain available. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The consumer queries stable typed columns while raw documents remain available.
C:This observation is insufficient. The stronger validation is: The consumer queries stable typed columns while raw documents remain available.
D:This observation is insufficient. The stronger validation is: The consumer queries stable typed columns while raw documents remain available.
Question 116
Existing tables need a one-time grant while the schema already has future grants The team proposes: Apply appropriate grants to existing objects separately from future grants. Which test outcome is the strongest direct evidence that this change works?
- A role name looks correct while the effective grants remain unchecked
- Both current and subsequently created eligible tables have the authorized access
- An administrator can run the query but a standard role remains unauthorized
- The policy is listed in metadata but denied accesses are never tested
Explanation
Correct Answer
B:Acceptance evidence: Both current and subsequently created eligible tables have the authorized access. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Both current and subsequently created eligible tables have the authorized access.
C:This observation is insufficient. The stronger validation is: Both current and subsequently created eligible tables have the authorized access.
D:This observation is insufficient. The stronger validation is: Both current and subsequently created eligible tables have the authorized access.
Question 117
Security policy requires Snowflake logins only from designated corporate network ranges The team proposes: Apply an appropriate network policy to the supported account or user scope. Which test outcome is the strongest direct evidence that this change works?
- A role name looks correct while the effective grants remain unchecked
- An administrator can run the query but a standard role remains unauthorized
- The policy is listed in metadata but denied accesses are never tested
- Connections from allowed addresses succeed and denied addresses fail
Explanation
Correct Answer
D:Acceptance evidence: Connections from allowed addresses succeed and denied addresses fail. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Connections from allowed addresses succeed and denied addresses fail.
B:This observation is insufficient. The stronger validation is: Connections from allowed addresses succeed and denied addresses fail.
C:This observation is insufficient. The stronger validation is: Connections from allowed addresses succeed and denied addresses fail.
Question 118
A consumer requests counts of distinct active customers by month and region The team proposes: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). Which test outcome is the strongest direct evidence that this change works?
- The query finishes but returns a different business total
- The result has one row per requested grain with nonduplicated customer counts
- 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
Explanation
Correct Answer
B:Acceptance evidence: The result has one row per requested grain with nonduplicated customer counts. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The result has one row per requested grain with nonduplicated customer counts.
C:This observation is insufficient. The stronger validation is: The result has one row per requested grain with nonduplicated customer counts.
D:This observation is insufficient. The stronger validation is: The result has one row per requested grain with nonduplicated customer counts.
Question 119
A materialized view speeds up a dashboard but creates unexpected background maintenance charges Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Create more materialized views on every column automatically
- Block release while: Expensive refresh outweighs saved query compute
- Compare query savings with materialized-view refresh and storage costs
- Treat a view SQL definition as a zero-cost cache
- Assume materialized views have no maintenance credits
- The net cost and latency satisfy the approved workload requirement
Explanation
Correct Answers
B:Unresolved failure: Expensive refresh outweighs saved query compute. Correct and test it before acceptance.
C:Compare query savings with materialized-view refresh and storage costs. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: The net cost and latency satisfy the approved workload requirement. Completing configuration alone is insufficient.
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.
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.
E: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 120
A small internal API needs a containerized service near governed Snowflake data Which technical action is most appropriate under this requirement?
- Create a role name instead of deploying a service
- Evaluate Snowpark Container Services and its supported compute, networking and permissions
- Store container configuration only in a table comment
- Place an unmanaged container on a user's laptop
Explanation
Correct Answer
B:Evaluate Snowpark Container Services and its supported compute, networking and permissions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A small internal API needs a containerized service near governed Snowflake data. The appropriate decision: Evaluate Snowpark Container Services and its supported compute, networking and permissions.
C:The problem: A small internal API needs a containerized service near governed Snowflake data. The appropriate decision: Evaluate Snowpark Container Services and its supported compute, networking and permissions.
D:The problem: A small internal API needs a containerized service near governed Snowflake data. The appropriate decision: Evaluate Snowpark Container Services and its supported compute, networking and permissions.
SnowPro Core COF-C03 Practice Tests