100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 70
A data product contract promises stable column names but the provider wants to rename source fields 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: Consumer queries continue to resolve the documented schema during approved changes
- Breaking source schema changes cause downstream consumer failures
Explanation
Correct Answer
D:Unresolved failure: Breaking source schema changes cause downstream consumer failures. 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: Breaking source schema changes cause downstream consumer failures.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Breaking source schema changes cause downstream consumer failures.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Breaking source schema changes cause downstream consumer failures.
Question 71
A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join 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 correct aggregate result is produced with fewer processed rows
- Compute and cost are wasted masking incorrect join multiplicity
Explanation
Correct Answer
D:Unresolved failure: Compute and cost are wasted masking incorrect join multiplicity. 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: Compute and cost are wasted masking incorrect join multiplicity.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Compute and cost are wasted masking incorrect join multiplicity.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Compute and cost are wasted masking incorrect join multiplicity.
Question 72
A marketplace data product includes contractual usage constraints and must restrict who can see sensitive fields 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: Authorized consumers see the intended schema and restricted fields stay protected
- The relevant users retain exactly their approved access
- Marketing listing visibility is mistaken for unrestricted base table visibility
Explanation
Correct Answer
D:Unresolved failure: Marketing listing visibility is mistaken for unrestricted base table visibility. 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: Marketing listing visibility is mistaken for unrestricted base table visibility.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Marketing listing visibility is mistaken for unrestricted base table visibility.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Marketing listing visibility is mistaken for unrestricted base table visibility.
Question 73
A cost team cannot identify which warehouses consumed last week's credits Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Assume suspended warehouses accrue the same active compute minutes
- Count database names as a proxy for credits
- Use a masking policy to lower compute charges
- Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views
- Credit usage is attributable to the expected warehouses and time periods
- Block release while: Costs are allocated by arbitrary table count instead of observed warehouse activity
Explanation
Correct Answers
D:Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: Credit usage is attributable to the expected warehouses and time periods. Completing configuration alone is insufficient.
F:Unresolved failure: Costs are allocated by arbitrary table count instead of observed warehouse activity. Correct and test it before acceptance.
Incorrect Answers
A:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
B:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
C:The problem: A cost team cannot identify which warehouses consumed last week's credits. The appropriate decision: Use the appropriate Snowflake ACCOUNT_USAGE warehouse-metering or query-history views.
Question 74
A source feed includes malformed numeric strings but valid values must still be loaded Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Valid numbers convert while malformed strings are handled without aborting all rows
- Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling
- Increase auto-suspend to alter input types
- Use an unsafe unconditional CAST without validation
- Rename the source column without fixing malformed values
Explanation
Correct Answers
A:Acceptance evidence: Valid numbers convert while malformed strings are handled without aborting all rows. Completing configuration alone is insufficient.
B:Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
C:The problem: A source feed includes malformed numeric strings but valid values must still be loaded. The appropriate decision: Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling.
D:The problem: A source feed includes malformed numeric strings but valid values must still be loaded. The appropriate decision: Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling.
E:The problem: A source feed includes malformed numeric strings but valid values must still be loaded. The appropriate decision: Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling.
Question 75
A task should run only when a source stream actually has pending changes Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: Idle runs waste work or the task ignores pending source records
- Schedule an unconditional heavy full-table scan every second
- Use a task WHEN condition with the supported stream-has-data predicate
- Set a network policy to check stream offsets
- Use a materialized view name as a predicate
- Run history shows the transformation is triggered when eligible changes exist
Explanation
Correct Answers
A:Unresolved failure: Idle runs waste work or the task ignores pending source records. Correct and test it before acceptance.
C:Use a task WHEN condition with the supported stream-has-data predicate. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: Run history shows the transformation is triggered when eligible changes exist. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
D:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
E:The problem: A task should run only when a source stream actually has pending changes. The appropriate decision: Use a task WHEN condition with the supported stream-has-data predicate.
Question 76
A low-volume transactional workload requires referential integrity enforcement, not just a documented schema Which technical action is most appropriate under this requirement?
- Put all transactions into a single CSV file without constraints
- Use Query Profile as a write-time integrity rule
- Assume every standard table foreign key is enforced
- Assess hybrid-table constraints and supported workload requirements
Explanation
Correct Answer
D:Assess hybrid-table constraints and supported workload requirements. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A low-volume transactional workload requires referential integrity enforcement, not just a documented schema. The appropriate decision: Assess hybrid-table constraints and supported workload requirements.
B:The problem: A low-volume transactional workload requires referential integrity enforcement, not just a documented schema. The appropriate decision: Assess hybrid-table constraints and supported workload requirements.
C:The problem: A low-volume transactional workload requires referential integrity enforcement, not just a documented schema. The appropriate decision: Assess hybrid-table constraints and supported workload requirements.
Question 77
An ingestion job repeats yesterday's COPY against the same files and risks duplicating data Which unresolved finding would be a valid reason to block acceptance after the change?
- A forced re-load duplicates previously ingested records
- Change and rollback evidence is retained with the release
- The relevant users retain exactly their approved access
- The team confirms: Previously loaded files are handled according to the intended duplicate-prevention policy
Explanation
Correct Answer
A:Unresolved failure: A forced re-load duplicates previously ingested records. Correct and test it before acceptance.
Incorrect Answers
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A forced re-load duplicates previously ingested records.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A forced re-load duplicates previously ingested records.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: A forced re-load duplicates previously ingested records.
Question 78
A batch team wants to save credits during variable concurrency and can tolerate some queueing The team proposes: Evaluate the ECONOMY scaling policy for a multi-cluster warehouse. Which test outcome is the strongest direct evidence that this change works?
- Cluster utilization improves with documented acceptable queue latency
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
A:Acceptance evidence: Cluster utilization improves with documented acceptable queue latency. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Cluster utilization improves with documented acceptable queue latency.
C:This observation is insufficient. The stronger validation is: Cluster utilization improves with documented acceptable queue latency.
D:This observation is insufficient. The stronger validation is: Cluster utilization improves with documented acceptable queue latency.
Question 79
An audit requires identifying which roles actually queried regulated data over a period Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Delete query history before compiling the audit
- Audit evidence identifies access events and objects at supported granularity
- Use table clustering as an access event log
- Treat a successful sign-in as proof of SELECT activity
- Use supported access history and relevant audit views with authorized privileges
Explanation
Correct Answers
B:Acceptance evidence: Audit evidence identifies access events and objects at supported granularity. Completing configuration alone is insufficient.
E:Use supported access history and relevant audit views with authorized privileges. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
C:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
D:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
Question 80
A partner already has a Snowflake account and needs read-only access to selected live provider data Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Make every provider table writable by the consumer
- Give the partner an account administrator password
- Block release while: The partner receives broader source-object access than the contract allows
- Use Secure Data Sharing with the intended share privileges and consumer account
- Export the full database nightly as emailed CSV files
- The consumer queries approved shared objects without copying provider table data
Explanation
Correct Answers
C:Unresolved failure: The partner receives broader source-object access than the contract allows. Correct and test it before acceptance.
D:Use Secure Data Sharing with the intended share privileges and consumer account. This addresses the stated condition without bypassing the required boundary.
F:Acceptance evidence: The consumer queries approved shared objects without copying provider table data. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A partner already has a Snowflake account and needs read-only access to selected live provider data. The appropriate decision: Use Secure Data Sharing with the intended share privileges and consumer account.
B:The problem: A partner already has a Snowflake account and needs read-only access to selected live provider data. The appropriate decision: Use Secure Data Sharing with the intended share privileges and consumer account.
E:The problem: A partner already has a Snowflake account and needs read-only access to selected live provider data. The appropriate decision: Use Secure Data Sharing with the intended share privileges and consumer account.
SnowPro Core COF-C03 Practice Tests