100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 660
A source feed includes malformed numeric strings but valid values must still be loaded The team proposes: Use TRY_TO_NUMBER or suitable TRY_CAST expressions with explicit invalid-value handling. 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
- The query finishes but returns a different business total
- Valid numbers convert while malformed strings are handled without aborting all rows
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
C:Acceptance evidence: Valid numbers convert while malformed strings are handled without aborting all rows. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Valid numbers convert while malformed strings are handled without aborting all rows.
B:This observation is insufficient. The stronger validation is: Valid numbers convert while malformed strings are handled without aborting all rows.
D:This observation is insufficient. The stronger validation is: Valid numbers convert while malformed strings are handled without aborting all rows.
Question 661
Data engineers want a fast dev copy of a large production table without physically duplicating every micro-partition Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Create a zero-copy clone at the supported table or schema scope
- Replace storage cloning with a warehouse resize
- Copy every record through a client export and reload by default
- The clone is independently writable while initial shared storage is not fully copied
- Make all developers write against the production table
Explanation
Correct Answers
A:Create a zero-copy clone at the supported table or schema scope. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: The clone is independently writable while initial shared storage is not fully copied. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: Data engineers want a fast dev copy of a large production table without physically duplicating every micro-partition. The appropriate decision: Create a zero-copy clone at the supported table or schema scope.
C:The problem: Data engineers want a fast dev copy of a large production table without physically duplicating every micro-partition. The appropriate decision: Create a zero-copy clone at the supported table or schema scope.
E:The problem: Data engineers want a fast dev copy of a large production table without physically duplicating every micro-partition. The appropriate decision: Create a zero-copy clone at the supported table or schema scope.
Question 662
An analyst wants to know why a query scanned many bytes when filters should have been selective Which technical action is most appropriate under this requirement?
- Use row access policies to hide query cost
- Count Snowflake roles as the bytes scanned
- Change SQL capitalization as a storage-pruning strategy
- Open the Query Profile and inspect table scan and pruning statistics
Explanation
Correct Answer
D:Open the Query Profile and inspect table scan and pruning statistics. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
B:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
C:The problem: An analyst wants to know why a query scanned many bytes when filters should have been selective. The appropriate decision: Open the Query Profile and inspect table scan and pruning statistics.
Question 663
A masking policy uses CURRENT_ROLE but a consumer has several other granted roles Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Remove all table access to troubleshoot presentation
- Make the warehouse larger for policy evaluation
- Use an external stage name as a masking condition
- Test effective role context and choose the appropriate supported policy-context expression
- The consumer's masking outcome matches documented active-role behavior
Explanation
Correct Answers
D:Test effective role context and choose the appropriate supported policy-context expression. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: The consumer's masking outcome matches documented active-role behavior. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A masking policy uses CURRENT_ROLE but a consumer has several other granted roles. The appropriate decision: Test effective role context and choose the appropriate supported policy-context expression.
B:The problem: A masking policy uses CURRENT_ROLE but a consumer has several other granted roles. The appropriate decision: Test effective role context and choose the appropriate supported policy-context expression.
C:The problem: A masking policy uses CURRENT_ROLE but a consumer has several other granted roles. The appropriate decision: Test effective role context and choose the appropriate supported policy-context expression.
Question 664
A provider must expose only filtered sensitive records rather than its entire base table Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Share the entire unfiltered table by default
- Grant the consumer OWNERSHIP on the source database
- The consumer can see permitted rows or columns but not restricted data
- Use supported secure sharing objects and governance to limit shared access
- Rely solely on a consumer dashboard filter
Explanation
Correct Answers
C:Acceptance evidence: The consumer can see permitted rows or columns but not restricted data. Completing configuration alone is insufficient.
D:Use supported secure sharing objects and governance to limit shared access. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A provider must expose only filtered sensitive records rather than its entire base table. The appropriate decision: Use supported secure sharing objects and governance to limit shared access.
B:The problem: A provider must expose only filtered sensitive records rather than its entire base table. The appropriate decision: Use supported secure sharing objects and governance to limit shared access.
E:The problem: A provider must expose only filtered sensitive records rather than its entire base table. The appropriate decision: Use supported secure sharing objects and governance to limit shared access.
Question 665
An administrator assumes warehouse resizing can change stored micro-partition membership in the same way as table reclustering The team proposes: Separate compute sizing from physical clustering decisions in performance triage. Which test outcome is the strongest direct evidence that this change works?
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
- A metadata row exists while no relevant data is tested
- Scaling tests and clustering-pruning metrics are evaluated independently
Explanation
Correct Answer
D:Acceptance evidence: Scaling tests and clustering-pruning metrics are evaluated independently. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Scaling tests and clustering-pruning metrics are evaluated independently.
B:This observation is insufficient. The stronger validation is: Scaling tests and clustering-pruning metrics are evaluated independently.
C:This observation is insufficient. The stronger validation is: Scaling tests and clustering-pruning metrics are evaluated independently.
Question 666
An operations policy allows removal of staged files only after an accountable load The team proposes: Use COPY purge settings or REMOVE only after verified successful ingestion. Which test outcome is the strongest direct evidence that this change works?
- The staged file appears in LIST but no destination row is validated
- Processed files are removed safely without losing unprocessed source data
- One connector starts but no expected event arrives
- A job status is green without comparing source and target record counts
Explanation
Correct Answer
B:Acceptance evidence: Processed files are removed safely without losing unprocessed source data. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Processed files are removed safely without losing unprocessed source data.
C:This observation is insufficient. The stronger validation is: Processed files are removed safely without losing unprocessed source data.
D:This observation is insufficient. The stronger validation is: Processed files are removed safely without losing unprocessed source data.
Question 667
A selective filter-plus-aggregation query is CPU-intensive and eligible for offloaded acceleration 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 pays for acceleration on queries that receive no supported benefit
- The team confirms: Eligible query latency falls with observed acceleration and bounded credits
Explanation
Correct Answer
C:Unresolved failure: The team pays for acceleration on queries that receive no supported benefit. 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: The team pays for acceleration on queries that receive no supported benefit.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The team pays for acceleration on queries that receive no supported benefit.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: The team pays for acceleration on queries that receive no supported benefit.
Question 668
The pipeline owner wants to confirm which files loaded successfully yesterday Which technical action is most appropriate under this requirement?
- Consult supported COPY history and load-status evidence
- Run a SELECT COUNT(*) without source-file reconciliation
- Treat a successful stage LIST as proof the rows were loaded
- Reset the warehouse cache and call it load audit
Explanation
Correct Answer
A:Consult supported COPY history and load-status evidence. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: The pipeline owner wants to confirm which files loaded successfully yesterday. The appropriate decision: Consult supported COPY history and load-status evidence.
C:The problem: The pipeline owner wants to confirm which files loaded successfully yesterday. The appropriate decision: Consult supported COPY history and load-status evidence.
D:The problem: The pipeline owner wants to confirm which files loaded successfully yesterday. The appropriate decision: Consult supported COPY history and load-status evidence.
Question 669
A JSON array contains multiple line items and a report needs one output row per element The team proposes: Use LATERAL FLATTEN on the array expression. Which test outcome is the strongest direct evidence that this change works?
- Each array item produces a traversable row with its position and value
- 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: Each array item produces a traversable row with its position and value. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Each array item produces a traversable row with its position and value.
C:This observation is insufficient. The stronger validation is: Each array item produces a traversable row with its position and value.
D:This observation is insufficient. The stronger validation is: Each array item produces a traversable row with its position and value.
Question 670
A compliance report needs a clear separation between data-owner grants and access by ordinary analysts The team proposes: Assign OWNERSHIP and read privileges to distinct governed roles with reviewed inheritance. Which test outcome is the strongest direct evidence that this change works?
- Analyst sessions can read permitted objects but cannot grant themselves ownership
- An administrator can run the query but a standard role remains unauthorized
- The policy is listed in metadata but denied accesses are never tested
- A role name looks correct while the effective grants remain unchecked
Explanation
Correct Answer
A:Acceptance evidence: Analyst sessions can read permitted objects but cannot grant themselves ownership. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Analyst sessions can read permitted objects but cannot grant themselves ownership.
C:This observation is insufficient. The stronger validation is: Analyst sessions can read permitted objects but cannot grant themselves ownership.
D:This observation is insufficient. The stronger validation is: Analyst sessions can read permitted objects but cannot grant themselves ownership.
SnowPro Core COF-C03 Practice Tests