Use the Snowflake Marketplace COF-C03 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   After a provider grants access to a listing, how does the consumer use the data?

   • ABy querying the shared database directly from their Snowflake account.
   • BBy downloading a CSV file from the Marketplace UI.
   • CBy waiting for the provider to send the data via email.
   • DBy copying the data into their own storage using a third-party tool.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which statement is true about private listings in the Snowflake Marketplace?

   • AThey are automatically deleted after a certain period.
   • BThey are visible only to accounts that the provider explicitly shares them with.
   • CThey are only available to accounts in the same cloud region.
   • DThey are visible to all users but require a special request to access.
   Reveal Solution Discussion Select an answer first
4. 18expert · medium

   A large enterprise is both a consumer and a provider on the Snowflake Marketplace. As a provider, the enterprise shares a dataset with a partner. The partner reports that they can see the database but cannot query the tables. The enterprise's account administrator checks the share and confirms it is active. What is the most likely reason the partner cannot query the data?

   • AThe partner's warehouse is in a different region than the shared data.
   • BThe enterprise's provider role does not have the OWNERSHIP privilege on the shared tables.
   • CThe partner's account administrator has not granted the necessary privileges on the shared database to the partner's querying roles.
   • DThe enterprise has not enabled the 'Allow Consumer to Query' option on the share.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A data provider wants to publish a dataset to the Snowflake Marketplace so that any Snowflake customer can browse and access it without needing a direct relationship with the provider. The provider wants to ensure that the data is not copied and that consumers always see the latest updates. Which approach should the provider take?

   • AExport the data to a cloud storage bucket and provide a signed URL in the listing.
   • BCreate a private listing and manually share it with every Snowflake customer.
   • CUse the Snowflake Data Exchange to publish the data, which automatically creates a share for all consumers.
   • DCreate a public listing that uses a Snowflake share to provide read-only access to the underlying tables.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A data analyst has been using a free public listing from the Snowflake Marketplace for several months. The analyst notices that the data in the shared tables has changed, and the analyst wants to understand how often the data is updated. Where should the analyst look for this information?

   • AThe account usage views in the Snowflake UI, which show the last DDL change on the shared tables.
   • BThe query history in the Snowflake UI, which shows when the data was last queried.
   • CThe listing's detail page on the Snowflake Marketplace, which may include a description of the update frequency.
   • DThe provider's billing statement, which shows the date of the last data refresh.
   Reveal Solution Discussion Select an answer first