Systems, Applications, and Products (SAP) High-performance Analytic Appliance (HANA) Practice Exam

In the scenario where two tables involved in a left outer join in a view are swapped, changing the join to a right outer join is the appropriate action to maintain the same logical outcome as intended by the original configuration.

When using a left outer join, the left table's records are preserved along with the matching records from the right table. If the tables are swapped, the previous left outer join will now operate as a right outer join, meaning that all records from the new left table (originally the right table) will be included along with the joined records from the new right table (originally the left table). This effectively maintains the desired inclusion of all records from the primary table while allowing for matching from the secondary table.

Opting for a referential join would not correct the issue since it serves a different purpose, often used for enforced relationships based on foreign keys and may not provide the necessary results in this case. Keeping the left outer join would not yield the correct data set after the swap, as it would only include the records from the new left table. Changing to a text join would also be incorrect because text joins have a very specific use case that is unrelated to the context of managing relations between tables.

Thus, converting the left outer