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 questionsDomain Snowflake Security and Role-Based Access Control (RBAC)
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.
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.
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.
Keep practicing
Take the free ADA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ADA-C01 practice questions
- Question 1A Snowflake Administrator wants to create a virtual warehouse that supports several dashb…
- Question 2A requirement has been identified to allow members of a corporate Data Product team to br…
- Question 3What is required for stages, without credentials, to limit data exfiltration after a stor…
- Question 4Which function is the role SECURITYADMIN responsible for that is not granted to role USER…
- Question 5For Snowflake network policies, what will occur when the account_level and user_level net…
- Question 6In which scenario will use of an external table simplify a data pipeline?
