100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 100
A report filters a huge event table on a selective date range but scans almost all partitions 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: The proportion of micro-partitions scanned falls without changing results
- Poor pruning causes unnecessary storage reads
Explanation
Correct Answer
D:Unresolved failure: Poor pruning causes unnecessary storage reads. 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: Poor pruning causes unnecessary storage reads.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Poor pruning causes unnecessary storage reads.
C:This is a legitimate target or safeguard, not the unresolved failure described in the question: Poor pruning causes unnecessary storage reads.
Question 101
A newly created task is present in metadata but never runs according to schedule Which technical action is most appropriate under this requirement?
- Change only the task comment
- Verify that the task is resumed and its owner role and compute settings are valid
- Increase a view's Time Travel retention
- Set all underlying tables to transient as a scheduler
Explanation
Correct Answer
B:Verify that the task is resumed and its owner role and compute settings are valid. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
C:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
D:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
Question 102
A consumer requires compressed CSV exports with controlled filenames and partitions Which technical action is most appropriate under this requirement?
- Use a row masking policy as the CSV delimiter
- Change query acceleration to compress output files
- Configure supported COPY INTO location formatting, compression and output options
- Set auto-suspend to control file-partition names
Explanation
Correct Answer
C:Configure supported COPY INTO location formatting, compression and output options. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A consumer requires compressed CSV exports with controlled filenames and partitions. The appropriate decision: Configure supported COPY INTO location formatting, compression and output options.
B:The problem: A consumer requires compressed CSV exports with controlled filenames and partitions. The appropriate decision: Configure supported COPY INTO location formatting, compression and output options.
D:The problem: A consumer requires compressed CSV exports with controlled filenames and partitions. The appropriate decision: Configure supported COPY INTO location formatting, compression and output options.
Question 103
A data model stores frequently updated operational entities but most traffic is analytical scanning Which technical action is most appropriate under this requirement?
- Choose the appropriate analytic Snowflake table design rather than treating all workloads as point-write transactions
- Perform all aggregations in a mobile app
- Disable warehouse compute and expect database storage to run queries
- Use hybrid tables for every analytical fact table without evaluation
Explanation
Correct Answer
A:Choose the appropriate analytic Snowflake table design rather than treating all workloads as point-write transactions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A data model stores frequently updated operational entities but most traffic is analytical scanning. The appropriate decision: Choose the appropriate analytic Snowflake table design rather than treating all workloads as point-write transactions.
C:The problem: A data model stores frequently updated operational entities but most traffic is analytical scanning. The appropriate decision: Choose the appropriate analytic Snowflake table design rather than treating all workloads as point-write transactions.
D:The problem: A data model stores frequently updated operational entities but most traffic is analytical scanning. The appropriate decision: Choose the appropriate analytic Snowflake table design rather than treating all workloads as point-write transactions.
Question 104
A dashboard looks correct on sample data but joins orders to multi-valued addresses and duplicates revenue The team proposes: Resolve multiplicity at the correct business grain before aggregating revenue. 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
- Aggregated amounts reconcile to source orders after fixing the join
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
C:Acceptance evidence: Aggregated amounts reconcile to source orders after fixing the join. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Aggregated amounts reconcile to source orders after fixing the join.
B:This observation is insufficient. The stronger validation is: Aggregated amounts reconcile to source orders after fixing the join.
D:This observation is insufficient. The stronger validation is: Aggregated amounts reconcile to source orders after fixing the join.
Question 105
An external Iceberg catalog is updated by another engine and Snowflake queries show older metadata Which proposal best pairs a technically correct change with the outcome that would validate it?
- Rename the Snowflake role and assume snapshots update; no direct validation of Snowflake reflects the expected Iceberg snapshot after metadata synchronization
- Recreate unrelated SQL views without checking the catalog; no direct validation of Snowflake reflects the expected Iceberg snapshot after metadata synchronization
- Validate the supported catalog synchronization or refresh mechanism for the Iceberg table; verify Snowflake reflects the expected Iceberg snapshot after metadata synchronization
- Modify warehouse auto-suspend to trigger Iceberg metadata refresh; no direct validation of Snowflake reflects the expected Iceberg snapshot after metadata synchronization
Explanation
Correct Answer
C:Validate the supported catalog synchronization or refresh mechanism for the Iceberg table. Verify: Snowflake reflects the expected Iceberg snapshot after metadata synchronization.
Incorrect Answers
A:Required correction: Validate the supported catalog synchronization or refresh mechanism for the Iceberg table. Evidence: Snowflake reflects the expected Iceberg snapshot after metadata synchronization.
B:Required correction: Validate the supported catalog synchronization or refresh mechanism for the Iceberg table. Evidence: Snowflake reflects the expected Iceberg snapshot after metadata synchronization.
D:Required correction: Validate the supported catalog synchronization or refresh mechanism for the Iceberg table. Evidence: Snowflake reflects the expected Iceberg snapshot after metadata synchronization.
Question 106
A customer demands free-form chatbot question answering over authorized Snowflake business tables Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Copy all tables to an unsanctioned external bot
- Use a supported Cortex or agent capability with access boundaries and response evaluation
- The authorized agent returns useful tested answers without accessing denied data
- Give the agent unrestricted ACCOUNTADMIN access
- Assume an LLM prompt replaces role grants
Explanation
Correct Answers
B:Use a supported Cortex or agent capability with access boundaries and response evaluation. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: The authorized agent returns useful tested answers without accessing denied data. Completing configuration alone is insufficient.
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.
D: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.
E: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 107
A consumer account queries provider-owned shared tables but is uncertain where query compute is billed Which technical action is most appropriate under this requirement?
- Explain and validate that the consumer uses its own virtual warehouse for shared-data queries
- Assume shared tables copy into the consumer's warehouse storage
- Require the provider to resize a warehouse for every consumer query
- Use a reader role as proof the provider pays for all queries
Explanation
Correct Answer
A:Explain and validate that the consumer uses its own virtual warehouse for shared-data queries. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: A consumer account queries provider-owned shared tables but is uncertain where query compute is billed. The appropriate decision: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries.
C:The problem: A consumer account queries provider-owned shared tables but is uncertain where query compute is billed. The appropriate decision: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries.
D:The problem: A consumer account queries provider-owned shared tables but is uncertain where query compute is billed. The appropriate decision: Explain and validate that the consumer uses its own virtual warehouse for shared-data queries.
Question 108
A CSV file begins with a header row that must not become a data record Which unresolved finding would be a valid reason to block acceptance after the change?
- The relevant users retain exactly their approved access
- The header is ingested as an invalid business record
- Change and rollback evidence is retained with the release
- The team confirms: The first imported row matches actual business data rather than column names
Explanation
Correct Answer
B:Unresolved failure: The header is ingested as an invalid business record. 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 header is ingested as an invalid business record.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The header is ingested as an invalid business record.
D:This is a legitimate target or safeguard, not the unresolved failure described in the question: The header is ingested as an invalid business record.
Question 109
A newly created task is present in metadata but never runs according to schedule Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Change only the task comment
- Verify that the task is resumed and its owner role and compute settings are valid
- Task history contains successful scheduled runs
- Set all underlying tables to transient as a scheduler
- Increase a view's Time Travel retention
Explanation
Correct Answers
B:Verify that the task is resumed and its owner role and compute settings are valid. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Task history contains successful scheduled runs. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
D:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
E:The problem: A newly created task is present in metadata but never runs according to schedule. The appropriate decision: Verify that the task is resumed and its owner role and compute settings are valid.
Question 110
A team assumes a warehouse resource monitor also caps every serverless service credit in the account Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Each charge category is governed by an appropriate supported mechanism
- Change and rollback evidence is retained with the release
- Serverless service costs escape an incorrectly scoped monitor
- The relevant users retain exactly their approved access
Explanation
Correct Answer
C:Unresolved failure: Serverless service costs escape an incorrectly scoped monitor. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Serverless service costs escape an incorrectly scoped monitor.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Serverless service costs escape an incorrectly scoped monitor.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Serverless service costs escape an incorrectly scoped monitor.
SnowPro Core COF-C03 Practice Tests