Snowflake SnowPro Core Practice Test 100
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.
Question 991
A Snowflake engineer is examining this platform situation: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other. A proposed shortcut is: Export all participants' customer identifiers to a shared public table to simplify overlap analytics. 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 an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
- Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits.
- Export all participants' customer identifiers to a shared public table to simplify overlap analytics.
Explanation
Correct Answer
B:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Applied case: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other.
Incorrect Answers
A:Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
C:Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
D:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 992
A Snowflake implementation review finds: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other. The team proposes: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Imported shared databases are read-only and their access is managed through imported privileges or shared database-role grants.
- Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
- Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns.
- Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source.
Explanation
Correct Answer
B:Relevant validation before approval: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests. Applied case: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Consumer imported database privileges) rather than the documented Privacy-safe collaboration and clean rooms decision.
C:Shared objects require valid provider-side grants and can be grouped through supported database-role sharing patterns. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
D:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 993
The data platform team has not yet approved changes. Current evidence indicates: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other. 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 allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
Explanation
Correct Answer
C:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Confirm afterward that: Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
Incorrect Answers
A:Review SHOW GRANTS TO SHARE, database-role assignments and consumer-visible objects with a test account. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
B:Compare share grants, authorized account identifiers and consumer database results after a controlled provider update. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
D:Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 994
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other. 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.
- Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
- Each partner receives only its authorized subset without revealing internal sensitive columns.
- Approved remote consumers can access a refreshed dataset in their region with documented latency and controls.
Explanation
Correct Answer
B:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. 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. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
C:Each partner receives only its authorized subset without revealing internal sensitive columns. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
D:Approved remote consumers can access a refreshed dataset in their region with documented latency and controls. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 995
An implementation sign-off request identifies the following problem: Two retailers want an overlapping-customer aggregate but cannot legally disclose full raw loyalty records to each other. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints. Verify: Review supported fulfillment region selections, refresh status, provider costs and consumer availability.
- 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 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.
Explanation
Correct Answer
D:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. The change is successful only when: Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
Incorrect Answers
A:Change: Configure supported cross-region or cross-cloud listing fulfillment and examine replication, cost and availability constraints. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
B:Change: Provision a governed reader account and share suitable data while monitoring the provider-funded compute and usage limits. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
C:Change: Create and configure an authorized direct share with only intended database objects for the permitted consumer account. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 996
A Snowflake engineer is examining this platform situation: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations. A proposed shortcut is: Export all participants' customer identifiers to a shared public table to simplify overlap analytics. 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.
- Export all participants' customer identifiers to a shared public table to simplify overlap analytics.
- Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
Explanation
Correct Answer
D:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Use a supported Snowflake listing with appropriate discoverability, metadata, availability and consumer access controls. A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations.
B:Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
C:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Use this instead: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
Question 997
A Snowflake implementation review finds: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations. The team proposes: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements. 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.
- Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source.
- 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.
Explanation
Correct Answer
C:Relevant validation before approval: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests. Demonstrable success requires: Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
Incorrect Answers
A:Snowflake Secure Data Sharing can expose provider-managed current data without copying it, and consumer access is read-only. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
B:Provider control includes revocation; removing a consumer can invalidate access to its imported database without deleting the provider's source. A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations.
D:Private exchange models support curated distribution to a defined audience while public listings serve broader discovery. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 998
The data platform team has not yet approved changes. Current evidence indicates: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations. 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 supported fulfillment region selections, refresh status, provider costs and consumer availability.
- Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations.
Explanation
Correct Answer
C:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Applied case: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations.
Incorrect Answers
A:Use representative simulated consumer context or controlled subscriber tests to verify row filters and column exposure. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
B:Review supported fulfillment region selections, refresh status, provider costs and consumer availability. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
D:Inspect reader account provisioning, attached shares, warehouse credit consumption and restrictions on write operations. A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations.
Question 999
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations. 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.
- Approved remote consumers can access a refreshed dataset in their region with documented latency and controls.
- The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider.
- Consumers see authorized current records while the provider controls membership and original data.
- Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
Explanation
Correct Answer
D:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. The approved implementation step was: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
Incorrect Answers
A:Approved remote consumers can access a refreshed dataset in their region with documented latency and controls. A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations.
B:The recipient can query approved datasets without a separate Snowflake account and costs are controlled by the provider. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
C:Consumers see authorized current records while the provider controls membership and original data. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
Question 1000
For an original SnowPro Core educational scenario, consider: A marketing team intends to join sensitive partner datasets and publish row-level identifiers from both organizations. Select THREE compatible elements: a proper correction, a targeted diagnostic and an acceptance result.
- Change: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
- Result: Approved remote consumers can access a refreshed dataset in their region with documented latency and controls.
- Result: Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
- Check: Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
- Check: Inspect the listing's visibility, provider profile, consumer eligibility and sample subscription or request flow.
- Change: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope.
Explanation
Correct Answer
A:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Acceptance: Partners receive only authorized aggregate insights without unnecessary raw record disclosure.
C:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Required intervention: Evaluate an approved Snowflake clean room or governed collaboration workflow with restricted query templates, join controls and aggregate privacy requirements.
D:Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs. Inspect allowed queries, match-key protections, minimum group thresholds and sample privacy-leakage tests.
Incorrect Answers
B:Result: Approved remote consumers can access a refreshed dataset in their region with documented latency and controls. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
E:Check: Inspect the listing's visibility, provider profile, consumer eligibility and sample subscription or request flow. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
F:Change: Evaluate a private Data Exchange or private listings with approved membership, governance and provider data scope. Clean room collaboration is designed to support permitted analytics while controlling access to underlying participant data and query outputs.
