Which connection types are allowed with system replication using the Active/Active option?

The Active/Active option for system replication in a high-performance analytic environment like HANA allows certain configurations to optimize data availability and load balancing. With explicit read-only connections on the secondary system, users can run analytics queries or report generation tasks without affecting the performance of the primary system. This setup means that while the primary database handles write operations and critical transactions, read operations can be distributed efficiently.

This configuration helps in maximizing resource utilization since queries that do not need to modify data can be offloaded to the secondary system. By allowing these explicit read-only connections, the system ensures that users can access the data with minimal latency while maintaining the integrity and performance of the primary system.

The other options do not align with the expected or optimal practices in the active/active replication configuration. For example, implicit hint-based statement routing may introduce complexity and not provide the required reliability; direct read requests on the primary system do not take advantage of the load-balancing benefits; and queuing on the secondary for performance is not a standard practice in active/active replication where immediacy and availability are key.