SOL-C01 · Question #252
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…
The correct answer is D. Set the QUERY_TAG parameter at the user level using 'ALTER USER analystl SET QUERY_TAG. 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…
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
How the community answered
(28 responses)- B7% (2)
- C4% (1)
- D86% (24)
- E4% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.