100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 490
A company wants employees to authenticate through its corporate identity provider 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
- Authentication bypasses enterprise offboarding and identity policies
- The team confirms: Corporate sign-in works and user account privileges remain governed in Snowflake
Explanation
Correct Answer
C:Unresolved failure: Authentication bypasses enterprise offboarding and identity policies. 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: Authentication bypasses enterprise offboarding and identity policies.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Authentication bypasses enterprise offboarding and identity policies.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Authentication bypasses enterprise offboarding and identity policies.
Question 491
A workload only needs newly inserted rows and would like to avoid change-tracking overhead from updates Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Set warehouse max clusters as a stream type
- Use an append-only stream as a full CDC delete feed
- Turn a task schedule into a retention policy
- The stream surfaces intended inserts without pretending to capture deleted rows
- Evaluate an append-only stream where its semantics fit the source
Explanation
Correct Answers
D:Acceptance evidence: The stream surfaces intended inserts without pretending to capture deleted rows. Completing configuration alone is insufficient.
E:Evaluate an append-only stream where its semantics fit the source. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A workload only needs newly inserted rows and would like to avoid change-tracking overhead from updates. The appropriate decision: Evaluate an append-only stream where its semantics fit the source.
B:The problem: A workload only needs newly inserted rows and would like to avoid change-tracking overhead from updates. The appropriate decision: Evaluate an append-only stream where its semantics fit the source.
C:The problem: A workload only needs newly inserted rows and would like to avoid change-tracking overhead from updates. The appropriate decision: Evaluate an append-only stream where its semantics fit the source.
Question 492
An analytic workload repeatedly computes the same expensive aggregate over a large base table The team proposes: Evaluate a suitable materialized view under supported query and maintenance constraints. Which test outcome is the strongest direct evidence that this change works?
- The optimizer uses precomputed results and query latency improves while refresh cost is understood
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The query finishes but returns a different business total
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
A:Acceptance evidence: The optimizer uses precomputed results and query latency improves while refresh cost is understood. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The optimizer uses precomputed results and query latency improves while refresh cost is understood.
C:This observation is insufficient. The stronger validation is: The optimizer uses precomputed results and query latency improves while refresh cost is understood.
D:This observation is insufficient. The stronger validation is: The optimizer uses precomputed results and query latency improves while refresh cost is understood.
Question 493
A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Run INSERT directly against an unchanged secondary replica
- Increase secondary warehouse size as a promotion command
- Create a masking policy and call it database failover
- The promoted destination accepts authorized writes under approved recovery controls
- Use the documented promotion or failover workflow before treating the secondary as writable
Explanation
Correct Answers
D:Acceptance evidence: The promoted destination accepts authorized writes under approved recovery controls. Completing configuration alone is insufficient.
E:Use the documented promotion or failover workflow before treating the secondary as writable. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
B:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
C:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
Question 494
An organization needs a lightweight prototype of structured reports and generative summaries without provisioning a server The team proposes: Combine an approved Snowflake dashboard or notebook with supported Cortex functions. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- Authorized users can execute queries and review bounded generated text results
- The warehouse login succeeds but the required query fails
- A metadata row exists while no relevant data is tested
Explanation
Correct Answer
B:Acceptance evidence: Authorized users can execute queries and review bounded generated text results. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Authorized users can execute queries and review bounded generated text results.
C:This observation is insufficient. The stronger validation is: Authorized users can execute queries and review bounded generated text results.
D:This observation is insufficient. The stronger validation is: Authorized users can execute queries and review bounded generated text results.
Question 495
An IoT time-series table receives continuous inserts and date range queries slow as partition overlap rises Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- The team confirms: Clustering quality and critical date-range scan latency improve
- The relevant users retain exactly their approved access
- Increasing partition overlap drives avoidable reads
Explanation
Correct Answer
D:Unresolved failure: Increasing partition overlap drives avoidable reads. 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: Increasing partition overlap drives avoidable reads.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Increasing partition overlap drives avoidable reads.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Increasing partition overlap drives avoidable reads.
Question 496
A team selects transient storage for a durable regulatory archive with mandatory recovery assurances 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 archive's recovery behavior meets the retention requirements
- Reduced-protection transient semantics conflict with a required archive policy
Explanation
Correct Answer
D:Unresolved failure: Reduced-protection transient semantics conflict with a required archive policy. 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: Reduced-protection transient semantics conflict with a required archive policy.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Reduced-protection transient semantics conflict with a required archive policy.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Reduced-protection transient semantics conflict with a required archive policy.
Question 497
A batch import must reject invalid records rather than silently write partial bad data The team proposes: Choose an ON_ERROR behavior appropriate to the business contract and inspect load errors. Which test outcome is the strongest direct evidence that this change works?
- The load aborts or continues precisely as documented, with rejected records accounted for
- 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 load aborts or continues precisely as documented, with rejected records accounted for. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The load aborts or continues precisely as documented, with rejected records accounted for.
C:This observation is insufficient. The stronger validation is: The load aborts or continues precisely as documented, with rejected records accounted for.
D:This observation is insufficient. The stronger validation is: The load aborts or continues precisely as documented, with rejected records accounted for.
Question 498
A partner has dropped a batch of CSVs into a stage and wants an explicit bulk load to a relational table The team proposes: Use COPY INTO <table> with the correct stage path and file format. Which test outcome is the strongest direct evidence that this change works?
- The staged file appears in LIST but no destination row is validated
- One connector starts but no expected event arrives
- A job status is green without comparing source and target record counts
- The target table contains the expected rows and COPY reports the processed files
Explanation
Correct Answer
D:Acceptance evidence: The target table contains the expected rows and COPY reports the processed files. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The target table contains the expected rows and COPY reports the processed files.
B:This observation is insufficient. The stronger validation is: The target table contains the expected rows and COPY reports the processed files.
C:This observation is insufficient. The stronger validation is: The target table contains the expected rows and COPY reports the processed files.
Question 499
An auditor finds repeated direct grants to individual users and wants consistent offboarding Which technical action is most appropriate under this requirement?
- Disable access histories to hide old grants
- Grant OWNERSHIP to each user on every table
- Assign privileges to governed roles and grant those roles to users
- Put identity control in a file format definition
Explanation
Correct Answer
C:Assign privileges to governed roles and grant those roles to users. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
B:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
D:The problem: An auditor finds repeated direct grants to individual users and wants consistent offboarding. The appropriate decision: Assign privileges to governed roles and grant those roles to users.
Question 500
A developer needs a non-production point-in-time copy of a table before a risky migration The team proposes: Use a clone at an appropriate supported Time Travel point. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- The cloned table represents the expected prior state without overwriting production
- An unrelated compute counter improves with no correctness check
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: The cloned table represents the expected prior state without overwriting production. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
C:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
D:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
SnowPro Core COF-C03 Practice Tests