For a query to execute across tenant databases in an SAP HANA multitenant database container, which prerequisites are needed?

In a multitenant database container (MDC) setup in SAP HANA, executing queries across different tenant databases requires proper user mapping. This is essential because each tenant database can have its own set of users and roles that govern access to objects within that database. User mapping ensures that when a query is executed that spans multiple tenants, the system knows how to authenticate and authorize the user across these different contexts.

Specifically, user mapping allows you to define how users from one tenant database can access the data and resources in another tenant database. Without proper user mapping, the system cannot accurately determine the permissions for the user in the context of the target databases, which would prevent the query from executing successfully.

In contrast, the other options either do not pertain directly to the ability to query across tenant databases or are not specifically required as prerequisites for executing such queries. Server authorization is broader and relates more to overall system access rather than specifically addressing cross-tenant operations. Data redundancy checks and response time analysis concern the performance and reliability of data rather than the logistics of executing queries across tenants. Thus, user mapping is the critical element that allows for successful cross-tenant query execution within a multitenant architecture.