Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

A security review identified several roles that are no longer being used. Which of the roles can be dropped?

What is the default authentication method while using the JDBC driver connection in Snowflake?

A user manages a 2 TB sales table clustered by order_date. Multiple teams query this data, but one specific team repeatedly filters on the region column, retrieving only a few thousand rows per query across hundreds of daily requests. The table is refreshed weekly, and no other teams report performance problems. Which action should be taken to optimize query performance for this specific team?

By default, which system roles can create and manage users? (Select TWO)