SOL-C01 Question #252: Real Exam Question with Answer & Explanation

Question

A team is using Snowsight for developing and testing SQL queries. They want to ensure that all queries executed by a specific user, analystl', are automatically tagged with a custom tag 'team:analyticS. Which of the following methods, leveraging Snowsight or Snowflake features, achieves this goal with minimal administrative overhead? Select all that apply.

Options

• AConfigure the QUERY _ TAG session parameter for each Snowsight worksheet used by `analystl
• BCreate a Snowflake resource monitor that automatically applies the `team:analytics' tag to all
• CUse Snowsight
• DSet the QUERY_TAG parameter at the user level using 'ALTER USER analystl SET QUERY_TAG
• EThere is no method to enforce automatic tagging of queries in Snowsight or Snowflake without

Explanation

Setting the QUERY TAG parameter at the user level (Option D) is the most efficient and centralized way to ensure all queries executed by `analystl are automatically tagged. This avoids the need for individual worksheet configuration. Option A requires manual configuration for each worksheet, which is not ideal. Option B Resource Monitors do not have tagging capabilities. Option C also requires manual updates to each worksheet. Option E is incorrect, as user-level parameter setting provides the desired functionality.

No community discussion yet for this question.