100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 140
A team wants several connectors to share a cloud API but avoid unreviewed external access Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Disable network rules to make every endpoint reachable
- Embed long-lived tokens in every SQL statement
- Grant every developer external access to all internet hosts
- Authorized requests succeed while unapproved destinations or credentials are blocked
- Use supported external access or API integrations with scoped network and secret rules
Explanation
Correct Answers
D:Acceptance evidence: Authorized requests succeed while unapproved destinations or credentials are blocked. Completing configuration alone is insufficient.
E:Use supported external access or API integrations with scoped network and secret rules. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A team wants several connectors to share a cloud API but avoid unreviewed external access. The appropriate decision: Use supported external access or API integrations with scoped network and secret rules.
B:The problem: A team wants several connectors to share a cloud API but avoid unreviewed external access. The appropriate decision: Use supported external access or API integrations with scoped network and secret rules.
C:The problem: A team wants several connectors to share a cloud API but avoid unreviewed external access. The appropriate decision: Use supported external access or API integrations with scoped network and secret rules.
Question 141
An architecture plan requires a dedicated isolated ETL execution cluster and independent analyst compute Which technical action is most appropriate under this requirement?
- Assign ETL and interactive work to separate warehouses with workload-specific sizing
- Rename the ETL role without changing compute assignment
- Add a clustering key to an unrelated small table
- Create a second database but keep one warehouse
Explanation
Correct Answer
A:Assign ETL and interactive work to separate warehouses with workload-specific sizing. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: An architecture plan requires a dedicated isolated ETL execution cluster and independent analyst compute. The appropriate decision: Assign ETL and interactive work to separate warehouses with workload-specific sizing.
C:The problem: An architecture plan requires a dedicated isolated ETL execution cluster and independent analyst compute. The appropriate decision: Assign ETL and interactive work to separate warehouses with workload-specific sizing.
D:The problem: An architecture plan requires a dedicated isolated ETL execution cluster and independent analyst compute. The appropriate decision: Assign ETL and interactive work to separate warehouses with workload-specific sizing.
Question 142
A Python program uses the Snowflake Connector but fails to connect using the approved identity The team proposes: Check connector configuration, authentication method, network access and targeted role. Which test outcome is the strongest direct evidence that this change works?
- The connector authenticates under the intended user and executes a scoped query
- The staged file appears in LIST but no destination row is validated
- One connector starts but no expected event arrives
- A job status is green without comparing source and target record counts
Explanation
Correct Answer
A:Acceptance evidence: The connector authenticates under the intended user and executes a scoped query. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The connector authenticates under the intended user and executes a scoped query.
C:This observation is insufficient. The stronger validation is: The connector authenticates under the intended user and executes a scoped query.
D:This observation is insufficient. The stronger validation is: The connector authenticates under the intended user and executes a scoped query.
Question 143
A data mart must calculate a rolling seven-day metric per store Which technical action is most appropriate under this requirement?
- Apply LIMIT 7 before computing each window
- Assume ROWS frames automatically fill missing calendar dates
- Use a window frame with suitable date ordering and partition boundaries
- Use an unpartitioned entire-table rolling sum
Explanation
Correct Answer
C:Use a window frame with suitable date ordering and partition boundaries. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A data mart must calculate a rolling seven-day metric per store. The appropriate decision: Use a window frame with suitable date ordering and partition boundaries.
B:The problem: A data mart must calculate a rolling seven-day metric per store. The appropriate decision: Use a window frame with suitable date ordering and partition boundaries.
D:The problem: A data mart must calculate a rolling seven-day metric per store. The appropriate decision: Use a window frame with suitable date ordering and partition boundaries.
Question 144
A support application performs selective equality lookups on a massive log table Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Selective lookup latency improves with acceptable maintenance costs
- Block release while: The table is repeatedly scanned for tiny point subsets
- Set an unrelated row access policy as an index
- Evaluate the search optimization service for the eligible predicate and economics
- Make every query use LIKE '%' regardless of selectivity
- Use Query Acceleration for every key lookup without comparing eligibility
Explanation
Correct Answers
A:Acceptance evidence: Selective lookup latency improves with acceptable maintenance costs. Completing configuration alone is insufficient.
B:Unresolved failure: The table is repeatedly scanned for tiny point subsets. Correct and test it before acceptance.
D:Evaluate the search optimization service for the eligible predicate and economics. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
C:The problem: A support application performs selective equality lookups on a massive log table. The appropriate decision: Evaluate the search optimization service for the eligible predicate and economics.
E:The problem: A support application performs selective equality lookups on a massive log table. The appropriate decision: Evaluate the search optimization service for the eligible predicate and economics.
F:The problem: A support application performs selective equality lookups on a massive log table. The appropriate decision: Evaluate the search optimization service for the eligible predicate and economics.
Question 145
An ingestion-driven table refresh triggers costly queries that scan all historical data repeatedly The team proposes: Compare an incremental design such as streams/tasks or dynamic tables against full recomputation. Which test outcome is the strongest direct evidence that this change works?
- The refreshed model reaches its required latency with lower scanned data volume
- The query finishes but returns a different business total
- 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
Explanation
Correct Answer
A:Acceptance evidence: The refreshed model reaches its required latency with lower scanned data volume. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The refreshed model reaches its required latency with lower scanned data volume.
C:This observation is insufficient. The stronger validation is: The refreshed model reaches its required latency with lower scanned data volume.
D:This observation is insufficient. The stronger validation is: The refreshed model reaches its required latency with lower scanned data volume.
Question 146
A data platform needs ordered parent and child transformation steps with failure visibility Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Child tasks run after successful prerequisites in the documented graph
- The relevant users retain exactly their approved access
- Downstream calculations run before their required source tables are updated
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: Downstream calculations run before their required source tables are updated. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Downstream calculations run before their required source tables are updated.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Downstream calculations run before their required source tables are updated.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Downstream calculations run before their required source tables are updated.
Question 147
A support team wants to recover from accidental schema deletion without recreating every object manually Which technical action is most appropriate under this requirement?
- Review supported Time Travel and UNDROP recovery options at the affected object scope
- Create empty tables and claim backup completion
- Use a new network policy to restore SQL objects
- Resize the warehouse to recover removed metadata
Explanation
Correct Answer
A:Review supported Time Travel and UNDROP recovery options at the affected object scope. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A support team wants to recover from accidental schema deletion without recreating every object manually. The appropriate decision: Review supported Time Travel and UNDROP recovery options at the affected object scope.
C:The problem: A support team wants to recover from accidental schema deletion without recreating every object manually. The appropriate decision: Review supported Time Travel and UNDROP recovery options at the affected object scope.
D:The problem: A support team wants to recover from accidental schema deletion without recreating every object manually. The appropriate decision: Review supported Time Travel and UNDROP recovery options at the affected object scope.
Question 148
Python developers plan to execute an unsupported external package inside a Snowpark UDF Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- The deployment assumes arbitrary untrusted packages work without constraints
- The team confirms: The UDF or procedure runs successfully in a supported environment
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: The deployment assumes arbitrary untrusted packages work without constraints. 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: The deployment assumes arbitrary untrusted packages work without constraints.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: The deployment assumes arbitrary untrusted packages work without constraints.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The deployment assumes arbitrary untrusted packages work without constraints.
Question 149
A Snowpipe auto-ingest job is not loading newly uploaded files Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- Missed notifications leave an unobserved ingestion backlog
- The team confirms: Expected notifications and ingestion events produce the required target rows
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: Missed notifications leave an unobserved ingestion backlog. 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: Missed notifications leave an unobserved ingestion backlog.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Missed notifications leave an unobserved ingestion backlog.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Missed notifications leave an unobserved ingestion backlog.
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.
SnowPro Core COF-C03 Practice Tests