For which of the following can transformation variables be used?

Question

Options

• ATo save data to the output JSON file
• BTo save data temporarily
• CTo save data permanently

• A
  8% (2)
• B
  75% (18)
• C
  17% (4)

Explanation

Transformation variables are temporary storage containers used during data processing or ETL workflows - they hold values in memory only for the duration of the transformation, then discard them once the process completes. This makes option B correct.

Why A is wrong: Transformation variables don't write to output files. Writing to an output JSON file is handled by output mappings or destination configurations, not by transformation variables themselves.

Why C is wrong: "Permanently" implies persistence beyond the transformation's lifecycle - to a database, file, or external store. Transformation variables exist only in working memory and are gone once the transformation ends.

Memory tip: Think of transformation variables like a sticky note on your desk - useful while you're working on a task, but you throw it away when you're done. If you need to keep the data, you'd write it somewhere permanent (a file or database), which transformation variables can't do.

No community discussion yet for this question.