100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 200
A team stores JSON as plain text and wants to use JSON path navigation in SQL Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Parse the JSON text into a VARIANT value using supported parsing functions
- Set a file format name as a SQL object path
- Add a second warehouse instead of parsing
- Nested attributes can be accessed by the intended SQL path syntax
- Cast the JSON text to BOOLEAN for object navigation
Explanation
Correct Answers
A:Parse the JSON text into a VARIANT value using supported parsing functions. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: Nested attributes can be accessed by the intended SQL path syntax. Completing configuration alone is insufficient.
Incorrect Answers
B:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
C:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
E:The problem: A team stores JSON as plain text and wants to use JSON path navigation in SQL. The appropriate decision: Parse the JSON text into a VARIANT value using supported parsing functions.
Question 201
A monthly finance report needs the top three transactions per customer group Which unresolved finding would be a valid reason to block acceptance after the change?
- A global LIMIT is mistakenly treated as top-N per customer
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- The team confirms: Each customer has the intended top-ranked rows
Explanation
Correct Answer
A:Unresolved failure: A global LIMIT is mistakenly treated as top-N per customer. 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: A global LIMIT is mistakenly treated as top-N per customer.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: A global LIMIT is mistakenly treated as top-N per customer.
D:“The team confirms: Each customer has the intended top-ranked rows” describes a target or safeguard, not the release-blocking failure. The defect: A global LIMIT is mistakenly treated as top-N per customer.
Question 202
An analyst expects two independently sized warehouses to share their local cached data pages The team proposes: Treat warehouse-local caches as independent and test each warehouse's warm-up behavior. Which test outcome is the strongest direct evidence that this change works?
- Cache metrics show separately warming warehouses for the same shared table
- 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: Cache metrics show separately warming warehouses for the same shared table. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Cache metrics show separately warming warehouses for the same shared table.
C:This observation is insufficient. The stronger validation is: Cache metrics show separately warming warehouses for the same shared table.
D:This observation is insufficient. The stronger validation is: Cache metrics show separately warming warehouses for the same shared table.
Question 203
A JSON array contains multiple line items and a report needs one output row per element 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
- Array contents remain opaque and calculations miss elements
- The team confirms: Each array item produces a traversable row with its position and value
Explanation
Correct Answer
C:Unresolved failure: Array contents remain opaque and calculations miss elements. 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: Array contents remain opaque and calculations miss elements.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Array contents remain opaque and calculations miss elements.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Array contents remain opaque and calculations miss elements.
Question 204
An array stored inside a VARIANT purchase event must be expanded to order-line rows 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
- Nested line items remain hidden in an opaque array
- The team confirms: Each array element produces one order-line row linked to the parent event
Explanation
Correct Answer
C:Unresolved failure: Nested line items remain hidden in an opaque array. 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: Nested line items remain hidden in an opaque array.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Nested line items remain hidden in an opaque array.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: Nested line items remain hidden in an opaque array.
Question 205
Operators want to attribute a slow SQL run to the application release that triggered it Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Set an appropriate QUERY_TAG for traceability and query history filtering
- Target application queries can be grouped with deployment identifiers
- Replace query tags with a global table rename
- Grant global ACCOUNTADMIN just to distinguish runs
- Use an unrecorded chat message as a query identifier
Explanation
Correct Answers
A:Set an appropriate QUERY_TAG for traceability and query history filtering. This addresses the stated condition without bypassing the required boundary.
B:Acceptance evidence: Target application queries can be grouped with deployment identifiers. Completing configuration alone is insufficient.
Incorrect Answers
C:The problem: Operators want to attribute a slow SQL run to the application release that triggered it. The appropriate decision: Set an appropriate QUERY_TAG for traceability and query history filtering.
D:The problem: Operators want to attribute a slow SQL run to the application release that triggered it. The appropriate decision: Set an appropriate QUERY_TAG for traceability and query history filtering.
E:The problem: Operators want to attribute a slow SQL run to the application release that triggered it. The appropriate decision: Set an appropriate QUERY_TAG for traceability and query history filtering.
Question 206
A data team wants a reusable governed location for multiple ingestion workflows The team proposes: Create a named internal stage with appropriate file format and privileges. Which test outcome is the strongest direct evidence that this change works?
- One connector starts but no expected event arrives
- Authorized ingestion jobs can access the approved staged files
- A job status is green without comparing source and target record counts
- The staged file appears in LIST but no destination row is validated
Explanation
Correct Answer
B:Acceptance evidence: Authorized ingestion jobs can access the approved staged files. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Authorized ingestion jobs can access the approved staged files.
C:This observation is insufficient. The stronger validation is: Authorized ingestion jobs can access the approved staged files.
D:This observation is insufficient. The stronger validation is: Authorized ingestion jobs can access the approved staged files.
Question 207
A team develops a distributable application with logic that customers install inside their own Snowflake accounts The team proposes: Assess the Snowflake Native App Framework and application package model. Which test outcome is the strongest direct evidence that this change works?
- The warehouse login succeeds but the required query fails
- A metadata row exists while no relevant data is tested
- A consumer can install a controlled package with the intended permissions and functionality
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
C:Acceptance evidence: A consumer can install a controlled package with the intended permissions and functionality. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: A consumer can install a controlled package with the intended permissions and functionality.
B:This observation is insufficient. The stronger validation is: A consumer can install a controlled package with the intended permissions and functionality.
D:This observation is insufficient. The stronger validation is: A consumer can install a controlled package with the intended permissions and functionality.
Question 208
An optimization proposal adds search optimization to a tiny reference table with infrequent lookups 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: Feature cost is justified only for the actual query workload
- A new optimization costs more than its benefit
Explanation
Correct Answer
D:Unresolved failure: A new optimization costs more than its 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: A new optimization costs more than its benefit.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: A new optimization costs more than its benefit.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: A new optimization costs more than its benefit.
Question 209
A developer needs to stage one local CSV for a quick upload without creating a permanent shared stage The team proposes: Use the appropriate user stage with a supported PUT and COPY workflow. Which test outcome is the strongest direct evidence that this change works?
- A job status is green without comparing source and target record counts
- The developer loads the intended staged file into the target table
- One connector starts but no expected event arrives
- The staged file appears in LIST but no destination row is validated
Explanation
Correct Answer
B:Acceptance evidence: The developer loads the intended staged file into the target table. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The developer loads the intended staged file into the target table.
C:This observation is insufficient. The stronger validation is: The developer loads the intended staged file into the target table.
D:This observation is insufficient. The stronger validation is: The developer loads the intended staged file into the target table.
Question 210
A platform team wants a derived table to refresh automatically toward a configured freshness target Which technical action is most appropriate under this requirement?
- Set a warehouse idle timeout as a TARGET_LAG
- Enable a role hierarchy without defining the derived query
- Use CREATE TABLE AS SELECT once and call it continuous refresh
- Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG
Explanation
Correct Answer
D:Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A platform team wants a derived table to refresh automatically toward a configured freshness target. The appropriate decision: Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG.
B:The problem: A platform team wants a derived table to refresh automatically toward a configured freshness target. The appropriate decision: Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG.
C:The problem: A platform team wants a derived table to refresh automatically toward a configured freshness target. The appropriate decision: Define a dynamic table using supported transformation SQL and an appropriate TARGET_LAG.
SnowPro Core COF-C03 Practice Tests