nerdexam
Snowflake

COF-C02 · Question #585

What does the Activity area of Snowsight allow users to do? (Select TWO).

The correct answer is B. Explore each step of an executed query. C. Monitor queries executed by users in an account. The Activity area in Snowsight provides observability into query execution within a Snowflake account. It includes two key features: (1) Query History, which allows users with appropriate privileges to monitor all queries executed by users in the account - including status…

Performance Management

Question

What does the Activity area of Snowsight allow users to do? (Select TWO).

Options

  • ASchedule automated data backups.
  • BExplore each step of an executed query.
  • CMonitor queries executed by users in an account.
  • DCreate and manage user roles and permissions.
  • EAccess Snowflake Marketplace to find and integrate datasets.

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    89% (25)
  • E
    4% (1)

Explanation

The Activity area in Snowsight provides observability into query execution within a Snowflake account. It includes two key features: (1) Query History, which allows users with appropriate privileges to monitor all queries executed by users in the account - including status, duration, and resource usage; and (2) Query Profile, which allows users to drill into a specific executed query and explore each step of its execution plan as a visual tree, helping diagnose performance bottlenecks. The other options are incorrect: backups are managed via Fail-safe/Time Travel (not Activity), role management is in Admin > Users & Roles, and Marketplace is its own separate section.

Topics

#Snowsight#Query Monitoring#Query History#Query Profile

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice