Snowflake SnowPro Core Practice Test 94
Question 930
For an original SnowPro Core educational scenario, consider: A marketplace publisher wants to hide proprietary transformation logic while exposing a curated aggregate view. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
- Change: Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported.
- Share the entire base table and tell consumers not to query other suppliers' rows.
- Check: Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure.
- Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
Explanation
Correct Answer
B:Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information. Acceptance: Each partner receives only its authorized subset without revealing internal sensitive columns.
D:Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information. Required intervention: Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported.
Incorrect Answers
A:Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
E:Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests. Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
Question 931
A Snowflake engineer is examining this platform situation: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription. A proposed shortcut is: Treat a reader account as a fully independent data engineering account with unlimited provider-free compute. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls.
- Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
- Treat a reader account as a fully independent data engineering account with unlimited provider-free compute.
- Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Explanation
Correct Answer
D:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Applied case: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription.
Incorrect Answers
A:Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
B:Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
C:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 932
A Snowflake implementation review finds: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription. The team proposes: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns.
- 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.
- Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only.
Explanation
Correct Answer
C:Demonstrable success requires: The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider. This principle explains the proposed technical approach, which is: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Incorrect Answers
A:Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
B: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.
D:Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 933
The data platform team has not yet approved changes. Current evidence indicates: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account.
- Compare share grants, authorized account identifiers and consumer database results after a controlled provider update.
- Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
- Review supported fulfillment region selections, refresh status, provider costs and consumer availability.
Explanation
Correct Answer
C:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. If confirmed, the proportionate intervention is: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Incorrect Answers
A:Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
B:Compare share grants, authorized account identifiers and consumer database results after a controlled provider update. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
D:Review supported fulfillment region selections, refresh status, provider costs and consumer availability. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 934
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription. 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 recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
- Each partner receives only its authorized subset without revealing internal sensitive columns.
- Consumers see authorized current records while the provider controls membership and original data.
- Approved remote consumers can access a refreshed dataset in their region with documented latency and controls.
Explanation
Correct Answer
A:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. The approved implementation step was: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Incorrect Answers
B:Each partner receives only its authorized subset without revealing internal sensitive columns. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
C:Consumers see authorized current records while the provider controls membership and original data. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
D:Approved remote consumers can access a refreshed dataset in their region with documented latency and controls. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 935
An implementation sign-off request identifies the following problem: A startup customer needs query-only access to a data provider's published metrics but does not have its own Snowflake subscription. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Verify: Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
- Change: Create and configure an authorized direct share with only intended database objects for the permitted consumer account. Verify: Compare share grants, authorized account identifiers and consumer database results after a controlled provider update.
- 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: 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
A:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. The change is successful only when: The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
Incorrect Answers
B:Change: Create and configure an authorized direct share with only intended database objects for the permitted consumer account. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
C:Change: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
D:This option addresses a different Snowflake technical topic (Revocation and share lifecycle) rather than the documented Reader accounts and cost ownership decision.
Question 936
A Snowflake engineer is examining this platform situation: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account. A proposed shortcut is: Treat a reader account as a fully independent data engineering account with unlimited provider-free compute. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported.
- Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
- Treat a reader account as a fully independent data engineering account with unlimited provider-free compute.
- Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints.
Explanation
Correct Answer
B:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Applied case: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
Incorrect Answers
A:Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
C:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Use this instead: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
D:Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 937
A Snowflake implementation review finds: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account. The team proposes: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only.
- Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns.
- Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
- Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Explanation
Correct Answer
D:Demonstrable success requires: The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider. Applied case: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
Incorrect Answers
A:Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only. A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
B:Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns. A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
C:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 938
The data platform team has not yet approved changes. Current evidence indicates: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Review membership, listing access settings, user request flow and a nonmember denial test.
- Compare share grants, authorized account identifiers and consumer database results after a controlled provider update.
- Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure.
- Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
Explanation
Correct Answer
D:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Confirm afterward that: The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
Incorrect Answers
A:Review membership, listing access settings, user request flow and a nonmember denial test. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
B:Compare share grants, authorized account identifiers and consumer database results after a controlled provider update. A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
C:Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
Question 939
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account. 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 recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
- Approved remote consumers can access a refreshed dataset in their region with documented latency and controls.
- 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.
Explanation
Correct Answer
A:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. The result must be validated using the documented dataset or access context.
Incorrect Answers
B:Approved remote consumers can access a refreshed dataset in their region with documented latency and controls. A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
C:Only intended objects are visible through the share and privilege gaps are resolved safely. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
D:Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Question 940
For an original SnowPro Core educational scenario, consider: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
- Check: Compare share grants, authorized account identifiers and consumer database results after a controlled provider update.
- Treat a reader account as a fully independent data engineering account with unlimited provider-free compute.
- Check: Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
- Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
Explanation
Correct Answer
A:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Acceptance: The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
D:Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage. Required intervention: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
Incorrect Answers
B:Applied case: A provider creates a reader account and assumes the recipient pays all warehouse credits generated in that account.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.
E:Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Reader accounts permit consumers without Snowflake accounts to query provider shares, but the provider manages and pays for reader account warehouse usage.