hiexam
snowflake · SnowPro-Advanced-Architect · Q602 · multiple_response · topic_1

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
  • A.The MERGE command
  • B.The UPSERT command
  • C.The CHANGES clause
  • D.A STREAM object
  • E.Thee CHANGE_DATA_CAPTURE command
Explanation
The built-in Snowflake features that make use of the change tracking metadata for a table are the CHANGES clause and a STREAM object. Therefore, options (C) and (D) are the correct answers.

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.