A tag named DEPARTMENT has two values, MARKETING and FINANCE. Which command will add a third value, ENGINEERING, to the tag?

Question

Options

• AALTER TAG DEPARTMENT ADD ALLOWED_VALUES 'ENGINEERING';
• BALTER TAG DEPARTMENT MODIFY ALLOWED_VALUES 'ENGINEERING';
• CALTER TAG DEPARTMENT SET TAG DEPARTMENT = 'ENGINEERING';
• DALTER TAG DEPARTMENT DROP ALLOWED VALUES 'MARKETING', 'FINANCE' ADD

• A
  89% (31)
• B
  6% (2)
• C
  3% (1)
• D
  3% (1)

Explanation

Option A uses the correct ADD ALLOWED_VALUES clause, which appends a new value to the existing allowed values list without touching MARKETING or FINANCE - exactly what the question asks for.

Why the distractors fail:

• B uses MODIFY, which is not valid syntax for tag allowed values in Snowflake; MODIFY applies to other object properties like column definitions.
• C uses SET TAG, which is the syntax for applying a tag to a database object (e.g., a table or column), not for editing the tag's own allowed values.
• D would first DROP the existing values, destroying MARKETING and FINANCE, and the statement is also syntactically incomplete - wrong approach and wrong result.

Memory tip: Think "ADD adds, SET applies." ADD ALLOWED_VALUES manages what values a tag can hold; SET TAG puts a tag on an object. When you see a question about expanding a tag's value list, reach for ALTER TAG ... ADD ALLOWED_VALUES.

No community discussion yet for this question.