100% Latest & Updated Snowflake SnowPro Core COF-C03 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 250
An analyst's role was changed but their session continues using a different active primary role Which technical action is most appropriate under this requirement?
- Change statement timeout to switch privileges
- Grant global MANAGE GRANTS to every analyst
- Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate
- Change the virtual warehouse size to select a role
Explanation
Correct Answer
C:Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: An analyst's role was changed but their session continues using a different active primary role. The appropriate decision: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate.
B:The problem: An analyst's role was changed but their session continues using a different active primary role. The appropriate decision: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate.
D:The problem: An analyst's role was changed but their session continues using a different active primary role. The appropriate decision: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate.
Question 251
Security wants password strength and expiration rules applied without editing each application table Select the TWO choices that together provide a supported correction and directly relevant acceptance evidence. (Choose TWO.)
- Reduce query timeout to enforce password length
- Configure supported account-level or user-level password policies where relevant
- Sign-in behavior follows documented password requirements
- Add SQL CHECK constraints to a reporting table to control passwords
- Use Time Travel retention as password expiration
Explanation
Correct Answers
B:Configure supported account-level or user-level password policies where relevant. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Sign-in behavior follows documented password requirements. Completing configuration alone is insufficient.
Incorrect Answers
A:The problem: Security wants password strength and expiration rules applied without editing each application table. The appropriate decision: Configure supported account-level or user-level password policies where relevant.
D:The problem: Security wants password strength and expiration rules applied without editing each application table. The appropriate decision: Configure supported account-level or user-level password policies where relevant.
E:The problem: Security wants password strength and expiration rules applied without editing each application table. The appropriate decision: Configure supported account-level or user-level password policies where relevant.
Question 252
An analyst wants to pivot category values into report columns with explicit aggregation The team proposes: Use a supported PIVOT approach with deliberate values and aggregation. Which test outcome is the strongest direct evidence that this change works?
- The query finishes but returns a different business total
- Only a warehouse CPU chart improves while query latency and scan behavior are unmeasured
- The output columns and aggregated values match the reporting contract
- A single warm-cache run is cited without representative execution metrics
Explanation
Correct Answer
C:Acceptance evidence: The output columns and aggregated values match the reporting contract. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The output columns and aggregated values match the reporting contract.
B:This observation is insufficient. The stronger validation is: The output columns and aggregated values match the reporting contract.
D:This observation is insufficient. The stronger validation is: The output columns and aggregated values match the reporting contract.
Question 253
A source feed includes malformed numeric strings but valid values must still be loaded Which unresolved finding would be a valid reason to block acceptance after the change?
- The team confirms: Valid numbers convert while malformed strings are handled without aborting all rows
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
- Invalid conversions crash the transformation or silently become incorrect metrics
Explanation
Correct Answer
D:Unresolved failure: Invalid conversions crash the transformation or silently become incorrect metrics. Correct and test it before acceptance.
Incorrect Answers
A:This is a legitimate target or safeguard, not the unresolved failure described in the question: Invalid conversions crash the transformation or silently become incorrect metrics.
B:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Invalid conversions crash the transformation or silently become incorrect metrics.
C:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Invalid conversions crash the transformation or silently become incorrect metrics.
Question 254
A large cloned analytics schema unexpectedly incurs compute costs after a workload changes Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Explain that cloning avoids initial physical copying but queries still consume warehouse compute
- Move user roles between databases to eliminate compute usage
- Storage and compute charges are measured separately for the clone workload
- Disable query history and assume billing stops
- Block release while: Zero-copy cloning is presented as zero-cost query execution
- Set table retention to zero to avoid warehouse credits
Explanation
Correct Answers
A:Explain that cloning avoids initial physical copying but queries still consume warehouse compute. This addresses the stated condition without bypassing the required boundary.
C:Acceptance evidence: Storage and compute charges are measured separately for the clone workload. Completing configuration alone is insufficient.
E:Unresolved failure: Zero-copy cloning is presented as zero-cost query execution. Correct and test it before acceptance.
Incorrect Answers
B:The problem: A large cloned analytics schema unexpectedly incurs compute costs after a workload changes. The appropriate decision: Explain that cloning avoids initial physical copying but queries still consume warehouse compute.
D:The problem: A large cloned analytics schema unexpectedly incurs compute costs after a workload changes. The appropriate decision: Explain that cloning avoids initial physical copying but queries still consume warehouse compute.
F:The problem: A large cloned analytics schema unexpectedly incurs compute costs after a workload changes. The appropriate decision: Explain that cloning avoids initial physical copying but queries still consume warehouse compute.
Question 255
An analyst's role was changed but their session continues using a different active primary role Which proposal best pairs a technically correct change with the outcome that would validate it?
- Grant global MANAGE GRANTS to every analyst; no direct validation of The session executes under the expected privilege context
- Change statement timeout to switch privileges; no direct validation of The session executes under the expected privilege context
- Change the virtual warehouse size to select a role; no direct validation of The session executes under the expected privilege context
- Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate; verify The session executes under the expected privilege context
Explanation
Correct Answer
D:Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate. Verify: The session executes under the expected privilege context.
Incorrect Answers
A:Required correction: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate. Evidence: The session executes under the expected privilege context.
B:Required correction: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate. Evidence: The session executes under the expected privilege context.
C:Required correction: Verify CURRENT_ROLE and activate the intended role with USE ROLE when appropriate. Evidence: The session executes under the expected privilege context.
Question 256
A batch import must reject invalid records rather than silently write partial bad data Which unresolved finding would be a valid reason to block acceptance after the change?
- Bad records disappear without traceability
- The team confirms: The load aborts or continues precisely as documented, with rejected records accounted for
- The relevant users retain exactly their approved access
- Change and rollback evidence is retained with the release
Explanation
Correct Answer
A:Unresolved failure: Bad records disappear without traceability. Correct and test it before acceptance.
Incorrect Answers
B:This is a legitimate target or safeguard, not the unresolved failure described in the question: Bad records disappear without traceability.
C:“The relevant users retain exactly their approved access” describes a target or safeguard, not the release-blocking failure. The defect: Bad records disappear without traceability.
D:“Change and rollback evidence is retained with the release” describes a target or safeguard, not the release-blocking failure. The defect: Bad records disappear without traceability.
Question 257
A provider must expose only filtered sensitive records rather than its entire base table The team proposes: Use supported secure sharing objects and governance to limit shared access. Which test outcome is the strongest direct evidence that this change works?
- The listing is visible while unauthorized access is not tested
- The provider sees a shared object but the recipient cannot query it
- The consumer can see permitted rows or columns but not restricted data
- Only internal-provider access is demonstrated instead of the intended consumer role
Explanation
Correct Answer
C:Acceptance evidence: The consumer can see permitted rows or columns but not restricted data. Completing configuration alone is insufficient.
Incorrect Answers
A:This observation is insufficient. The stronger validation is: The consumer can see permitted rows or columns but not restricted data.
B:This observation is insufficient. The stronger validation is: The consumer can see permitted rows or columns but not restricted data.
D:This observation is insufficient. The stronger validation is: The consumer can see permitted rows or columns but not restricted data.
Question 258
An application needs narrowly scoped privileges inside one database without account-wide administrative power The team proposes: Use a database role for suitable database-contained privileges and grant it to the required account role. Which test outcome is the strongest direct evidence that this change works?
- The application gains scoped object access without broad account-level privileges
- A role name looks correct while the effective grants remain unchecked
- The policy is listed in metadata but denied accesses are never tested
- An administrator can run the query but a standard role remains unauthorized
Explanation
Correct Answer
A:Acceptance evidence: The application gains scoped object access without broad account-level privileges. Completing configuration alone is insufficient.
Incorrect Answers
B:This observation is insufficient. The stronger validation is: The application gains scoped object access without broad account-level privileges.
C:This observation is insufficient. The stronger validation is: The application gains scoped object access without broad account-level privileges.
D:This observation is insufficient. The stronger validation is: The application gains scoped object access without broad account-level privileges.
Question 259
Business users report that their suspended reporting warehouse requires manual startup for each query Which technical action is most appropriate under this requirement?
- Increase the TIME_TRAVEL retention for the warehouse
- Set AUTO_RESUME = TRUE on the reporting warehouse
- Grant OWNERSHIP of all source tables to analysts
- Use an external stage to start compute
Explanation
Correct Answer
B:Set AUTO_RESUME = TRUE on the reporting warehouse. This addresses the stated condition without bypassing the required boundary.
Incorrect Answers
A:The problem: Business users report that their suspended reporting warehouse requires manual startup for each query. The appropriate decision: Set AUTO_RESUME = TRUE on the reporting warehouse.
C:The problem: Business users report that their suspended reporting warehouse requires manual startup for each query. The appropriate decision: Set AUTO_RESUME = TRUE on the reporting warehouse.
D:The problem: Business users report that their suspended reporting warehouse requires manual startup for each query. The appropriate decision: Set AUTO_RESUME = TRUE on the reporting warehouse.
Question 260
A service wants to compare each event timestamp with the immediately prior event for its device Select the THREE statements identifying the correct action, direct evidence, and unresolved release-blocking risk. (Choose THREE.)
- Use LEAD without checking direction and sorting
- Use COUNT(*) as a predecessor timestamp
- Use LAG with an appropriate PARTITION BY and deterministic ORDER BY
- Each event receives its own previous-device timestamp where present
- Join every event to every other device event
- Block release while: Window ordering is omitted and previous events are ambiguous
Explanation
Correct Answers
C:Use LAG with an appropriate PARTITION BY and deterministic ORDER BY. This addresses the stated condition without bypassing the required boundary.
D:Acceptance evidence: Each event receives its own previous-device timestamp where present. Completing configuration alone is insufficient.
F:Unresolved failure: Window ordering is omitted and previous events are ambiguous. Correct and test it before acceptance.
Incorrect Answers
A:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
B:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
E:The problem: A service wants to compare each event timestamp with the immediately prior event for its device. The appropriate decision: Use LAG with an appropriate PARTITION BY and deterministic ORDER BY.
SnowPro Core COF-C03 Practice Tests