Answer: SYSTEM$IS_LISTING_PURCHASED

The question asks about a system function that manages access to data in a share and restricts visibility to paying customers. SYSTEM$IS_LISTING_PURCHASED (option D) is specifically designed for this purpose in Snowflake's data sharing ecosystem. It allows providers to check if a consumer has purchased a paid listing, enabling conditional access control to shared data based on payment status. The community discussion confirms this with 100% consensus on D, supported by upvoted comments referencing Snowflake documentation on preparing shares for paid listings. Options A, B, and C are incorrect: SYSTEM$ALLOWLIST manages network policies, SYSTEM$ALLOWLIST_PRIVATELINK handles private link configurations, and SYSTEM$AUTHORIZE_PRIVATELINK authorizes private link endpoints—none relate to payment-based data access control in shares.

Author: LeetQuiz Editorial Team