nerdexam
Snowflake

COF-C02 · Question #573

Which views are included in the data_sharing_usage schema? (Select TWO).

The correct answer is D. MONETIZED_USAGE_DAILY E. LISTING TELEMETRY DAILY. The DATA_SHARING_USAGE schema in the Snowflake system database contains views scoped to Snowflake Marketplace listing activity and monetization, not general account operations.

Data Protection and Data Sharing

Question

Which views are included in the data_sharing_usage schema? (Select TWO).

Options

  • AACCESS_HISTORY
  • BDATA_TRANSFER_HISTORY
  • CWAREHOUSE_METERING_HISTORY
  • DMONETIZED_USAGE_DAILY
  • ELISTING TELEMETRY DAILY

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    8% (3)
  • D
    86% (31)

Why each option

The DATA_SHARING_USAGE schema in the Snowflake system database contains views scoped to Snowflake Marketplace listing activity and monetization, not general account operations.

AACCESS_HISTORY

ACCESS_HISTORY resides in the ACCOUNT_USAGE schema and records object-level access events from queries - it is not related to data sharing or marketplace activity.

BDATA_TRANSFER_HISTORY

DATA_TRANSFER_HISTORY is an ACCOUNT_USAGE schema view tracking bytes transferred out of Snowflake, not a data sharing marketplace metric.

CWAREHOUSE_METERING_HISTORY

WAREHOUSE_METERING_HISTORY is in the ACCOUNT_USAGE schema and reports virtual warehouse credit consumption, which is unrelated to data sharing usage.

DMONETIZED_USAGE_DAILYCorrect

MONETIZED_USAGE_DAILY is a DATA_SHARING_USAGE view that reports daily monetization events for provider listings on the Snowflake Marketplace, making it specific to data sharing commerce activity.

ELISTING TELEMETRY DAILYCorrect

LISTING_TELEMETRY_DAILY belongs to DATA_SHARING_USAGE and provides providers with daily metrics on consumer interactions and engagement with their Marketplace listings.

Concept tested: Snowflake DATA_SHARING_USAGE schema view classification

Source: https://docs.snowflake.com/en/sql-reference/data-sharing-usage

Topics

#ACCOUNT_USAGE Views#Data Sharing Usage#Snowflake Marketplace#Data Monetization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice