Snowflake provides two ways to view replication costs incurred with database replication. Which are they?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Snowflake provides two ways to view replication costs incurred with database replication. Which are they?

Explanation:
The concept being tested is where Snowflake exposes replication usage data for cost tracking. Snowflake provides two ways to view this information: a table function in Information_schema called REPLICATION_USAGE_HISTORY, and a regular view in Account Usage called REPLICATION_USAGE_HISTORY. The table function returns replication usage rows when you query it with TABLE(...), which is handy for parameterizing the time window and filters in a single query. The Account Usage view sits in the SNOWFLAKE.ACCOUNT_USAGE schema, offering the same data in a standard view format that’s convenient for joining with other usage metrics and building reports. Since both paths access the replication usage history, both are valid options depending on how you prefer to query and integrate the data.

The concept being tested is where Snowflake exposes replication usage data for cost tracking. Snowflake provides two ways to view this information: a table function in Information_schema called REPLICATION_USAGE_HISTORY, and a regular view in Account Usage called REPLICATION_USAGE_HISTORY. The table function returns replication usage rows when you query it with TABLE(...), which is handy for parameterizing the time window and filters in a single query. The Account Usage view sits in the SNOWFLAKE.ACCOUNT_USAGE schema, offering the same data in a standard view format that’s convenient for joining with other usage metrics and building reports. Since both paths access the replication usage history, both are valid options depending on how you prefer to query and integrate the data.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy