Snowflake Exam DEA-C01 Topic 2 Question 35 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 35
Topic #: 2

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?

ASNOWFLAKE - DATA_SHARING _USAGE - LISTING_EVENTS_BAILY

BSNOWFLAKE.DATA_ SHARING _USAGE.LISTING_CONSOKE>TION_DAILY

CSNOWFLAKE. DATA_SHARING_USAGE. LISTING_TELEMETRY_DAILy

DSNOWFLAKE.ACCOUNT_USAGE.DATA _TRANSFER_HISTORY

Show Suggested Answer

Suggested Answer: B

The SNOWFLAKE.DATASHARING _USAGE.LISTING_CONSOKE>TION_DAILY view provides information about consumer requests by region for each of the Data Exchange offerings annually, as well as click-through rates for each listing. This view is the minimal data source needed for building the reporting tables. The other views are not relevant for this use case.

by Dominque at Sep 17, 2024, 11:41 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lilli

19 days ago

I'm not sure about view D. It seems unrelated to the analysis we need to do.

upvoted 0 times

...

Bo

19 days ago

This is a tough one, but I reckon option A might be the way to go. The Data Sharing Usage view should give us the big picture, and we can dig into the details from there.

upvoted 0 times

...

Staci

20 days ago

I agree with Tashia. Those views cover consumer requests and click-through rates.

upvoted 0 times

...

1 months ago

I think we need views A, B, and C as data sources.

upvoted 0 times

...