Snowflake SnowPro Core Practice Test 95
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.
Question 941
A Snowflake engineer is examining this platform situation: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database. A proposed shortcut is: Attempt to clone or directly update the provider's imported shared table as though it were locally owned. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
- Create and configure an authorized direct share with only intended database objects for the permitted consumer account.
- Attempt to clone or directly update the provider's imported shared table as though it were locally owned.
- Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
Explanation
Correct Answer
D:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Applied case: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database.
Incorrect Answers
A:Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
B:Create and configure an authorized direct share with only intended database objects for the permitted consumer account. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 942
A Snowflake implementation review finds: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database. The team proposes: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. 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.
- Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only.
- Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
- 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 analysts read the shared data while modifying the provider's source remains disallowed. Applied case: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Cross-region listing fulfillment) rather than the documented Consumer imported database privileges decision.
B:Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 943
The data platform team has not yet approved changes. Current evidence indicates: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database. 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.
- 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.
- Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
Explanation
Correct Answer
A:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Confirm afterward that: Authorized analysts read the shared data while modifying the provider's source remains disallowed.
Incorrect Answers
B:Review membership, listing access settings, user request flow and a nonmember denial test. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:Compare share grants, authorized account identifiers and consumer database results after a controlled provider update. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 944
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database. 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.
- Authorized members discover and consume the right products while outsiders cannot browse restricted data.
- Authorized analysts read the shared data while modifying the provider's source remains disallowed.
- 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
B:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Authorized members discover and consume the right products while outsiders cannot browse restricted data. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:Only intended objects are visible through the share and privilege gaps are resolved safely. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Consumers see authorized current records while the provider controls membership and original data. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 945
An implementation sign-off request identifies the following problem: A data provider lists a share for a customer, but an analyst in the consumer account cannot access the imported database. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- 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.
- Change: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements. Verify: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- 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 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.
Explanation
Correct Answer
D:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. The change is successful only when: Authorized analysts read the shared data while modifying the provider's source remains disallowed.
Incorrect Answers
A:Change: Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
B:Change: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 946
A Snowflake engineer is examining this platform situation: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error. A proposed shortcut is: Attempt to clone or directly update the provider's imported shared table as though it were locally owned. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
- Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient.
- Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
- Attempt to clone or directly update the provider's imported shared table as though it were locally owned.
Explanation
Correct Answer
C:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Applied case: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error.
Incorrect Answers
A:Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
B:Remove unauthorized consumer accounts or grants from the share and validate loss of access with the recipient. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Use this instead: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
Question 947
A Snowflake implementation review finds: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error. The team proposes: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. 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.
- Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information.
- Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
- Private exchange models support curated distribution to a defined audience while public listings serve broader discovery.
Explanation
Correct Answer
C:Demonstrable success requires: Authorized analysts read the shared data while modifying the provider's source remains disallowed. Applied case: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error.
Incorrect Answers
A:Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns. This option addresses a different Snowflake technical topic (Share grants and database roles) rather than the documented Consumer imported database privileges decision. The case-specific mechanism is: Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. The relevant action is: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles. Discriminating evidence: Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes. Applied case: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error.
B:Secure views can help protect underlying logic and enforce a carefully designed shared projection; ordinary raw-table sharing may expose extra information. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 948
The data platform team has not yet approved changes. Current evidence indicates: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error. 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.
- Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
- 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
B:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
D:Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations. An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error.
Question 949
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error. 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.
- Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
- Intended audiences can find and consume the described data product under configured terms.
- The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
- Authorized analysts read the shared data while modifying the provider's source remains disallowed.
Explanation
Correct Answer
D:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. The approved implementation step was: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
Incorrect Answers
A:Partners receive only authorized aggregate insights without unnecessary raw record disclosure. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
B:Intended audiences can find and consume the described data product under configured terms. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
C:The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
Question 950
For an original SnowPro Core educational scenario, consider: An engineer attempts to UPDATE a shared table to correct a record in the consumer account and gets a read-only error. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Attempt to clone or directly update the provider's imported shared table as though it were locally owned.
- Change: Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported.
- Check: Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
- Change: Create a database FROM SHARE and grant supported IMPORTED PRIVILEGES or shared database roles to designated consumer account roles.
- Check: Compare share membership before and after removal, attempt a consumer query and inspect surviving provider data.
Explanation
Correct Answer
C:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Acceptance: Authorized analysts read the shared data while modifying the provider's source remains disallowed.
D:Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants. Evidence: Test CREATE DATABASE FROM SHARE, role access to a sample table and attempted writes.
Incorrect Answers
A:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
B:Change: Create and test suitable secure views with correct row and column projection plus consumer-specific filtering where supported. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
E:Check: Compare share membership before and after removal, attempt a consumer query and inspect surviving provider data. Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
