Which fields are considered Slowly Changing Dimensions? Select all that apply.

Slowly Changing Dimensions (SCD) refer to a type of data in data warehousing that changes slowly over time, rather than changing on a regular schedule. These dimensions are crucial for tracking changes in specific attributes of records while retaining historical data.

Among the options, Lead Stage qualifies as a Slowly Changing Dimension because it represents a status that may evolve over time as a lead progresses through different stages in the sales process, such as from "New" to "Qualified" to "Converted." As these stages are updated, it is essential to preserve the historical context to analyze trends or track performance over time. This ensures that the historical analysis can correctly reflect the journey of leads through their lifecycle.

In contrast, the other options pertain to metrics or timestamps that do not inherently have the same historical tracking requirement. Lead Count is typically a numerical statistic that fluctuates based on current data rather than a state that needs to be preserved historically. Lead Status, while a current state, serves a different purpose and might not be captured with the same historical retention in mind. Lead Modified Date is a timestamp reflecting when a record was last updated but does not necessarily imply a historical state change that needs tracking as part of a dimension.

Thus, only Lead Stage fulfills the criteria of