100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 500
A developer needs a non-production point-in-time copy of a table before a risky migration The team proposes: Use a clone at an appropriate supported Time Travel point. Which test outcome is the strongest direct evidence that this change works?
- A metadata row exists while no relevant data is tested
- The cloned table represents the expected prior state without overwriting production
- An unrelated compute counter improves with no correctness check
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: The cloned table represents the expected prior state without overwriting production. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
C:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
D:This observation is insufficient. The stronger validation is: The cloned table represents the expected prior state without overwriting production.
Question 501
A provider must remove a former partner's access after contract expiration The team proposes: Revoke the recipient's share or listing access and validate remaining recipients. Which test outcome is the strongest direct evidence that this change works?
- The provider sees a shared object but the recipient cannot query it
- The listing is visible while unauthorized access is not tested
- Only internal-provider access is demonstrated instead of the intended consumer role
- The former consumer loses access while other approved consumers retain it
Explanation
Correct Answer
D:Acceptance evidence: The former consumer loses access while other approved consumers retain it. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The former consumer loses access while other approved consumers retain it.
B:This observation is insufficient. The stronger validation is: The former consumer loses access while other approved consumers retain it.
C:This observation is insufficient. The stronger validation is: The former consumer loses access while other approved consumers retain it.
Question 502
A SQL filter needs rows where a field is unknown rather than equal to the string 'NULL' The team proposes: Use IS NULL or IS NOT NULL with the intended SQL three-valued logic. Which test outcome is the strongest direct evidence that this change works?
- A single warm-cache run is cited without representative execution metrics
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The query finishes but returns a different business total
- The result includes actual NULL values and excludes the literal text where appropriate
Explanation
Correct Answer
D:Acceptance evidence: The result includes actual NULL values and excludes the literal text where appropriate. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The result includes actual NULL values and excludes the literal text where appropriate.
B:This observation is insufficient. The stronger validation is: The result includes actual NULL values and excludes the literal text where appropriate.
C:This observation is insufficient. The stronger validation is: The result includes actual NULL values and excludes the literal text where appropriate.
Question 503
An analytic workload repeatedly computes the same expensive aggregate over a large base table Which technical action is most appropriate under this requirement?
- Use a temporary table that only exists in another session
- Evaluate a suitable materialized view under supported query and maintenance constraints
- Create an ordinary nonmaterialized view and assume it stores aggregated rows
- Set a network policy as a query materialization flag
Explanation
Correct Answer
B:Evaluate a suitable materialized view under supported query and maintenance constraints. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An analytic workload repeatedly computes the same expensive aggregate over a large base table. The appropriate decision: Evaluate a suitable materialized view under supported query and maintenance constraints.
C:The problem: An analytic workload repeatedly computes the same expensive aggregate over a large base table. The appropriate decision: Evaluate a suitable materialized view under supported query and maintenance constraints.
D:The problem: An analytic workload repeatedly computes the same expensive aggregate over a large base table. The appropriate decision: Evaluate a suitable materialized view under supported query and maintenance constraints.
Question 504
An architect wants a policy to apply to all columns carrying a sensitive classification tag where supported Which proposal best pairs a technically correct change with the outcome that would validate it?
- Use a separate query warehouse as a data classification control; no direct validation of Newly tagged eligible columns receive the expected masking behavior
- Evaluate tag-based masking governance with tested inherited policy behavior; verify Newly tagged eligible columns receive the expected masking behavior
- Treat adding a label as proof that masking occurred; no direct validation of Newly tagged eligible columns receive the expected masking behavior
- Grant all users table ownership to see masked data; no direct validation of Newly tagged eligible columns receive the expected masking behavior
Explanation
Correct Answer
B:Evaluate tag-based masking governance with tested inherited policy behavior. Verify: Newly tagged eligible columns receive the expected masking behavior.
Incorrect Answers
A:Required correction: Evaluate tag-based masking governance with tested inherited policy behavior. Evidence: Newly tagged eligible columns receive the expected masking behavior.
C:Required correction: Evaluate tag-based masking governance with tested inherited policy behavior. Evidence: Newly tagged eligible columns receive the expected masking behavior.
D:Required correction: Evaluate tag-based masking governance with tested inherited policy behavior. Evidence: Newly tagged eligible columns receive the expected masking behavior.
Question 505
An ETL procedure needs to merge new customer records and update matching existing rows Which proposal best pairs a technically correct change with the outcome that would validate it?
- Delete all destination rows for a small incremental batch; no direct validation of Existing keys update and new keys insert once under tested source conditions
- Use INSERT without matching for every update; no direct validation of Existing keys update and new keys insert once under tested source conditions
- Use MERGE with supported matching conditions and update/insert branches; verify Existing keys update and new keys insert once under tested source conditions
- Apply an unrelated ORDER BY as an upsert key; no direct validation of Existing keys update and new keys insert once under tested source conditions
Explanation
Correct Answer
C:Use MERGE with supported matching conditions and update/insert branches. Verify: Existing keys update and new keys insert once under tested source conditions.
Incorrect Answers
A:Required correction: Use MERGE with supported matching conditions and update/insert branches. Evidence: Existing keys update and new keys insert once under tested source conditions.
B:Required correction: Use MERGE with supported matching conditions and update/insert branches. Evidence: Existing keys update and new keys insert once under tested source conditions.
D:Required correction: Use MERGE with supported matching conditions and update/insert branches. Evidence: Existing keys update and new keys insert once under tested source conditions.
Question 506
An administrator wants notifications when a warehouse reaches a credit-spending threshold Which technical action is most appropriate under this requirement?
- Configure a resource monitor with the intended warehouse assignment and actions
- Use a database role instead of a resource monitor
- Disable warehouse metering views
- Apply a table row access policy as a credit cap
Explanation
Correct Answer
A:Configure a resource monitor with the intended warehouse assignment and actions. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
B:The problem: An administrator wants notifications when a warehouse reaches a credit-spending threshold. The appropriate decision: Configure a resource monitor with the intended warehouse assignment and actions.
C:The problem: An administrator wants notifications when a warehouse reaches a credit-spending threshold. The appropriate decision: Configure a resource monitor with the intended warehouse assignment and actions.
D:The problem: An administrator wants notifications when a warehouse reaches a credit-spending threshold. The appropriate decision: Configure a resource monitor with the intended warehouse assignment and actions.
Question 507
A service user authenticates using a password embedded in deployment scripts The team proposes: Move to an approved supported service authentication mechanism such as key-pair authentication and protect private keys. Which test outcome is the strongest direct evidence that this change works?
- 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
- The service can sign in without storing plaintext passwords in code
Explanation
Correct Answer
D:Acceptance evidence: The service can sign in without storing plaintext passwords in code. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The service can sign in without storing plaintext passwords in code.
B:This observation is insufficient. The stronger validation is: The service can sign in without storing plaintext passwords in code.
C:This observation is insufficient. The stronger validation is: The service can sign in without storing plaintext passwords in code.
Question 508
A restricted support role needs to review user metadata without being able to manage all grants The team proposes: Create a least-privilege access path aligned with supported metadata privileges. Which test outcome is the strongest direct evidence that this change works?
- The policy is listed in metadata but denied accesses are never tested
- A role name looks correct while the effective grants remain unchecked
- The role can view authorized metadata but cannot grant broad data permissions
- An administrator can run the query but a standard role remains unauthorized
Explanation
Correct Answer
C:Acceptance evidence: The role can view authorized metadata but cannot grant broad data permissions. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The role can view authorized metadata but cannot grant broad data permissions.
B:This observation is insufficient. The stronger validation is: The role can view authorized metadata but cannot grant broad data permissions.
D:This observation is insufficient. The stronger validation is: The role can view authorized metadata but cannot grant broad data permissions.
Question 509
A user drops a table and promptly needs it restored while its data is still eligible Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Share the empty table with another account
- Change warehouse size instead of restoring the object
- The original table is accessible again with its expected data
- Create an empty table with the same name and declare data recovered
- Use the supported UNDROP command within the applicable recovery window
Explanation
Correct Answers
C:Acceptance evidence: The original table is accessible again with its expected data. Completing configuration alone is insufficient.
E:Use the supported UNDROP command within the applicable recovery window. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: A user drops a table and promptly needs it restored while its data is still eligible. The appropriate decision: Use the supported UNDROP command within the applicable recovery window.
B:The problem: A user drops a table and promptly needs it restored while its data is still eligible. The appropriate decision: Use the supported UNDROP command within the applicable recovery window.
D:The problem: A user drops a table and promptly needs it restored while its data is still eligible. The appropriate decision: Use the supported UNDROP command within the applicable recovery window.
Question 510
A very large table is filtered on transaction date and nearly every micro-partition is scanned The team proposes: Inspect pruning statistics and test an appropriate clustering strategy based on workload filters. Which test outcome is the strongest direct evidence that this change works?
- An unrelated compute counter improves with no correctness check
- The percentage of scanned partitions drops for representative date predicates
- A metadata row exists while no relevant data is tested
- The warehouse login succeeds but the required query fails
Explanation
Correct Answer
B:Acceptance evidence: The percentage of scanned partitions drops for representative date predicates. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The percentage of scanned partitions drops for representative date predicates.
C:This observation is insufficient. The stronger validation is: The percentage of scanned partitions drops for representative date predicates.
D:This observation is insufficient. The stronger validation is: The percentage of scanned partitions drops for representative date predicates.
SnowPro Core COF-C03 Practice Tests