nerdexam
Snowflake

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 'team:analytic

Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #252. The question stem and answer options stay visible for context.

Querying and Performance

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

Unlock SOL-C01 to see the answer

You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Query Tagging#Snowflake Parameters#User Configuration#ALTER USER command
Full SOL-C01 Practice