
Ultimate access to all questions.
In a production environment, a query is set up to update the ledger table with the latest data from the transactions table, while the conversion_rate table is updated manually (static table). The query uses a streaming join. Which statement accurately describes the functionality of this join?