COF-C03 practice question 4 of 10

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

Full set: 1,126 questions
Answer options
A: ACCESS_HISTORY
B: DATA_TRANSFER_HISTORY
C: WAREHOUSE_METERING_HISTORY
D: MONETIZED_USAGE_DAILY Correct answer
E: LISTING TELEMETRY DAILY Correct answer
Correct Answer:
D. MONETIZED_USAGE_DAILY; E. LISTING TELEMETRY DAILY
Explanation

The DATASHARINGUSAGE schema, part of the shared SNOWFLAKE database, contains views specifically for providers who share data through listings, particularly on the Snowflake Marketplace. The MONETIZEDUSAGEDAILY view provides daily usage details for paid listings, helping providers track consumption against their pricing plans. The LISTINGTELEMETRYDAILY view offers telemetry data, such as query counts and execution times on a listing, giving providers insight into how consumers are interacting with their shared data.

Why Incorrect

A. The ACCESSHISTORY view is located in the ACCOUNTUSAGE schema and tracks object access across the entire account.
B. The DATATRANSFERHISTORY view is located in the ACCOUNTUSAGE schema and tracks data transfer costs.
C. The WAREHOUSEMETERINGHISTORY view is located in the ACCOUNTUSAGE schema and tracks warehouse credit consumption.

References

- Snowflake Documentation. (n.d.). DATASHARINGUSAGE Schema. In Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/sql-reference/data-sharing-usage. Section: "Views in This Schema".

- Snowflake Documentation. (n.d.). Provider Usage Views. In Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/native-apps/provider-usage-views. Section: "Provider Usage Views".

Scroll to Top