COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ51

VerifiedAccount Management & Data Governance

An organization is planning a data-structure change to a critical table, SALES_BUDGET, and must identify the users, dashboards, reports, and processes that could be affected.

What action should be taken to determine the impact of this change?

Explanation

The SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY view records object-access history for queries, including the querying user and the accessed tables and columns. Filtering its accessed-object fields for SALES_BUDGET reveals the users and workload dependencies that may be affected by a structural change. Snowflake ACCESS_HISTORY view

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!