100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 290
A governance team assumes Fail-safe is an ordinary end-user time-machine for SQL restores The team proposes: Use Time Travel for self-service historical access and treat Fail-safe as a distinct Snowflake-managed recovery path. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- Recovery responsibilities and retention expectations are documented separately
- An unrelated compute counter improves with no correctness check
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: Recovery responsibilities and retention expectations are documented separately. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
C:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
D:This observation is insufficient. The stronger validation is: Recovery responsibilities and retention expectations are documented separately.
Question 291
An engineer must unload a query result to an authorized external cloud location Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- A table-loading COPY command is confused with unloading results
- The relevant users retain exactly their approved access
- The team confirms: The approved output files contain the expected exported records
Explanation
Correct Answer
B:Unresolved failure: A table-loading COPY command is confused with unloading results. 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: A table-loading COPY command is confused with unloading results.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A table-loading COPY command is confused with unloading results.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: A table-loading COPY command is confused with unloading results.
Question 292
A service user authenticates using a password embedded in deployment scripts Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Grant ACCOUNTADMIN to compensate for password issues
- Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys
- The service can sign in without storing plaintext passwords in code
- Disable credential rotation to avoid outages
- Put the password in a source-controlled SQL file
- Block release while: A leaked script directly exposes a reusable login credential
Explanation
Correct Answers
B:Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: The service can sign in without storing plaintext passwords in code. Completing configuration alone is insufficient.
F:Unresolved failure: A leaked script directly exposes a reusable login credential. Correct and test it before acceptance.
Incorrect Answers
A:The problem: A service user authenticates using a password embedded in deployment scripts. The appropriate decision: Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys.
D:The problem: A service user authenticates using a password embedded in deployment scripts. The appropriate decision: Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys.
E:The problem: A service user authenticates using a password embedded in deployment scripts. The appropriate decision: Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys.
Question 293
An application needs enforced primary-key uniqueness and low-latency individual-row updates The team proposes: Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
- Duplicate-key writes are rejected and point operations meet latency requirements
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
C:Acceptance evidence: Duplicate-key writes are rejected and point operations meet latency requirements. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Duplicate-key writes are rejected and point operations meet latency requirements.
B:This observation is insufficient. The stronger validation is: Duplicate-key writes are rejected and point operations meet latency requirements.
D:This observation is insufficient. The stronger validation is: Duplicate-key writes are rejected and point operations meet latency requirements.
Question 294
A consumer requests counts of distinct active customers by month and region Which technical action is most appropriate under this requirement?
- Use LIMIT to determine monthly distinct totals
- Count all events without distinct customer handling
- Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...)
- Group only by country and ignore requested region
Explanation
Correct Answer
C:Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A consumer requests counts of distinct active customers by month and region. The appropriate decision: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...).
B:The problem: A consumer requests counts of distinct active customers by month and region. The appropriate decision: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...).
D:The problem: A consumer requests counts of distinct active customers by month and region. The appropriate decision: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...).
Question 295
Many short concurrent dashboard requests are queued although each query runs quickly after admission The team proposes: Evaluate a multi-cluster warehouse in supported auto-scale mode. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- Additional clusters start during concurrent demand and queueing decreases
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: Additional clusters start during concurrent demand and queueing decreases. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Additional clusters start during concurrent demand and queueing decreases.
C:This observation is insufficient. The stronger validation is: Additional clusters start during concurrent demand and queueing decreases.
D:This observation is insufficient. The stronger validation is: Additional clusters start during concurrent demand and queueing decreases.
Question 296
A script needs a scratch table scoped to the current session and cleaned up automatically 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 object is visible in the intended session and unavailable after that session ends
- Session-only data accidentally persists as a shared production table
Explanation
Correct Answer
D:Unresolved failure: Session-only data accidentally persists as a shared production table. 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: Session-only data accidentally persists as a shared production table.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Session-only data accidentally persists as a shared production table.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Session-only data accidentally persists as a shared production table.
Question 297
An operator wants to remove stale SELECT access from a retired contractor role Which technical action is most appropriate under this requirement?
- Turn on query acceleration to revoke SELECT
- Grant OWNERSHIP to PUBLIC for simpler cleanup
- Revoke relevant grants and assignments while validating dependent role inheritance
- Delete the contractor's worksheet but leave grants
Explanation
Correct Answer
C:Revoke relevant grants and assignments while validating dependent role inheritance. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An operator wants to remove stale SELECT access from a retired contractor role. The appropriate decision: Revoke relevant grants and assignments while validating dependent role inheritance.
B:The problem: An operator wants to remove stale SELECT access from a retired contractor role. The appropriate decision: Revoke relevant grants and assignments while validating dependent role inheritance.
D:The problem: An operator wants to remove stale SELECT access from a retired contractor role. The appropriate decision: Revoke relevant grants and assignments while validating dependent role inheritance.
Question 298
Ownership of a production table needs to transfer to a different role during reorganization Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- An ownership change unexpectedly invalidates required privileges
- The relevant users retain exactly their approved access
- The team confirms: The new owner manages the table and existing grant behavior matches the approved transfer decision
Explanation
Correct Answer
B:Unresolved failure: An ownership change unexpectedly invalidates required privileges. 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: An ownership change unexpectedly invalidates required privileges.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: An ownership change unexpectedly invalidates required privileges.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: An ownership change unexpectedly invalidates required privileges.
Question 299
A BI workload has thousands of short concurrent requests but one report uses enormous memory Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Disable Query Profile after resizing
- Separate concurrency scaling decisions from warehouse resizing for the memory-heavy report
- Queue latency and remote spill are measured separately and addressed by suitable configurations
- Increase max cluster count and assume every single query gains memory
- Choose a larger warehouse solely to resolve all queueing
Explanation
Correct Answers
B:Separate concurrency scaling decisions from warehouse resizing for the memory-heavy report. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Queue latency and remote spill are measured separately and addressed by suitable configurations. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A BI workload has thousands of short concurrent requests but one report uses enormous memory. The appropriate decision: Separate concurrency scaling decisions from warehouse resizing for the memory-heavy report.
D:The problem: A BI workload has thousands of short concurrent requests but one report uses enormous memory. The appropriate decision: Separate concurrency scaling decisions from warehouse resizing for the memory-heavy report.
E:The problem: A BI workload has thousands of short concurrent requests but one report uses enormous memory. The appropriate decision: Separate concurrency scaling decisions from warehouse resizing for the memory-heavy report.
Question 300
A machine-learning feature pipeline repeatedly computes wide transformations and uses excessive remote spill The team proposes: Break down the transformations and benchmark warehouse memory versus intermediate materialization. Which test outcome is the strongest direct evidence that this change works?
- A single warm-cache run is cited without representative execution metrics
- The query finishes but returns a different business total
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The chosen design reduces spill while retaining validated feature outputs
Explanation
Correct Answer
D:Acceptance evidence: The chosen design reduces spill while retaining validated feature outputs. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
B:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
C:This observation is insufficient. The stronger validation is: The chosen design reduces spill while retaining validated feature outputs.
SnowPro Core COF-C03 Practice Tests