Which tool would you use to perform operations on row-based data at ingestion time?

• A. Calculated Insights
• B. Operators
• C. Formula
• D. Visual Insights Builder

Answer: (C)

Performing operations on row-based data as it flows in requires a per-row transformation capability. A Formula tool lets you write expressions that operate on the fields of each incoming row, producing new values or updating existing ones on the fly. This is exactly what you need at ingestion time: you can derive new attributes, normalize data, or compute derived metrics as each row is ingested, ensuring the data store contains the transformed values right away. You can use arithmetic, string manipulation, dates, and conditional logic within a single expression, making it a concise and consistent way to process data during ETL.

The other options sit at different stages or focus on different tasks. Calculated Insights is geared toward deriving insights after data is loaded, not transforming rows during ingestion. Visual Insights Builder is about building dashboards and visual analyses, not changing the data as it enters the system. Operators imply some rule-based or procedural actions but aren’t the standard tool for per-row field-level calculations during ingestion.