Snowflake SnowPro Core Practice Test 50
Question 490
For an original SnowPro Core educational scenario, consider: A developer sets DATA_RETENTION_TIME_IN_DAYS beyond what the purchased edition or table type supports. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Inspect effective retention parameters and attempt a safe as-of query at an approved timestamp.
- Change: Set supported retention values per object type, edition and legal recovery need, with measured storage impact.
- Check: Inspect database-role grants, parent account-role membership and a permitted SELECT using the active account role.
- Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles.
- Assign an arbitrary 365-day Time Travel value to every Snowflake table without checking feature limits.
Explanation
Correct Answer
A:Time Travel retention limits vary by table class and edition, and historical storage contributes to cost. Required intervention: Set supported retention values per object type, edition and legal recovery need, with measured storage impact.
B:Time Travel retention limits vary by table class and edition, and historical storage contributes to cost. Evidence: Inspect effective retention parameters and attempt a safe as-of query at an approved timestamp.
Incorrect Answers
C:Check: Inspect database-role grants, parent account-role membership and a permitted SELECT using the active account role. Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
D:Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles. Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
E:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
Question 491
A Snowflake engineer is examining this platform situation: A team assumes a cloned schema in the primary region will remain accessible if that region becomes unavailable. A proposed shortcut is: Claim a same-region clone is sufficient backup for a complete cloud-region outage. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Set supported retention values per object type, edition and legal recovery need, with measured storage impact.
- Define appropriate FUTURE grants on the intended database or schema in addition to any existing-object grants.
- Claim a same-region clone is sufficient backup for a complete cloud-region outage.
- Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
Explanation
Correct Answer
D:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Set supported retention values per object type, edition and legal recovery need, with measured storage impact. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Define appropriate FUTURE grants on the intended database or schema in addition to any existing-object grants. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 492
A Snowflake implementation review finds: A team assumes a cloned schema in the primary region will remain accessible if that region becomes unavailable. The team proposes: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Database roles are scoped to their database and cannot be activated directly as session primary roles; account roles can inherit them.
- Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
- Snowflake authentication policies can constrain permitted methods and clients independently of RBAC privileges.
- Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Explanation
Correct Answer
D:Demonstrable success requires: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives. This principle explains the proposed technical approach, which is: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
Incorrect Answers
A:Database roles are scoped to their database and cannot be activated directly as session primary roles; account roles can inherit them. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Time Travel retention limits vary by table class and edition, and historical storage contributes to cost. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Snowflake authentication policies can constrain permitted methods and clients independently of RBAC privileges. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 493
The data platform team has not yet approved changes. Current evidence indicates: A team assumes a cloned schema in the primary region will remain accessible if that region becomes unavailable. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Query the same protected column under authorized and limited roles and review masking-policy bindings.
- Test selected ACCOUNT_USAGE views under a read-only audit role and verify available columns and latency.
- Inspect replication group membership, refresh history, secondary object state and controlled cutover scenarios.
- Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage.
Explanation
Correct Answer
C:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Confirm afterward that: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
Incorrect Answers
A:Query the same protected column under authorized and limited roles and review masking-policy bindings. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Test selected ACCOUNT_USAGE views under a read-only audit role and verify available columns and latency. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
D:Inspect assigned warehouse monitor, thresholds, triggered actions and other service meter usage. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 494
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A team assumes a cloned schema in the primary region will remain accessible if that region becomes unavailable. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- The approved bucket is reachable without exposing personal credentials or unrelated cloud paths.
- Intended users can perform only authorized operations, and the privilege chain is auditable.
- Dataset sharing requires the designated governance authority instead of arbitrary table-owner discretion.
- Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
Explanation
Correct Answer
D:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:The approved bucket is reachable without exposing personal credentials or unrelated cloud paths. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Intended users can perform only authorized operations, and the privilege chain is auditable. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Dataset sharing requires the designated governance authority instead of arbitrary table-owner discretion. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 495
An implementation sign-off request identifies the following problem: A team assumes a cloned schema in the primary region will remain accessible if that region becomes unavailable. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles. Verify: Inspect SHOW GRANTS, role hierarchy and active session role for the target object and user.
- Change: Define database roles for database object permissions, then grant them to an account role users can activate. Verify: Inspect database-role grants, parent account-role membership and a permitted SELECT using the active account role.
- Change: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures. Verify: Inspect replication group membership, refresh history, secondary object state and controlled cutover scenarios.
- Change: Use a managed access schema and delegate grant decisions to the schema owner or a role with MANAGE GRANTS. Verify: Check schema type, object ownership and whether the correct role can GRANT SELECT in a controlled test.
Explanation
Correct Answer
C:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. The change is successful only when: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
Incorrect Answers
A:Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Change: Define database roles for database object permissions, then grant them to an account role users can activate. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
D:Change: Use a managed access schema and delegate grant decisions to the schema owner or a role with MANAGE GRANTS. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 496
A Snowflake engineer is examining this platform situation: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover. A proposed shortcut is: Claim a same-region clone is sufficient backup for a complete cloud-region outage. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Claim a same-region clone is sufficient backup for a complete cloud-region outage.
- Use a dedicated least-privilege service user with supported key-pair or workload-identity authentication and documented rotation.
- Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
- Use governed object tags, supported classification methods and appropriate tag-based policy integration.
Explanation
Correct Answer
C:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Applied case: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover.
Incorrect Answers
A:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Use this instead: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
B:Use a dedicated least-privilege service user with supported key-pair or workload-identity authentication and documented rotation. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
D:Use governed object tags, supported classification methods and appropriate tag-based policy integration. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 497
A Snowflake implementation review finds: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover. The team proposes: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Reading a table normally requires privileges on its containing database and schema as well as SELECT on the table; warehouse USAGE is separate.
- Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
- Time Travel retention limits vary by table class and edition, and historical storage contributes to cost.
- Identity federation centralizes authentication while Snowflake role authorization remains a separate explicit layer.
Explanation
Correct Answer
B:Demonstrable success requires: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives. Applied case: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover.
Incorrect Answers
A:Reading a table normally requires privileges on its containing database and schema as well as SELECT on the table; warehouse USAGE is separate. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Time Travel retention limits vary by table class and edition, and historical storage contributes to cost. A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover.
D:Identity federation centralizes authentication while Snowflake role authorization remains a separate explicit layer. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 498
The data platform team has not yet approved changes. Current evidence indicates: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Test IdP login, MFA challenge, disabled account behavior and effective role mapping.
- Record source IP addresses, policy precedence, login failures and emergency recovery path under safe testing.
- Check SHOW GRANTS for database, schema, table and selected warehouse on the active role.
- Inspect replication group membership, refresh history, secondary object state and controlled cutover scenarios.
Explanation
Correct Answer
D:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Test IdP login, MFA challenge, disabled account behavior and effective role mapping. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
B:Record source IP addresses, policy precedence, login failures and emergency recovery path under safe testing. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Check SHOW GRANTS for database, schema, table and selected warehouse on the active role. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
Question 499
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
- Auditors obtain the required evidence without permanent global account administration.
- Authorized roles receive appropriate values while other users see safe masked representations.
- Dataset sharing requires the designated governance authority instead of arbitrary table-owner discretion.
Explanation
Correct Answer
A:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. The approved implementation step was: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
Incorrect Answers
B:Auditors obtain the required evidence without permanent global account administration. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Authorized roles receive appropriate values while other users see safe masked representations. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
D:Dataset sharing requires the designated governance authority instead of arbitrary table-owner discretion. A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover.
Question 500
For an original SnowPro Core educational scenario, consider: A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover. Select THREE compatible elements: a proper correction, a targeted diagnostic and an acceptance result.
- Result: Auditors can identify relevant usage and downstream dependencies without granting ordinary analysts privileged raw audit access.
- Change: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
- Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles.
- Check: Inspect replication group membership, refresh history, secondary object state and controlled cutover scenarios.
- Result: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
- Check: Compare ownership and dependent grants before and after transfer using SHOW GRANTS.
Explanation
Correct Answer
B:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Acceptance: Recovery regions receive permitted objects and users can resume using the planned endpoint within agreed objectives.
D:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Required intervention: Configure supported database or failover group replication with tested refresh, permissions and secondary-region activation procedures.
E:Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery. Evidence: Inspect replication group membership, refresh history, secondary object state and controlled cutover scenarios.
Incorrect Answers
A:Result: Auditors can identify relevant usage and downstream dependencies without granting ordinary analysts privileged raw audit access. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
C:Change: Create least-privilege custom roles with explicit object grants and appropriate parent-role inheritance instead of using broad system roles. A customer needs account objects and permitted data recoverable in another region but has not established replication or client cutover.
F:Check: Compare ownership and dependent grants before and after transfer using SHOW GRANTS. Cross-region recovery requires explicitly configured replication and failover; local zero-copy cloning is not geographic disaster recovery.
