Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 63 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 63
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

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
  • D. SNOWFLAKE.ACCOUNT_USAGE.DATA_TRANSFER_HISTORY
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Sibaprasad
1 month, 2 weeks ago
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
upvoted 1 times
...
BigDataBB
10 months ago
Selected Answer: B
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
upvoted 1 times
...
prshntdxt7
10 months, 1 week ago
Selected Answer: BC
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.
upvoted 1 times
...
stopthisnow
1 year ago
Selected Answer: BC
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
upvoted 2 times
...
Snow_P
1 year ago
Selected Answer: BC
For sure C but I am wondering between A & B. Overall I think B&C
upvoted 3 times
...
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.

SaveCancel
Loading ...