100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 211
An ETL procedure needs to merge new customer records and update matching existing rows Which technical action is most appropriate under this requirement?
- Use MERGE with supported matching conditions and update/insert branches
- Use INSERT without matching for every update
- Apply an unrelated ORDER BY as an upsert key
- Delete all destination rows for a small incremental batch
Explanation
Correct Answer
A:Use MERGE with supported matching conditions and update/insert branches. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: An ETL procedure needs to merge new customer records and update matching existing rows. The appropriate decision: Use MERGE with supported matching conditions and update/insert branches.
C:The problem: An ETL procedure needs to merge new customer records and update matching existing rows. The appropriate decision: Use MERGE with supported matching conditions and update/insert branches.
D:The problem: An ETL procedure needs to merge new customer records and update matching existing rows. The appropriate decision: Use MERGE with supported matching conditions and update/insert branches.
Question 212
An analyst's role was changed but their session continues using a different active primary role 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: The session executes under the expected privilege context
- Troubleshooting assumes all granted roles are active in the same way
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
C:Unresolved failure: Troubleshooting assumes all granted roles are active in the same way. 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: Troubleshooting assumes all granted roles are active in the same way.
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Troubleshooting assumes all granted roles are active in the same way.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Troubleshooting assumes all granted roles are active in the same way.
Question 213
A legacy source sends variable JSON schemas but downstream analysts require selected typed columns Which technical action is most appropriate under this requirement?
- Extract and cast needed VARIANT paths in a governed SQL view
- Drop unexpected JSON fields before retaining raw data
- Expose only the original string without typed extraction
- Create a bigger warehouse instead of mapping types
Explanation
Correct Answer
A:Extract and cast needed VARIANT paths in a governed SQL view. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A legacy source sends variable JSON schemas but downstream analysts require selected typed columns. The appropriate decision: Extract and cast needed VARIANT paths in a governed SQL view.
C:The problem: A legacy source sends variable JSON schemas but downstream analysts require selected typed columns. The appropriate decision: Extract and cast needed VARIANT paths in a governed SQL view.
D:The problem: A legacy source sends variable JSON schemas but downstream analysts require selected typed columns. The appropriate decision: Extract and cast needed VARIANT paths in a governed SQL view.
Question 214
An audit requires identifying which roles actually queried regulated data over a period Which technical action is most appropriate under this requirement?
- Treat a successful sign-in as proof of SELECT activity
- Use supported access history and relevant audit views with authorized privileges
- Use table clustering as an access event log
- Delete query history before compiling the audit
Explanation
Correct Answer
B:Use supported access history and relevant audit views with authorized privileges. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
C:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
D:The problem: An audit requires identifying which roles actually queried regulated data over a period. The appropriate decision: Use supported access history and relevant audit views with authorized privileges.
Question 215
A business user wants generated summaries of customer-support text stored inside Snowflake The team proposes: Evaluate an appropriate Snowflake Cortex AI function with data access and usage controls. 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
- Outputs satisfy a sampled quality check and credit consumption is observable
- An unrelated compute counter improves with no correctness check
Explanation
Correct Answer
C:Acceptance evidence: Outputs satisfy a sampled quality check and credit consumption is observable. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Outputs satisfy a sampled quality check and credit consumption is observable.
B:This observation is insufficient. The stronger validation is: Outputs satisfy a sampled quality check and credit consumption is observable.
D:This observation is insufficient. The stronger validation is: Outputs satisfy a sampled quality check and credit consumption is observable.
Question 216
Files live in a controlled cloud object-storage bucket rather than a Snowflake-managed stage Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: External credentials are embedded broadly or access goes outside the scoped prefix
- Snowflake lists and reads approved objects from the external storage prefix
- Assume an internal stage automatically imports the external bucket
- Create a table clone instead of a storage integration
- Configure an external stage with a supported storage integration and least-privilege access
- Expose long-lived cloud secrets in SQL code
Explanation
Correct Answers
A:Unresolved failure: External credentials are embedded broadly or access goes outside the scoped prefix. Correct and test it before acceptance.
B:Acceptance evidence: Snowflake lists and reads approved objects from the external storage prefix. Completing configuration alone is insufficient.
E:Configure an external stage with a supported storage integration and least-privilege access. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
C:The problem: Files live in a controlled cloud object-storage bucket rather than a Snowflake-managed stage. The appropriate decision: Configure an external stage with a supported storage integration and least-privilege access.
D:The problem: Files live in a controlled cloud object-storage bucket rather than a Snowflake-managed stage. The appropriate decision: Configure an external stage with a supported storage integration and least-privilege access.
F:The problem: Files live in a controlled cloud object-storage bucket rather than a Snowflake-managed stage. The appropriate decision: Configure an external stage with a supported storage integration and least-privilege access.
Question 217
An architecture plan requires a dedicated isolated ETL execution cluster and independent analyst compute The team proposes: Assign ETL and interactive work to separate warehouses with workload-specific sizing. Which test outcome is the strongest direct evidence that this change works?
- Long transformations do not queue unrelated interactive queries
- 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: Long transformations do not queue unrelated interactive queries. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Long transformations do not queue unrelated interactive queries.
C:This observation is insufficient. The stronger validation is: Long transformations do not queue unrelated interactive queries.
D:This observation is insufficient. The stronger validation is: Long transformations do not queue unrelated interactive queries.
Question 218
A customer demands free-form chatbot question answering over authorized Snowflake business tables Which technical action is most appropriate under this requirement?
- Give the agent unrestricted ACCOUNTADMIN access
- Assume an LLM prompt replaces role grants
- Copy all tables to an unsanctioned external bot
- Use a supported Cortex or agent capability with access boundaries and response evaluation
Explanation
Correct Answer
D:Use a supported Cortex or agent capability with access boundaries and response evaluation. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A customer demands free-form chatbot question answering over authorized Snowflake business tables. The appropriate decision: Use a supported Cortex or agent capability with access boundaries and response evaluation.
B:The problem: A customer demands free-form chatbot question answering over authorized Snowflake business tables. The appropriate decision: Use a supported Cortex or agent capability with access boundaries and response evaluation.
C:The problem: A customer demands free-form chatbot question answering over authorized Snowflake business tables. The appropriate decision: Use a supported Cortex or agent capability with access boundaries and response evaluation.
Question 219
A privacy collaboration needs aggregate overlap analysis without exposing both parties' raw customer records The team proposes: Use an appropriate governed Snowflake Data Clean Room design and approved analysis templates. Which test outcome is the strongest direct evidence that this change works?
- Only permitted aggregate outputs are returned without unrestricted row access
- Only internal-provider access is demonstrated instead of the intended consumer role
- The provider sees a shared object but the recipient cannot query it
- The listing is visible while unauthorized access is not tested
Explanation
Correct Answer
A:Acceptance evidence: Only permitted aggregate outputs are returned without unrestricted row access. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: Only permitted aggregate outputs are returned without unrestricted row access.
C:This observation is insufficient. The stronger validation is: Only permitted aggregate outputs are returned without unrestricted row access.
D:This observation is insufficient. The stronger validation is: Only permitted aggregate outputs are returned without unrestricted row access.
Question 220
A task should run only when a source stream actually has pending changes The team proposes: Use a task WHEN condition with the supported stream-has-data predicate. Which test outcome is the strongest direct evidence that this change works?
- A job status is green without comparing source and target record counts
- Run history shows the transformation is triggered when eligible changes exist
- 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: Run history shows the transformation is triggered when eligible changes exist. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Run history shows the transformation is triggered when eligible changes exist.
C:This observation is insufficient. The stronger validation is: Run history shows the transformation is triggered when eligible changes exist.
D:This observation is insufficient. The stronger validation is: Run history shows the transformation is triggered when eligible changes exist.
SnowPro Core COF-C03 Practice Tests