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? | Databricks Certified Data Engineer - Professional Quiz - LeetQuiz