100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 81
A monthly finance report needs the top three transactions per customer group Which technical action is most appropriate under this requirement?
- Group all transactions and discard row-level rank
- Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering
- Use LIMIT 3 on the entire table
- Partition by a constant and assume customer boundaries exist
Explanation
Correct Answer
B:Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A monthly finance report needs the top three transactions per customer group. The appropriate decision: Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering.
C:The problem: A monthly finance report needs the top three transactions per customer group. The appropriate decision: Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering.
D:The problem: A monthly finance report needs the top three transactions per customer group. The appropriate decision: Use ROW_NUMBER or a suitable ranking window function with PARTITION BY and ordering.
Question 82
A project needs to distinguish cloud services credits from user warehouse credits in its cost report Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Track only local laptop CPU utilization
- Block release while: A cost report incorrectly labels all credit usage as warehouse compute
- Use table row counts as the sole cost metric
- Consumption categories reconcile to the account's reported usage within documented rules
- Infer platform costs only from the number of Snowflake roles
- Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories
Explanation
Correct Answers
B:Unresolved failure: A cost report incorrectly labels all credit usage as warehouse compute. Correct and test it before acceptance.
D:Acceptance evidence: Consumption categories reconcile to the account's reported usage within documented rules. Completing configuration alone is insufficient.
F:Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A project needs to distinguish cloud services credits from user warehouse credits in its cost report. The appropriate decision: Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories.
C:The problem: A project needs to distinguish cloud services credits from user warehouse credits in its cost report. The appropriate decision: Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories.
E:The problem: A project needs to distinguish cloud services credits from user warehouse credits in its cost report. The appropriate decision: Attribute service and warehouse charges using the relevant Snowflake usage views and billing categories.
Question 83
New tables created in a reporting schema are inaccessible until manual grants are added every day The team proposes: Configure appropriate future grants for the intended object type and role. Which test outcome is the strongest direct evidence that this change works?
- The policy is listed in metadata but denied accesses are never tested
- An administrator can run the query but a standard role remains unauthorized
- A role name looks correct while the effective grants remain unchecked
- A newly created eligible table receives the expected privileges
Explanation
Correct Answer
D:Acceptance evidence: A newly created eligible table receives the expected privileges. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: A newly created eligible table receives the expected privileges.
B:This observation is insufficient. The stronger validation is: A newly created eligible table receives the expected privileges.
C:This observation is insufficient. The stronger validation is: A newly created eligible table receives the expected privileges.
Question 84
A table shows heavy reclustering credit consumption despite only a few unselective reports Which technical action is most appropriate under this requirement?
- Remove or revise clustering keys that do not justify maintenance cost
- Apply clustering keys to every small lookup table
- Double retention to improve pruning
- Reduce all roles to PUBLIC as a cost control
Explanation
Correct Answer
A:Remove or revise clustering keys that do not justify maintenance cost. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
C:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
D:The problem: A table shows heavy reclustering credit consumption despite only a few unselective reports. The appropriate decision: Remove or revise clustering keys that do not justify maintenance cost.
Question 85
A consumer requests counts of distinct active customers by month and region Which proposal best pairs a technically correct change with the outcome that would validate it?
- Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...); verify The result has one row per requested grain with nonduplicated customer counts
- Count all events without distinct customer handling; no direct validation of The result has one row per requested grain with nonduplicated customer counts
- Use LIMIT to determine monthly distinct totals; no direct validation of The result has one row per requested grain with nonduplicated customer counts
- Group only by country and ignore requested region; no direct validation of The result has one row per requested grain with nonduplicated customer counts
Explanation
Correct Answer
A:Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). Verify: The result has one row per requested grain with nonduplicated customer counts.
Incorrect Answers
B:Required correction: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). Evidence: The result has one row per requested grain with nonduplicated customer counts.
C:Required correction: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). Evidence: The result has one row per requested grain with nonduplicated customer counts.
D:Required correction: Use an aggregate GROUP BY on the correct month and region expressions with COUNT(DISTINCT ...). Evidence: The result has one row per requested grain with nonduplicated customer counts.
Question 86
An application requires high-frequency ingest of changing entities and strong transactional semantics 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 chosen table type meets tested insert/update and lookup behavior
- An analytic-table design is used without validating transactional latency
Explanation
Correct Answer
D:Unresolved failure: An analytic-table design is used without validating transactional latency. 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: An analytic-table design is used without validating transactional latency.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: An analytic-table design is used without validating transactional latency.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: An analytic-table design is used without validating transactional latency.
Question 87
A business user wants generated summaries of customer-support text stored inside Snowflake Which unresolved finding would be a valid reason to block acceptance after the change?
- Text is sent to an unapproved external LLM without data governance
- The relevant users retain exactly their approved access
- The team confirms: Outputs satisfy a sampled quality check and credit consumption is observable
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Text is sent to an unapproved external LLM without data governance. 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: Text is sent to an unapproved external LLM without data governance.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Text is sent to an unapproved external LLM without data governance.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Text is sent to an unapproved external LLM without data governance.
Question 88
A development warehouse sits idle for hours after short interactive queries Which technical action is most appropriate under this requirement?
- Create another always-on warehouse
- Configure a sensible AUTO_SUSPEND interval on the warehouse
- Set STATEMENT_TIMEOUT_IN_SECONDS as the idle timer
- Drop the users' tables between sessions
Explanation
Correct Answer
B:Configure a sensible AUTO_SUSPEND interval on the warehouse. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A development warehouse sits idle for hours after short interactive queries. The appropriate decision: Configure a sensible AUTO_SUSPEND interval on the warehouse.
C:The problem: A development warehouse sits idle for hours after short interactive queries. The appropriate decision: Configure a sensible AUTO_SUSPEND interval on the warehouse.
D:The problem: A development warehouse sits idle for hours after short interactive queries. The appropriate decision: Configure a sensible AUTO_SUSPEND interval on the warehouse.
Question 89
A governance team assumes Fail-safe is an ordinary end-user time-machine for SQL restores Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Recovery responsibilities and retention expectations are documented separately
- The operations runbook promises unsupported direct SQL access to Fail-safe
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: The operations runbook promises unsupported direct SQL access to Fail-safe. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: The operations runbook promises unsupported direct SQL access to Fail-safe.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The operations runbook promises unsupported direct SQL access to Fail-safe.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The operations runbook promises unsupported direct SQL access to Fail-safe.
Question 90
A transformation job must capture incremental INSERT/UPDATE/DELETE changes from a landing table Which unresolved finding would be a valid reason to block acceptance after the change?
- Data changes are inferred only from current row counts
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- The team confirms: The downstream job processes the intended change rows without a full table rescan
Explanation
Correct Answer
A:Unresolved failure: Data changes are inferred only from current row counts. 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: Data changes are inferred only from current row counts.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Data changes are inferred only from current row counts.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Data changes are inferred only from current row counts.
SnowPro Core COF-C03 Practice Tests