100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 540
A company needs customer rows segregated so regional staff only view authorized territories Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Use a column masking policy to remove entire unauthorized rows
- Rely on spreadsheet filters on the client side
- Change the warehouse size instead of applying a row filter
- Apply a supported row access policy referencing authorized role or entitlement context
- Queries return only region-authorized rows for test identities
Explanation
Correct Answers
D:Apply a supported row access policy referencing authorized role or entitlement context. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: Queries return only region-authorized rows for test identities. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A company needs customer rows segregated so regional staff only view authorized territories. The appropriate decision: Apply a supported row access policy referencing authorized role or entitlement context.
B:The problem: A company needs customer rows segregated so regional staff only view authorized territories. The appropriate decision: Apply a supported row access policy referencing authorized role or entitlement context.
C:The problem: A company needs customer rows segregated so regional staff only view authorized territories. The appropriate decision: Apply a supported row access policy referencing authorized role or entitlement context.
Question 541
A role sees a database object but its warehouse lacks enough compute to finish a heavy query 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: Query completes with acceptable spill and the role retains least-privilege access
- A hardware bottleneck is addressed by broad grants unrelated to compute
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: A hardware bottleneck is addressed by broad grants unrelated to compute. 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: A hardware bottleneck is addressed by broad grants unrelated to compute.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: A hardware bottleneck is addressed by broad grants unrelated to compute.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A hardware bottleneck is addressed by broad grants unrelated to compute.
Question 542
A company wants to provide a data product privately to a small set of approved customers The team proposes: Create a private listing with explicit authorized audience and terms. Which test outcome is the strongest direct evidence that this change works?
- Only invited or approved customers can discover and access the listing
- Only internal-provider access is demonstrated instead of the intended consumer role
- The listing is visible while unauthorized access is not tested
- The provider sees a shared object but the recipient cannot query it
Explanation
Correct Answer
A:Acceptance evidence: Only invited or approved customers can discover and access the listing. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Only invited or approved customers can discover and access the listing.
C:This observation is insufficient. The stronger validation is: Only invited or approved customers can discover and access the listing.
D:This observation is insufficient. The stronger validation is: Only invited or approved customers can discover and access the listing.
Question 543
A governance audit finds all account administrators using one shared credential Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Administrative actions can be associated with specific authorized principals
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- Shared credentials prevent reliable accountability and revocation
Explanation
Correct Answer
D:Unresolved failure: Shared credentials prevent reliable accountability and revocation. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Shared credentials prevent reliable accountability and revocation.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Shared credentials prevent reliable accountability and revocation.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Shared credentials prevent reliable accountability and revocation.
Question 544
A project needs to distinguish cloud services credits from user warehouse credits in its cost report The team proposes: Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- Consumption categories reconcile to the account's reported usage within documented rules
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
B:Acceptance evidence: Consumption categories reconcile to the account's reported usage within documented rules. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Consumption categories reconcile to the account's reported usage within documented rules.
C:This observation is insufficient. The stronger validation is: Consumption categories reconcile to the account's reported usage within documented rules.
D:This observation is insufficient. The stronger validation is: Consumption categories reconcile to the account's reported usage within documented rules.
Question 545
Python developers plan to execute an unsupported external package inside a Snowpark UDF Which technical action is most appropriate under this requirement?
- Store Python dependencies in a data masking policy
- Disable all network policies to install the dependency
- Rename the Python function without testing imports
- Check supported package availability and package or environment constraints before deployment
Explanation
Correct Answer
D:Check supported package availability and package or environment constraints before deployment. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
B:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
C:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
Question 546
An approved partner application needs delegated Snowflake access without receiving the user's password The team proposes: Use an authorized OAuth integration and scoped access tokens. Which test outcome is the strongest direct evidence that this change works?
- An administrator can run the query but a standard role remains unauthorized
- The app receives constrained tokens and permitted Snowflake resources work
- The policy is listed in metadata but denied accesses are never tested
- A role name looks correct while the effective grants remain unchecked
Explanation
Correct Answer
B:Acceptance evidence: The app receives constrained tokens and permitted Snowflake resources work. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The app receives constrained tokens and permitted Snowflake resources work.
C:This observation is insufficient. The stronger validation is: The app receives constrained tokens and permitted Snowflake resources work.
D:This observation is insufficient. The stronger validation is: The app receives constrained tokens and permitted Snowflake resources work.
Question 547
A business report has a HAVING filter on aggregated revenue but analysts incorrectly place it in WHERE Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Change a table comment to implement a threshold
- Apply HAVING to the aggregate predicate after grouping
- Only groups meeting the revenue threshold remain
- Use WHERE SUM(revenue) > x in the same grouped SELECT
- Remove GROUP BY and call it a grouped report
Explanation
Correct Answers
B:Apply HAVING to the aggregate predicate after grouping. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Only groups meeting the revenue threshold remain. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A business report has a HAVING filter on aggregated revenue but analysts incorrectly place it in WHERE. The appropriate decision: Apply HAVING to the aggregate predicate after grouping.
D:The problem: A business report has a HAVING filter on aggregated revenue but analysts incorrectly place it in WHERE. The appropriate decision: Apply HAVING to the aggregate predicate after grouping.
E:The problem: A business report has a HAVING filter on aggregated revenue but analysts incorrectly place it in WHERE. The appropriate decision: Apply HAVING to the aggregate predicate after grouping.
Question 548
A team repeatedly queries stream contents without consuming them and expects the offset to advance Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: Changes are reprocessed because a simple SELECT was treated as consumption
- Run a SELECT COUNT(*) and assume it commits the stream offset
- Use an external stage purge to consume changes
- Consume the stream through an appropriate committed DML transaction
- Change the warehouse name to reset CDC state
- The stream's consumed change set advances following the committed operation
Explanation
Correct Answers
A:Unresolved failure: Changes are reprocessed because a simple SELECT was treated as consumption. Correct and test it before acceptance.
D:Consume the stream through an appropriate committed DML transaction. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: The stream's consumed change set advances following the committed operation. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A team repeatedly queries stream contents without consuming them and expects the offset to advance. The appropriate decision: Consume the stream through an appropriate committed DML transaction.
C:The problem: A team repeatedly queries stream contents without consuming them and expects the offset to advance. The appropriate decision: Consume the stream through an appropriate committed DML transaction.
E:The problem: A team repeatedly queries stream contents without consuming them and expects the offset to advance. The appropriate decision: Consume the stream through an appropriate committed DML transaction.
Question 549
A dashboard result is repeated without data changes but each run is slower than the first Which technical action is most appropriate under this requirement?
- Investigate persisted result reuse and changed query/session or underlying-data conditions
- Change every literal value each run while expecting identical-cache hits
- Disable result caching and claim it improves repeats
- Use Time Travel to force a result hit
Explanation
Correct Answer
A:Investigate persisted result reuse and changed query/session or underlying-data conditions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A dashboard result is repeated without data changes but each run is slower than the first. The appropriate decision: Investigate persisted result reuse and changed query/session or underlying-data conditions.
C:The problem: A dashboard result is repeated without data changes but each run is slower than the first. The appropriate decision: Investigate persisted result reuse and changed query/session or underlying-data conditions.
D:The problem: A dashboard result is repeated without data changes but each run is slower than the first. The appropriate decision: Investigate persisted result reuse and changed query/session or underlying-data conditions.
Question 550
A transient intermediate dataset does not require Fail-safe recovery like permanent production records Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Configure a network policy to shorten storage lifecycle
- Storage/retention behavior matches the approved reduced-protection requirement
- Convert warehouse cache into durable dataset storage
- Use a permanent table while claiming it has no Fail-safe
- Use a transient table for the supported short-lived workload
Explanation
Correct Answers
B:Acceptance evidence: Storage/retention behavior matches the approved reduced-protection requirement. Completing configuration alone is insufficient.
E:Use a transient table for the supported short-lived workload. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
C:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
D:The problem: A transient intermediate dataset does not require Fail-safe recovery like permanent production records. The appropriate decision: Use a transient table for the supported short-lived workload.
SnowPro Core COF-C03 Practice Tests