100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 390
A dashboard's filter combines high-selectivity predicates with expressions that inhibit pruning Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Query Profile shows fewer scanned partitions without changing result rows
- Expression-heavy predicates prevent useful pruning
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
Explanation
Correct Answer
B:Unresolved failure: Expression-heavy predicates prevent useful pruning. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Expression-heavy predicates prevent useful pruning.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Expression-heavy predicates prevent useful pruning.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Expression-heavy predicates prevent useful pruning.
Question 391
An application needs enforced primary-key uniqueness and low-latency individual-row updates Which technical action is most appropriate under this requirement?
- Create a standard table and trust an informational primary key to block duplicates
- Choose a result-cache setting as a row-lock mechanism
- Use a materialized view as the transaction-write target
- Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys
Explanation
Correct Answer
D:Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An application needs enforced primary-key uniqueness and low-latency individual-row updates. The appropriate decision: Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys.
B:The problem: An application needs enforced primary-key uniqueness and low-latency individual-row updates. The appropriate decision: Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys.
C:The problem: An application needs enforced primary-key uniqueness and low-latency individual-row updates. The appropriate decision: Evaluate a Snowflake hybrid table rather than assuming all standard tables enforce primary keys.
Question 392
A disaster-recovery team requires a secondary account with ready protected databases Which unresolved finding would be a valid reason to block acceptance after the change?
- Recovery assumptions ignore objects or dependencies outside replication scope
- The relevant users retain exactly their approved access
- The team confirms: A planned failover test validates data availability and the documented scope
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Recovery assumptions ignore objects or dependencies outside replication scope. 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: Recovery assumptions ignore objects or dependencies outside replication scope.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Recovery assumptions ignore objects or dependencies outside replication scope.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Recovery assumptions ignore objects or dependencies outside replication scope.
Question 393
Ownership of a production table needs to transfer to a different role during reorganization Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Rename the table to transfer its owner
- Just grant SELECT and call it a full ownership transfer
- Perform the supported OWNERSHIP transfer with a deliberate dependent-grant policy
- The new owner manages the table and existing grant behavior matches the approved transfer decision
- Switch warehouse size instead of object ownership
Explanation
Correct Answers
C:Perform the supported OWNERSHIP transfer with a deliberate dependent-grant policy. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: The new owner manages the table and existing grant behavior matches the approved transfer decision. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: Ownership of a production table needs to transfer to a different role during reorganization. The appropriate decision: Perform the supported OWNERSHIP transfer with a deliberate dependent-grant policy.
B:The problem: Ownership of a production table needs to transfer to a different role during reorganization. The appropriate decision: Perform the supported OWNERSHIP transfer with a deliberate dependent-grant policy.
E:The problem: Ownership of a production table needs to transfer to a different role during reorganization. The appropriate decision: Perform the supported OWNERSHIP transfer with a deliberate dependent-grant policy.
Question 394
A data science team wants Python DataFrame transformations executed close to Snowflake data Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- The team confirms: Transformations execute within Snowflake under the intended data-access context
- An uncontrolled client-side export bypasses governance and adds transfer overhead
Explanation
Correct Answer
D:Unresolved failure: An uncontrolled client-side export bypasses governance and adds transfer overhead. 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: An uncontrolled client-side export bypasses governance and adds transfer overhead.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: An uncontrolled client-side export bypasses governance and adds transfer overhead.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: An uncontrolled client-side export bypasses governance and adds transfer overhead.
Question 395
A finance report requires exact reproducibility of historical figures for an as-of date Which technical action is most appropriate under this requirement?
- Use the current result cache as a permanent audit store
- Rely solely on a warehouse's local memory
- Use Time Travel where retained or preserve immutable approved snapshots
- Overwrite the finance table before exporting prior state
Explanation
Correct Answer
C:Use Time Travel where retained or preserve immutable approved snapshots. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A finance report requires exact reproducibility of historical figures for an as-of date. The appropriate decision: Use Time Travel where retained or preserve immutable approved snapshots.
B:The problem: A finance report requires exact reproducibility of historical figures for an as-of date. The appropriate decision: Use Time Travel where retained or preserve immutable approved snapshots.
D:The problem: A finance report requires exact reproducibility of historical figures for an as-of date. The appropriate decision: Use Time Travel where retained or preserve immutable approved snapshots.
Question 396
A role sees a database object but its warehouse lacks enough compute to finish a heavy query The team proposes: Adjust the assigned warehouse performance while retaining the role's existing data privileges. Which test outcome is the strongest direct evidence that this change works?
- Query completes with acceptable spill and the role retains least-privilege access
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
A:Acceptance evidence: Query completes with acceptable spill and the role retains least-privilege access. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Query completes with acceptable spill and the role retains least-privilege access.
C:This observation is insufficient. The stronger validation is: Query completes with acceptable spill and the role retains least-privilege access.
D:This observation is insufficient. The stronger validation is: Query completes with acceptable spill and the role retains least-privilege access.
Question 397
An operator wants to remove stale SELECT access from a retired contractor role Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Revoke relevant grants and assignments while validating dependent role inheritance
- The retired role and its users no longer query the protected objects
- Block release while: Old memberships continue granting sensitive reads
- Delete the contractor's worksheet but leave grants
- Grant OWNERSHIP to PUBLIC for simpler cleanup
- Turn on query acceleration to revoke SELECT
Explanation
Correct Answers
A:Revoke relevant grants and assignments while validating dependent role inheritance. This addresses the stated condition without bypassing the required boundary.
B:Acceptance evidence: The retired role and its users no longer query the protected objects. Completing configuration alone is insufficient.
C:Unresolved failure: Old memberships continue granting sensitive reads. Correct and test it before acceptance.
Incorrect Answers
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.
E: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.
F: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 398
Sensitive columns must be classified and labeled consistently for governance reporting Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Security teams cannot identify where regulated fields are stored
- Change and rollback evidence is retained with the release
- The team confirms: The intended sensitive data is tagged and discoverable in governance reports
Explanation
Correct Answer
B:Unresolved failure: Security teams cannot identify where regulated fields are stored. 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: Security teams cannot identify where regulated fields are stored.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Security teams cannot identify where regulated fields are stored.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Security teams cannot identify where regulated fields are stored.
Question 399
New tables created in a reporting schema are inaccessible until manual grants are added every day Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- The future-grant rule is confused with retroactive access to existing objects
- The team confirms: A newly created eligible table receives the expected privileges
- The relevant users retain exactly their approved access
Explanation
Correct Answer
B:Unresolved failure: The future-grant rule is confused with retroactive access to existing objects. 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: The future-grant rule is confused with retroactive access to existing objects.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The future-grant rule is confused with retroactive access to existing objects.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The future-grant rule is confused with retroactive access to existing objects.
Question 400
A prospective data recipient does not have its own Snowflake account but must query controlled provider data 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
- A nonexistent consumer account is assumed to receive an ordinary direct share
- The team confirms: The recipient can access the approved shared objects under a tracked reader account
Explanation
Correct Answer
C:Unresolved failure: A nonexistent consumer account is assumed to receive an ordinary direct share. 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 nonexistent consumer account is assumed to receive an ordinary direct share.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A nonexistent consumer account is assumed to receive an ordinary direct share.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: A nonexistent consumer account is assumed to receive an ordinary direct share.
SnowPro Core COF-C03 Practice Tests