100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 150
A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate
- Run all queries from one warehouse but rename the sessions
- Three workloads have isolated compute and one authoritative dataset
- Create three full database clones just to isolate CPU
- Store one dataset as three unmanaged files
Explanation
Correct Answers
A:Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Three workloads have isolated compute and one authoritative dataset. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset. The appropriate decision: Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate.
D:The problem: A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset. The appropriate decision: Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate.
E:The problem: A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset. The appropriate decision: Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate.
Question 151
A query performs remote disk spill despite little concurrency on its warehouse Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Add more concurrent users to reduce memory use
- Set QUERY_TAG to an arbitrary value as a spill fix
- Block release while: The warehouse continues paging intermediate data to remote storage
- Change result format to hide spill
- Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring
- Remote-spill bytes fall on representative runs
Explanation
Correct Answers
C:Unresolved failure: The warehouse continues paging intermediate data to remote storage. Correct and test it before acceptance.
E:Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: Remote-spill bytes fall on representative runs. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A query performs remote disk spill despite little concurrency on its warehouse. The appropriate decision: Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring.
B:The problem: A query performs remote disk spill despite little concurrency on its warehouse. The appropriate decision: Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring.
D:The problem: A query performs remote disk spill despite little concurrency on its warehouse. The appropriate decision: Inspect Query Profile spill and test memory-appropriate warehouse sizing or query restructuring.
Question 152
A data model stores frequently updated operational entities but most traffic is analytical scanning Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Bulk scans are efficient under the selected storage and compute design
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- An inappropriate transactional table choice undermines analytic throughput
Explanation
Correct Answer
D:Unresolved failure: An inappropriate transactional table choice undermines analytic throughput. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: An inappropriate transactional table choice undermines analytic throughput.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: An inappropriate transactional table choice undermines analytic throughput.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: An inappropriate transactional table choice undermines analytic throughput.
Question 153
A source table updates every hour and a partner needs those changes without nightly CSV reconciliation The team proposes: Use direct Secure Data Sharing for the eligible provider dataset. Which test outcome is the strongest direct evidence that this change works?
- The consumer sees current committed provider data under the share without repeated file exports
- Only internal-provider access is demonstrated instead of the intended consumer role
- The provider sees a shared object but the recipient cannot query it
- The listing is visible while unauthorized access is not tested
Explanation
Correct Answer
A:Acceptance evidence: The consumer sees current committed provider data under the share without repeated file exports. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The consumer sees current committed provider data under the share without repeated file exports.
C:This observation is insufficient. The stronger validation is: The consumer sees current committed provider data under the share without repeated file exports.
D:This observation is insufficient. The stronger validation is: The consumer sees current committed provider data under the share without repeated file exports.
Question 154
A data share unexpectedly fails because a required object was never added to the share grant scope Which proposal best pairs a technically correct change with the outcome that would validate it?
- Change time travel retention to grant share visibility; no direct validation of The consumer can resolve and query the intended shared objects
- Create a new network policy instead of adding share grants; no direct validation of The consumer can resolve and query the intended shared objects
- Inspect and grant the appropriate supported database and object access to the share; verify The consumer can resolve and query the intended shared objects
- Grant only warehouse USAGE to the provider role; no direct validation of The consumer can resolve and query the intended shared objects
Explanation
Correct Answer
C:Inspect and grant the appropriate supported database and object access to the share. Verify: The consumer can resolve and query the intended shared objects.
Incorrect Answers
A:Required correction: Inspect and grant the appropriate supported database and object access to the share. Evidence: The consumer can resolve and query the intended shared objects.
B:Required correction: Inspect and grant the appropriate supported database and object access to the share. Evidence: The consumer can resolve and query the intended shared objects.
D:Required correction: Inspect and grant the appropriate supported database and object access to the share. Evidence: The consumer can resolve and query the intended shared objects.
Question 155
An analyst's query results changed after source DML even though its SQL text stayed constant The team proposes: Recognize that data modifications can invalidate cached result reuse. 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
- A single warm-cache run is cited without representative execution metrics
- The query reflects current committed data rather than an obsolete cached answer
- The query finishes but returns a different business total
Explanation
Correct Answer
C:Acceptance evidence: The query reflects current committed data rather than an obsolete cached answer. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The query reflects current committed data rather than an obsolete cached answer.
B:This observation is insufficient. The stronger validation is: The query reflects current committed data rather than an obsolete cached answer.
D:This observation is insufficient. The stronger validation is: The query reflects current committed data rather than an obsolete cached answer.
Question 156
A provider must remove a former partner's access after contract expiration 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: The former consumer loses access while other approved consumers retain it
- Expired partner access continues through overlooked grants
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: Expired partner access continues through overlooked grants. 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: Expired partner access continues through overlooked grants.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Expired partner access continues through overlooked grants.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Expired partner access continues through overlooked grants.
Question 157
A Python program uses the Snowflake Connector but fails to connect using the approved identity Which technical action is most appropriate under this requirement?
- Check connector configuration, authentication method, network access and targeted role
- Switch to an unprotected shared ACCOUNTADMIN password
- Disable MFA for all users as a connector fix
- Change table clustering to repair driver authentication
Explanation
Correct Answer
A:Check connector configuration, authentication method, network access and targeted role. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A Python program uses the Snowflake Connector but fails to connect using the approved identity. The appropriate decision: Check connector configuration, authentication method, network access and targeted role.
C:The problem: A Python program uses the Snowflake Connector but fails to connect using the approved identity. The appropriate decision: Check connector configuration, authentication method, network access and targeted role.
D:The problem: A Python program uses the Snowflake Connector but fails to connect using the approved identity. The appropriate decision: Check connector configuration, authentication method, network access and targeted role.
Question 158
A service produces JSON keys with inconsistent capitalization and queries unexpectedly return NULL Which unresolved finding would be a valid reason to block acceptance after the change?
- Change and rollback evidence is retained with the release
- Query logic silently discards case-sensitive JSON fields
- The team confirms: The expected VARIANT attributes resolve after correcting case and path references
- The relevant users retain exactly their approved access
Explanation
Correct Answer
B:Unresolved failure: Query logic silently discards case-sensitive JSON fields. 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: Query logic silently discards case-sensitive JSON fields.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Query logic silently discards case-sensitive JSON fields.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Query logic silently discards case-sensitive JSON fields.
Question 159
An analyst needs to run repeatable SQL-and-Python exploration with shared project artifacts The team proposes: Use Snowflake Notebooks with authorized roles and supported execution settings. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- The warehouse login succeeds but the required query fails
- A metadata row exists while no relevant data is tested
- The notebook runs its cells and reads only approved data under the project role
Explanation
Correct Answer
D:Acceptance evidence: The notebook runs its cells and reads only approved data under the project role. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The notebook runs its cells and reads only approved data under the project role.
B:This observation is insufficient. The stronger validation is: The notebook runs its cells and reads only approved data under the project role.
C:This observation is insufficient. The stronger validation is: The notebook runs its cells and reads only approved data under the project role.
Question 160
A business report has a HAVING filter on aggregated revenue but analysts incorrectly place it in WHERE The team proposes: Apply HAVING to the aggregate predicate after grouping. 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
- A single warm-cache run is cited without representative execution metrics
- Only groups meeting the revenue threshold remain
- The query finishes but returns a different business total
Explanation
Correct Answer
C:Acceptance evidence: Only groups meeting the revenue threshold remain. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Only groups meeting the revenue threshold remain.
B:This observation is insufficient. The stronger validation is: Only groups meeting the revenue threshold remain.
D:This observation is insufficient. The stronger validation is: Only groups meeting the revenue threshold remain.
SnowPro Core COF-C03 Practice Tests