100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 590
Two independent analyst teams experience CPU contention because they share one active warehouse Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Disable query history
- Make a second database but keep the same warehouse
- The same SQL jobs run concurrently without stealing warehouse compute from one another
- Assign each workload its own appropriately sized virtual warehouse
- Increase retention on a shared table
- Block release while: A shared compute bottleneck continues to affect both teams
Explanation
Correct Answers
C:Acceptance evidence: The same SQL jobs run concurrently without stealing warehouse compute from one another. Completing configuration alone is insufficient.
D:Assign each workload its own appropriately sized virtual warehouse. This addresses the stated condition without bypassing the required boundary.
F:Unresolved failure: A shared compute bottleneck continues to affect both teams. Correct and test it before acceptance.
Incorrect Answers
A:The problem: Two independent analyst teams experience CPU contention because they share one active warehouse. The appropriate decision: Assign each workload its own appropriately sized virtual warehouse.
B:The problem: Two independent analyst teams experience CPU contention because they share one active warehouse. The appropriate decision: Assign each workload its own appropriately sized virtual warehouse.
E:The problem: Two independent analyst teams experience CPU contention because they share one active warehouse. The appropriate decision: Assign each workload its own appropriately sized virtual warehouse.
Question 591
An ingestion-driven table refresh triggers costly queries that scan all historical data repeatedly Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- A full-history recompute needlessly dominates compute spend
- The team confirms: The refreshed model reaches its required latency with lower scanned data volume
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
B:Unresolved failure: A full-history recompute needlessly dominates compute spend. 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: A full-history recompute needlessly dominates compute spend.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: A full-history recompute needlessly dominates compute spend.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A full-history recompute needlessly dominates compute spend.
Question 592
A team wants a central owner to control grants within a shared regulated schema The team proposes: Evaluate managed access schema governance with an authorized grant manager. Which test outcome is the strongest direct evidence that this change works?
- A role name looks correct while the effective grants remain unchecked
- Only authorized grant managers change object permissions under the managed-access model
- An administrator can run the query but a standard role remains unauthorized
- The policy is listed in metadata but denied accesses are never tested
Explanation
Correct Answer
B:Acceptance evidence: Only authorized grant managers change object permissions under the managed-access model. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Only authorized grant managers change object permissions under the managed-access model.
C:This observation is insufficient. The stronger validation is: Only authorized grant managers change object permissions under the managed-access model.
D:This observation is insufficient. The stronger validation is: Only authorized grant managers change object permissions under the managed-access model.
Question 593
A SQL filter needs rows where a field is unknown rather than equal to the string 'NULL' Which proposal best pairs a technically correct change with the outcome that would validate it?
- Filter on the literal text 'NULL' without checking types; no direct validation of The result includes actual NULL values and excludes the literal text where appropriate
- Use a larger warehouse to change NULL semantics; no direct validation of The result includes actual NULL values and excludes the literal text where appropriate
- Use = NULL and expect ordinary equality behavior; no direct validation of The result includes actual NULL values and excludes the literal text where appropriate
- Use IS NULL or IS NOT NULL with the intended SQL three-valued logic; verify The result includes actual NULL values and excludes the literal text where appropriate
Explanation
Correct Answer
D:Use IS NULL or IS NOT NULL with the intended SQL three-valued logic. Verify: The result includes actual NULL values and excludes the literal text where appropriate.
Incorrect Answers
A:Required correction: Use IS NULL or IS NOT NULL with the intended SQL three-valued logic. Evidence: The result includes actual NULL values and excludes the literal text where appropriate.
B:Required correction: Use IS NULL or IS NOT NULL with the intended SQL three-valued logic. Evidence: The result includes actual NULL values and excludes the literal text where appropriate.
C:Required correction: Use IS NULL or IS NOT NULL with the intended SQL three-valued logic. Evidence: The result includes actual NULL values and excludes the literal text where appropriate.
Question 594
A company wants to provide a data product privately to a small set of approved customers Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Create a private listing with explicit authorized audience and terms
- Rely on warehouse size to restrict listing visibility
- Share source credentials by email
- Publish the listing publicly without approval
- Only invited or approved customers can discover and access the listing
Explanation
Correct Answers
A:Create a private listing with explicit authorized audience and terms. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: Only invited or approved customers can discover and access the listing. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A company wants to provide a data product privately to a small set of approved customers. The appropriate decision: Create a private listing with explicit authorized audience and terms.
C:The problem: A company wants to provide a data product privately to a small set of approved customers. The appropriate decision: Create a private listing with explicit authorized audience and terms.
D:The problem: A company wants to provide a data product privately to a small set of approved customers. The appropriate decision: Create a private listing with explicit authorized audience and terms.
Question 595
A data share unexpectedly fails because a required object was never added to the share grant scope The team proposes: Inspect and grant the appropriate supported database and object access to the share. Which test outcome is the strongest direct evidence that this change works?
- The listing is visible while unauthorized access is not tested
- The provider sees a shared object but the recipient cannot query it
- The consumer can resolve and query the intended shared objects
- Only internal-provider access is demonstrated instead of the intended consumer role
Explanation
Correct Answer
C:Acceptance evidence: The consumer can resolve and query the intended shared objects. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The consumer can resolve and query the intended shared objects.
B:This observation is insufficient. The stronger validation is: The consumer can resolve and query the intended shared objects.
D:This observation is insufficient. The stronger validation is: The consumer can resolve and query the intended shared objects.
Question 596
A data pipeline materializes expensive repeated transformations in each downstream report The team proposes: Evaluate precomputed derived tables or suitable materialized views based on refresh needs. 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
- Downstream queries reuse approved transformed data without rebuilding every stage
- The query finishes but returns a different business total
Explanation
Correct Answer
C:Acceptance evidence: Downstream queries reuse approved transformed data without rebuilding every stage. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Downstream queries reuse approved transformed data without rebuilding every stage.
B:This observation is insufficient. The stronger validation is: Downstream queries reuse approved transformed data without rebuilding every stage.
D:This observation is insufficient. The stronger validation is: Downstream queries reuse approved transformed data without rebuilding every stage.
Question 597
An auditor requires a normal analytic table with standard Time Travel and Fail-safe protections The team proposes: Choose an appropriately configured permanent Snowflake table. Which test outcome is the strongest direct evidence that this change works?
- The table's configured retention and recovery characteristics match the approved policy
- 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
Explanation
Correct Answer
A:Acceptance evidence: The table's configured retention and recovery characteristics match the approved policy. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The table's configured retention and recovery characteristics match the approved policy.
C:This observation is insufficient. The stronger validation is: The table's configured retention and recovery characteristics match the approved policy.
D:This observation is insufficient. The stronger validation is: The table's configured retention and recovery characteristics match the approved policy.
Question 598
A data science team wants Python DataFrame transformations executed close to Snowflake data The team proposes: Use Snowpark with appropriately scoped compute and dependencies. Which test outcome is the strongest direct evidence that this change works?
- The warehouse login succeeds but the required query fails
- Transformations execute within Snowflake under the intended data-access context
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
Explanation
Correct Answer
B:Acceptance evidence: Transformations execute within Snowflake under the intended data-access context. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Transformations execute within Snowflake under the intended data-access context.
C:This observation is insufficient. The stronger validation is: Transformations execute within Snowflake under the intended data-access context.
D:This observation is insufficient. The stronger validation is: Transformations execute within Snowflake under the intended data-access context.
Question 599
A source repository must be used to version SQL scripts and notebooks deployed into Snowflake Which technical action is most appropriate under this requirement?
- Use result cache to version source code
- Store the commit hash in a warehouse name only
- Send scripts by email without revision tracking
- Use a supported Git repository integration and configured repository object where appropriate
Explanation
Correct Answer
D:Use a supported Git repository integration and configured repository object where appropriate. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A source repository must be used to version SQL scripts and notebooks deployed into Snowflake. The appropriate decision: Use a supported Git repository integration and configured repository object where appropriate.
B:The problem: A source repository must be used to version SQL scripts and notebooks deployed into Snowflake. The appropriate decision: Use a supported Git repository integration and configured repository object where appropriate.
C:The problem: A source repository must be used to version SQL scripts and notebooks deployed into Snowflake. The appropriate decision: Use a supported Git repository integration and configured repository object where appropriate.
Question 600
A sensitive database should be accessible to service accounts only through approved access roles 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: Service identities see only their required schemas and tables
- Change and rollback evidence is retained with the release
- PUBLIC or overly broad inherited roles expose unrelated data
Explanation
Correct Answer
D:Unresolved failure: PUBLIC or overly broad inherited roles expose unrelated data. 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: PUBLIC or overly broad inherited roles expose unrelated data.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: PUBLIC or overly broad inherited roles expose unrelated data.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: PUBLIC or overly broad inherited roles expose unrelated data.
SnowPro Core COF-C03 Practice Tests