Snowflake SnowPro Core Practice Test 99
Question 980
For an original SnowPro Core educational scenario, consider: A vendor removes a consumer account from a share but assumes the old imported database remains fully queryable forever. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- Check: Compare share membership before and after removal, attempt a consumer query and inspect surviving provider data.
- Change: Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
- Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
- Delete the entire production source database to revoke one subscriber's permission.
Explanation
Correct Answer
B:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. Required intervention: Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
C:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. Acceptance: The former subscriber loses access while authorized subscribers and the original dataset remain available.
Incorrect Answers
A:Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
D:Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source.
E:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source.
Question 981
A Snowflake engineer is examining this platform situation: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace. A proposed shortcut is: Publish every consortium dataset publicly because data sharing requires the open Marketplace. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
- Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
- Publish every consortium dataset publicly because data sharing requires the open Marketplace.
- Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
Explanation
Correct Answer
B:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Applied case: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace.
Incorrect Answers
A:Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
C:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
D:Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 982
A Snowflake implementation review finds: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace. The team proposes: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
- Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
- Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
- Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
Explanation
Correct Answer
A:Demonstrable success requires: Authorized members discover and consume the right products while outsiders cannot browse restricted data. Applied case: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace.
Incorrect Answers
B:This option addresses a different Snowflake technical topic (Reader accounts and cost ownership) rather than the documented Private Data Exchanges and governed distribution decision.
C:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
D:Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 983
The data platform team has not yet approved changes. Current evidence indicates: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
- Compare share grants, authorized account identifiers and consumer database results after a controlled provider update.
- Review membership, listing access settings, user request flow and a nonmember denial test.
- Inspect the listing's visibility, provider profile, consumer eligibility and sample subscription or request flow.
Explanation
Correct Answer
C:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Confirm afterward that: Authorized members discover and consume the right products while outsiders cannot browse restricted data.
Incorrect Answers
A:Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
B:Compare share grants, authorized account identifiers and consumer database results after a controlled provider update. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
D:Inspect the listing's visibility, provider profile, consumer eligibility and sample subscription or request flow. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 984
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace. 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.
- Only intended objects are visible through the share and privilege gaps are resolved safely.
- Intended audiences can find and consume the described data product under configured terms.
- Consumers see authorized current records while the provider controls membership and original data.
- Authorized members discover and consume the right products while outsiders cannot browse restricted data.
Explanation
Correct Answer
D:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Only intended objects are visible through the share and privilege gaps are resolved safely. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
B:Intended audiences can find and consume the described data product under configured terms. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
C:Consumers see authorized current records while the provider controls membership and original data. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 985
An implementation sign-off request identifies the following problem: A consortium wants to offer nonpublic datasets only to its verified member organizations rather than the public Marketplace. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Grant appropriate database, schema and object privileges to the share or grant a scoped database role to the share. Verify: Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account.
- Change: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Verify: Review membership, listing access settings, user request flow and a nonmember denial test.
- Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Verify: Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
- Change: Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. Verify: Compare share membership before and after removal, attempt a consumer query and inspect surviving provider data.
Explanation
Correct Answer
B:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. The change is successful only when: Authorized members discover and consume the right products while outsiders cannot browse restricted data.
Incorrect Answers
A:Change: Grant appropriate database, schema and object privileges to the share or grant a scoped database role to the share. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
C:Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
D:Change: Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 986
A Snowflake engineer is examining this platform situation: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products. A proposed shortcut is: Publish every consortium dataset publicly because data sharing requires the open Marketplace. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Publish every consortium dataset publicly because data sharing requires the open Marketplace.
- Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints.
- Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
- Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
Explanation
Correct Answer
D:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Applied case: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
Incorrect Answers
A:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Use this instead: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
B:Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
C:Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
Question 987
A Snowflake implementation review finds: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products. The team proposes: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Sharing within a region differs from replicated fulfillment across geographic or cloud boundaries; data movement and control requirements apply.
- Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
- Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
- Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source.
Explanation
Correct Answer
C:Demonstrable success requires: Authorized members discover and consume the right products while outsiders cannot browse restricted data. Applied case: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
Incorrect Answers
A:Sharing within a region differs from replicated fulfillment across geographic or cloud boundaries; data movement and control requirements apply. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
B:Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information. A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
D:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 988
The data platform team has not yet approved changes. Current evidence indicates: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure.
- Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account.
- Review membership, listing access settings, user request flow and a nonmember denial test.
- Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
Explanation
Correct Answer
C:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
B:Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
D:Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes. A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
Question 989
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products. 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.
- Only intended objects are visible through the share and privilege gaps are resolved safely.
- Consumers see authorized current records while the provider controls membership and original data.
- Each partner receives only its authorized subset without revealing internal sensitive columns.
- Authorized members discover and consume the right products while outsiders cannot browse restricted data.
Explanation
Correct Answer
D:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. The approved implementation step was: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
Incorrect Answers
A:Only intended objects are visible through the share and privilege gaps are resolved safely. A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
B:Consumers see authorized current records while the provider controls membership and original data. A hospital network needs a curated catalog and controlled membership before its affiliates discover data products.
C:Each partner receives only its authorized subset without revealing internal sensitive columns. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Question 990
For an original SnowPro Core educational scenario, consider: A hospital network needs a curated catalog and controlled membership before its affiliates discover data products. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
- Change: Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls.
- Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- Publish every consortium dataset publicly because data sharing requires the open Marketplace.
- Check: Review membership, listing access settings, user request flow and a nonmember denial test.
Explanation
Correct Answer
A:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Acceptance: Authorized members discover and consume the right products while outsiders cannot browse restricted data.
E:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Required intervention: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
Incorrect Answers
B:Change: Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
C:Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
D:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.