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?
A.
SNOWFLAKE.DATA_SHARING_USAGE.LISTING_EVENTS_DAILY
B.
SNOWFLAKE.DATA_SHARING_USAGE.LISTING_CONSUMPTION_DAILY
C.
SNOWFLAKE.DATA_SHARING_USAGE.LISTING_TELEMETRY_DAILY
Correct Answer is AC.
Check https://docs.snowflake.com/en/sql-reference/data-sharing-usage/listing-events-daily and https://docs.snowflake.com/en/sql-reference/data-sharing-usage/listing-telemetry-daily
Telemetry Daily EVENT_TYPE has LISTING CLICK
Events Daily EVENT_TYPE has REQUEST
In LISTING_CONSUMPTION_DAILY there is the column SNOWFLAKE_REGION, so this is the necessart view: https://docs.snowflake.com/en/sql-reference/data-sharing-usage/listing-consumption-daily
The minimal data sources needed for analyzing consumer requests by region for each Data Exchange offering annually, as well as click-through rates for each listing, would likely include:
B. SNOWFLAKE.DATA_SHARING_USAGE.LISTING_CONSUMPTION_DAILY
C. SNOWFLAKE.DATA_SHARING_USAGE.LISTING_TELEMETRY_DAILY
These two tables provide information related to listing consumption and telemetry, which are crucial for understanding consumer requests and click-through rates for each listing. The other options (A and D) seem less relevant to the specific requirements mentioned.
A looks wrong. It gives info about installations and permission, not consumption.
https://docs.snowflake.com/en/sql-reference/data-sharing-usage/listing-events-daily
For sure C but I am wondering between A & B. Overall I think B&C
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sibaprasad
1 month, 2 weeks agoBigDataBB
10 months agoprshntdxt7
10 months, 1 week agostopthisnow
1 year agoSnow_P
1 year ago