What system privilege is required to redistribute tables across hosts in a scale-out SAP HANA system?

The privilege required to redistribute tables across hosts in a scale-out SAP HANA system is the RESOURCE ADMIN privilege. This privilege allows a user to manage system resources effectively, including the ability to distribute and manage data across different nodes in a distributed environment.

In a scale-out architecture, SAP HANA operates across multiple hosts, and the redistribution of tables is crucial for load balancing and optimal performance. The RESOURCE ADMIN privilege is specifically designed for users who need to handle resource-related tasks, such as redistributing data and managing data placement across these hosts.

The other privileges mentioned serve different purposes: ADMIN encompasses a wider range of administrative tasks, USER ADMIN is more related to user management and security, and DATA ADMIN is typically focused on data-related operations but does not extend to resource redistribution across hosts. Thus, RESOURCE ADMIN is essential for the task at hand, making it the correct answer.