100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 420
An application needs narrowly scoped privileges inside one database without account-wide administrative power Which unresolved finding would be a valid reason to block acceptance after the change?
- The database privilege scope expands unnecessarily across the whole account
- Change and rollback evidence is retained with the release
- The team confirms: The application gains scoped object access without broad account-level privileges
- The relevant users retain exactly their approved access
Explanation
Correct Answer
A:Unresolved failure: The database privilege scope expands unnecessarily across the whole account. 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: The database privilege scope expands unnecessarily across the whole account.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The database privilege scope expands unnecessarily across the whole account.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The database privilege scope expands unnecessarily across the whole account.
Question 421
An analyst's query results changed after source DML even though its SQL text stayed constant Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: The query reflects current committed data rather than an obsolete cached answer
- The relevant users retain exactly their approved access
- A stale result is incorrectly trusted after source changes
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: A stale result is incorrectly trusted after source changes. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: A stale result is incorrectly trusted after source changes.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A stale result is incorrectly trusted after source changes.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A stale result is incorrectly trusted after source changes.
Question 422
A network allowlist was changed and on-call users unexpectedly lose authorized access Which technical action is most appropriate under this requirement?
- Replace MFA with a table masking policy
- Change a warehouse name to restore connectivity
- Validate policy precedence and the effective network rule before and after the change
- Allow all IPv4 addresses without review
Explanation
Correct Answer
C:Validate policy precedence and the effective network rule before and after the change. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A network allowlist was changed and on-call users unexpectedly lose authorized access. The appropriate decision: Validate policy precedence and the effective network rule before and after the change.
B:The problem: A network allowlist was changed and on-call users unexpectedly lose authorized access. The appropriate decision: Validate policy precedence and the effective network rule before and after the change.
D:The problem: A network allowlist was changed and on-call users unexpectedly lose authorized access. The appropriate decision: Validate policy precedence and the effective network rule before and after the change.
Question 423
An analyst builds a small interactive dashboard inside the data platform Which technical action is most appropriate under this requirement?
- Use a supported Streamlit in Snowflake application with scoped data permissions
- Publish credentials in the app source
- Grant ACCOUNTADMIN to every app user
- Replace the UI with a warehouse-only schedule
Explanation
Correct Answer
A:Use a supported Streamlit in Snowflake application with scoped data permissions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: An analyst builds a small interactive dashboard inside the data platform. The appropriate decision: Use a supported Streamlit in Snowflake application with scoped data permissions.
C:The problem: An analyst builds a small interactive dashboard inside the data platform. The appropriate decision: Use a supported Streamlit in Snowflake application with scoped data permissions.
D:The problem: An analyst builds a small interactive dashboard inside the data platform. The appropriate decision: Use a supported Streamlit in Snowflake application with scoped data permissions.
Question 424
A materialized view speeds up a dashboard but creates unexpected background maintenance charges Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Expensive refresh outweighs saved query compute
- Change and rollback evidence is retained with the release
- The team confirms: The net cost and latency satisfy the approved workload requirement
Explanation
Correct Answer
B:Unresolved failure: Expensive refresh outweighs saved query 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: Expensive refresh outweighs saved query compute.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Expensive refresh outweighs saved query compute.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Expensive refresh outweighs saved query compute.
Question 425
An IoT time-series table receives continuous inserts and date range queries slow as partition overlap rises Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Clustering quality and critical date-range scan latency improve
- Evaluate a measured clustering key on the dominant date predicate
- Set a resource monitor as a clustering key
- Use only a larger warehouse while ignoring overlap metrics
- Grant SELECT to a new role to reduce partition overlap
Explanation
Correct Answers
A:Acceptance evidence: Clustering quality and critical date-range scan latency improve. Completing configuration alone is insufficient.
B:Evaluate a measured clustering key on the dominant date predicate. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
C:The problem: An IoT time-series table receives continuous inserts and date range queries slow as partition overlap rises. The appropriate decision: Evaluate a measured clustering key on the dominant date predicate.
D:The problem: An IoT time-series table receives continuous inserts and date range queries slow as partition overlap rises. The appropriate decision: Evaluate a measured clustering key on the dominant date predicate.
E:The problem: An IoT time-series table receives continuous inserts and date range queries slow as partition overlap rises. The appropriate decision: Evaluate a measured clustering key on the dominant date predicate.
Question 426
A platform team wants to estimate whether it needs three virtual warehouses or three databases for three compute workloads over one dataset The team proposes: Separate virtual warehouses for independent compute while using one governed storage hierarchy when appropriate. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
- Three workloads have isolated compute and one authoritative dataset
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
C:Acceptance evidence: Three workloads have isolated compute and one authoritative dataset. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Three workloads have isolated compute and one authoritative dataset.
B:This observation is insufficient. The stronger validation is: Three workloads have isolated compute and one authoritative dataset.
D:This observation is insufficient. The stronger validation is: Three workloads have isolated compute and one authoritative dataset.
Question 427
A data team wants a reusable governed location for multiple ingestion workflows Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: Unmanaged per-user file locations undermine repeatable ingestion
- Authorized ingestion jobs can access the approved staged files
- Create a named internal stage with appropriate file format and privileges
- Use a warehouse name as a storage path
- Rely on an individual developer's session-only stage for enterprise loads
- Assign table SELECT as the only stage access permission
Explanation
Correct Answers
A:Unresolved failure: Unmanaged per-user file locations undermine repeatable ingestion. Correct and test it before acceptance.
B:Acceptance evidence: Authorized ingestion jobs can access the approved staged files. Completing configuration alone is insufficient.
C:Create a named internal stage with appropriate file format and privileges. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
D:The problem: A data team wants a reusable governed location for multiple ingestion workflows. The appropriate decision: Create a named internal stage with appropriate file format and privileges.
E:The problem: A data team wants a reusable governed location for multiple ingestion workflows. The appropriate decision: Create a named internal stage with appropriate file format and privileges.
F:The problem: A data team wants a reusable governed location for multiple ingestion workflows. The appropriate decision: Create a named internal stage with appropriate file format and privileges.
Question 428
A company wants employees to authenticate through its corporate identity provider Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Share one Snowflake password across all employees
- Block release while: Authentication bypasses enterprise offboarding and identity policies
- Corporate sign-in works and user account privileges remain governed in Snowflake
- Disable role grants because SSO replaces authorization
- Configure supported federated single sign-on with appropriate identity mapping
- Use a database clone as an identity provider
Explanation
Correct Answers
B:Unresolved failure: Authentication bypasses enterprise offboarding and identity policies. Correct and test it before acceptance.
C:Acceptance evidence: Corporate sign-in works and user account privileges remain governed in Snowflake. Completing configuration alone is insufficient.
E:Configure supported federated single sign-on with appropriate identity mapping. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A company wants employees to authenticate through its corporate identity provider. The appropriate decision: Configure supported federated single sign-on with appropriate identity mapping.
D:The problem: A company wants employees to authenticate through its corporate identity provider. The appropriate decision: Configure supported federated single sign-on with appropriate identity mapping.
F:The problem: A company wants employees to authenticate through its corporate identity provider. The appropriate decision: Configure supported federated single sign-on with appropriate identity mapping.
Question 429
A consumer account queries provider-owned shared tables but is uncertain where query compute is billed Which proposal best pairs a technically correct change with the outcome that would validate it?
- Explain and validate that the consumer uses its own virtual warehouse for shared-data queries; verify The consumer's query credits are attributable to its chosen warehouse
- Assume shared tables copy into the consumer's warehouse storage; no direct validation of The consumer's query credits are attributable to its chosen warehouse
- Use a reader role as proof the provider pays for all queries; no direct validation of The consumer's query credits are attributable to its chosen warehouse
- Require the provider to resize a warehouse for every consumer query; no direct validation of The consumer's query credits are attributable to its chosen warehouse
Explanation
Correct Answer
A:Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. Verify: The consumer's query credits are attributable to its chosen warehouse.
Incorrect Answers
B:Required correction: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. Evidence: The consumer's query credits are attributable to its chosen warehouse.
C:Required correction: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. Evidence: The consumer's query credits are attributable to its chosen warehouse.
D:Required correction: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. Evidence: The consumer's query credits are attributable to its chosen warehouse.
Question 430
A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join Which technical action is most appropriate under this requirement?
- Increase warehouse size without investigating the join
- Add more DISTINCT operations as a universal tuning fix
- Remove the redundant join or adjust grain after inspecting intermediate cardinalities
- Change user login policies to reduce join rows
Explanation
Correct Answer
C:Remove the redundant join or adjust grain after inspecting intermediate cardinalities. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
B:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
D:The problem: A large batch report has poor performance after adding a high-cardinality DISTINCT to an unnecessary join. The appropriate decision: Remove the redundant join or adjust grain after inspecting intermediate cardinalities.
SnowPro Core COF-C03 Practice Tests