100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 360
An application key has been exposed and must no longer authenticate Which technical action is most appropriate under this requirement?
- Rotate and invalidate the compromised authentication key using the supported mechanism
- Increase warehouse timeout to expire the key
- Only rename the service user without changing keys
- Export the private key into a broader shared folder
Explanation
Correct Answer
A:Rotate and invalidate the compromised authentication key using the supported mechanism. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: An application key has been exposed and must no longer authenticate. The appropriate decision: Rotate and invalidate the compromised authentication key using the supported mechanism.
C:The problem: An application key has been exposed and must no longer authenticate. The appropriate decision: Rotate and invalidate the compromised authentication key using the supported mechanism.
D:The problem: An application key has been exposed and must no longer authenticate. The appropriate decision: Rotate and invalidate the compromised authentication key using the supported mechanism.
Question 361
A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration Which technical action is most appropriate under this requirement?
- Create a masking policy and call it database failover
- Increase secondary warehouse size as a promotion command
- Use the documented promotion or failover workflow before treating the secondary as writable
- Run INSERT directly against an unchanged secondary replica
Explanation
Correct Answer
C:Use the documented promotion or failover workflow before treating the secondary as writable. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
B:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
D:The problem: A replicated database is readable in a secondary region and the owner wants to execute writes after disaster declaration. The appropriate decision: Use the documented promotion or failover workflow before treating the secondary as writable.
Question 362
Python developers plan to execute an unsupported external package inside a Snowpark UDF Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Rename the Python function without testing imports
- The UDF or procedure runs successfully in a supported environment
- Disable all network policies to install the dependency
- Check supported package availability and package or environment constraints before deployment
- Block release while: The deployment assumes arbitrary untrusted packages work without constraints
- Store Python dependencies in a data masking policy
Explanation
Correct Answers
B:Acceptance evidence: The UDF or procedure runs successfully in a supported environment. Completing configuration alone is insufficient.
D:Check supported package availability and package or environment constraints before deployment. This addresses the stated condition without bypassing the required boundary.
E:Unresolved failure: The deployment assumes arbitrary untrusted packages work without constraints. Correct and test it before acceptance.
Incorrect Answers
A:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
C:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
F:The problem: Python developers plan to execute an unsupported external package inside a Snowpark UDF. The appropriate decision: Check supported package availability and package or environment constraints before deployment.
Question 363
A CSV file contains quoted delimiters and naïve parsing splits the fields incorrectly Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Block release while: Misparsed fields corrupt the destination table
- Set a compatible CSV file format including enclosure and delimiter options
- Reorder table privileges to change CSV escaping
- Use a result-cache setting as a CSV parser
- A test record with embedded delimiters lands in the correct columns
- Replace the load with a database share
Explanation
Correct Answers
A:Unresolved failure: Misparsed fields corrupt the destination table. Correct and test it before acceptance.
B:Set a compatible CSV file format including enclosure and delimiter options. This addresses the stated condition without bypassing the required boundary.
E:Acceptance evidence: A test record with embedded delimiters lands in the correct columns. Completing configuration alone is insufficient.
Incorrect Answers
C:The problem: A CSV file contains quoted delimiters and naïve parsing splits the fields incorrectly. The appropriate decision: Set a compatible CSV file format including enclosure and delimiter options.
D:The problem: A CSV file contains quoted delimiters and naïve parsing splits the fields incorrectly. The appropriate decision: Set a compatible CSV file format including enclosure and delimiter options.
F:The problem: A CSV file contains quoted delimiters and naïve parsing splits the fields incorrectly. The appropriate decision: Set a compatible CSV file format including enclosure and delimiter options.
Question 364
A service produces JSON keys with inconsistent capitalization and queries unexpectedly return NULL The team proposes: Verify exact JSON path names and quoted-key case sensitivity. 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
- The expected VARIANT attributes resolve after correcting case and path references
Explanation
Correct Answer
D:Acceptance evidence: The expected VARIANT attributes resolve after correcting case and path references. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The expected VARIANT attributes resolve after correcting case and path references.
B:This observation is insufficient. The stronger validation is: The expected VARIANT attributes resolve after correcting case and path references.
C:This observation is insufficient. The stronger validation is: The expected VARIANT attributes resolve after correcting case and path references.
Question 365
Hundreds of tiny files arrive continuously, and the team is choosing a stable file-size strategy Which technical action is most appropriate under this requirement?
- Use a data masking policy to split files
- Batch or size files according to current Snowflake loading guidance and measured latency needs
- Combine an entire year's batch into one enormous file
- Require one-row files for every event without measuring overhead
Explanation
Correct Answer
B:Batch or size files according to current Snowflake loading guidance and measured latency needs. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: Hundreds of tiny files arrive continuously, and the team is choosing a stable file-size strategy. The appropriate decision: Batch or size files according to current Snowflake loading guidance and measured latency needs.
C:The problem: Hundreds of tiny files arrive continuously, and the team is choosing a stable file-size strategy. The appropriate decision: Batch or size files according to current Snowflake loading guidance and measured latency needs.
D:The problem: Hundreds of tiny files arrive continuously, and the team is choosing a stable file-size strategy. The appropriate decision: Batch or size files according to current Snowflake loading guidance and measured latency needs.
Question 366
A data provider manages reader accounts and wants to monitor their compute spend Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Reader-account usage is tracked and constrained according to the contract
- Block release while: Unexpected reader compute costs go unnoticed by the provider
- Disable usage views for reader accounts
- Assume a reader account always pays its own independent bill
- Use a schema comment as a warehouse credit cap
- Review the provider's reader-account resource and warehouse billing controls
Explanation
Correct Answers
A:Acceptance evidence: Reader-account usage is tracked and constrained according to the contract. Completing configuration alone is insufficient.
B:Unresolved failure: Unexpected reader compute costs go unnoticed by the provider. Correct and test it before acceptance.
F:Review the provider's reader-account resource and warehouse billing controls. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
C:The problem: A data provider manages reader accounts and wants to monitor their compute spend. The appropriate decision: Review the provider's reader-account resource and warehouse billing controls.
D:The problem: A data provider manages reader accounts and wants to monitor their compute spend. The appropriate decision: Review the provider's reader-account resource and warehouse billing controls.
E:The problem: A data provider manages reader accounts and wants to monitor their compute spend. The appropriate decision: Review the provider's reader-account resource and warehouse billing controls.
Question 367
A provider must expose only filtered sensitive records rather than its entire base table Which technical action is most appropriate under this requirement?
- Use supported secure sharing objects and governance to limit shared access
- Rely solely on a consumer dashboard filter
- Grant the consumer OWNERSHIP on the source database
- Share the entire unfiltered table by default
Explanation
Correct Answer
A:Use supported secure sharing objects and governance to limit shared access. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
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.
C: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.
D: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 368
Repeated queries become slower immediately after the team suspends its warehouse each minute The team proposes: Measure the benefit of warehouse-local data cache and adjust suspend interval intentionally. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
- An unrelated compute counter improves with no correctness check
- Warm runs on the same active warehouse improve without assuming cache persists through suspension
Explanation
Correct Answer
D:Acceptance evidence: Warm runs on the same active warehouse improve without assuming cache persists through suspension. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: Warm runs on the same active warehouse improve without assuming cache persists through suspension.
B:This observation is insufficient. The stronger validation is: Warm runs on the same active warehouse improve without assuming cache persists through suspension.
C:This observation is insufficient. The stronger validation is: Warm runs on the same active warehouse improve without assuming cache persists through suspension.
Question 369
An organization needs a lightweight prototype of structured reports and generative summaries without provisioning a server Which technical action is most appropriate under this requirement?
- Keep customer data solely in public browser storage
- Combine an approved Snowflake dashboard or notebook with supported Cortex functions
- Require manual installation of a Snowflake database engine
- Disable all access policies to simplify demos
Explanation
Correct Answer
B:Combine an approved Snowflake dashboard or notebook with supported Cortex functions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An organization needs a lightweight prototype of structured reports and generative summaries without provisioning a server. The appropriate decision: Combine an approved Snowflake dashboard or notebook with supported Cortex functions.
C:The problem: An organization needs a lightweight prototype of structured reports and generative summaries without provisioning a server. The appropriate decision: Combine an approved Snowflake dashboard or notebook with supported Cortex functions.
D:The problem: An organization needs a lightweight prototype of structured reports and generative summaries without provisioning a server. The appropriate decision: Combine an approved Snowflake dashboard or notebook with supported Cortex functions.
Question 370
Storage cost estimates assume every warehouse duplicates all table data Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: The capacity model counts shared table storage once and compute consumption separately
- Change and rollback evidence is retained with the release
- The design double-counts storage merely because warehouses are isolated
- The relevant users retain exactly their approved access
Explanation
Correct Answer
C:Unresolved failure: The design double-counts storage merely because warehouses are isolated. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: The design double-counts storage merely because warehouses are isolated.
B:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: The design double-counts storage merely because warehouses are isolated.
D:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: The design double-counts storage merely because warehouses are isolated.
SnowPro Core COF-C03 Practice Tests