Can DTS be configured for real-time data integration?

DTS (Data Transformation Services) can indeed be configured for close-to-real-time data integration, which is why this choice is correct. DTS is capable of processing data in a way that minimizes latency, allowing for frequent updates and data transformations that reflect changes almost immediately. This is typically achieved through mechanisms that enable timely data loading from various sources, supporting processes that require updated information without significant delays.

While DTS can handle batch processing, which involves collecting data over a specific period and then processing it all at once, it also has capabilities that allow for near real-time updates. This flexibility makes DTS a valuable tool for scenarios where data freshness is critical, such as in business intelligence and operational analytics, where decision-makers need current information to make informed choices.

The other options do not accurately represent DTS's capabilities. For instance, stating that DTS is always real-time or only for batch processing overlooks its ability to bridge both online and batch environments effectively. Additionally, suggesting that it requires external tools does not account for its built-in functionalities that support near real-time configurations. Thus, the choice that emphasizes close-to-real-time loads acknowledges the balance DTS achieves between immediate data processing needs and its operational functionalities.