What capability allows visibility to data that is joined between multiple tables?

The capability that allows visibility to data joined between multiple tables is known as database views. A database view acts as a virtual table that presents data from one or more underlying tables in a structured manner. It can combine data from various sources, enabling users to retrieve and manipulate that data as if it were coming from a single table. This is particularly useful in scenarios where there is a need to simplify complex queries, maintain data security by restricting access to certain columns or rows, and improve overall data management.

In contrast, metric tables are primarily used to store and analyze metrics and measurements, published reports are typically formatted outputs of data meant for distribution, and custom tables are user-defined tables that extend the data model but may not inherently provide the same capability for joining and presenting data from multiple other tables. Thus, database views are specifically designed for the purpose of integrating and displaying information from multiple sources, making them the correct choice in this context.