ADA-C01 practice question 9 of 10

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

Full set: 75 questions

Domain Snowflake Security and Role-Based Access Control (RBAC)

Answer options
A: Dropping a column from a table Correct answer
B: Deleting data from a table
C: Unpublishing the data listing
D: Renaming a table Correct answer
E: Adding region availability to the listing
Correct Answer:
A. Dropping a column from a table; D. Renaming a table
Explanation

In the context of the Snowflake Marketplace, a "breaking change" is a modification to the shared data objects that is likely to cause existing consumer queries or applications to fail. Dropping a column from a shared table (A) is a breaking change because any consumer query that explicitly references that column will fail. Similarly, renaming a table (D) is a breaking change because all queries referencing the original table name will no longer find the object and will fail. These actions alter the data's schema or object identifiers, which consumer code depends on.

Why Incorrect

B. Deleting data from a table: This is a data content change, not a structural or schema change. Consumer queries will still execute successfully, though they will return different results.
C. Unpublishing the data listing: Unpublishing a listing prevents new consumers from accessing the data but does not affect existing consumers who have already established access to the share.
E. Adding region availability to the listing: This is an enhancement that expands access to new regions. It is an additive, non-breaking change that has no impact on existing consumers.

References

1. Snowflake Documentation: Updating a Listing

Reference: Under the section "Updating a Listing

" the documentation explicitly warns providers to "Avoid making the following changes to objects in a share

because they can break consumer applications that rely on the share:" and lists "Dropping a column from a shared table or view" and "Renaming a shared table or view." This directly supports answers A and D.

2. Snowflake Documentation: Unpublishing a Listing

Reference: This page states

"When you unpublish a listing

it is no longer visible on the Snowflake Marketplace and new consumers cannot access it. Existing consumers who have already gotten the data from the listing are not affected." This directly refutes option C as a breaking change for existing consumers.

Scroll to Top