SnowPro Advanced: Data Engineer — Question 59

A Data Engineer is building a set of reporting tables to analyze consumer requests by region for each of the Data Exchange offerings annually, as well as click-through rates for each listing.
Which views are needed MINIMALLY as data sources?

Answer options

• A. SNOWFLAKE.DATA_SHARING_USAGE.LISTING_EVENTS_DAILY
• B. SNOWFLAKE.DATA_SHARING_USAGE.LISTING_CONSUMPTION_DAILY
• C. SNOWFLAKE.DATA_SHARING_USAGE.LISTING_TELEMETRY_DAILY
• D. SNOWFLAKE.ACCOUNT_USAGE.DATA_TRANSFER_HISTORY

Correct answer: B, C

Explanation

The correct options B and C provide the necessary data for analyzing consumer requests and click-through rates. Option A focuses on events rather than consumption or telemetry, and Option D pertains to account-level data transfer history, which is not directly relevant for the specific consumer request analysis.