
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?_
A
The streaming join will fail because the default join type is an outer join.
B
Updates to the conversion_rate table will cause an immediate error in the streaming query._
C
Updates to the conversion_rate table should be made after the current batch is processed and before the next batch arrives._
D
Updates to the conversion_rate table will cause an error when the next batch of data arrives in the transactions table._
E
The conversion_rate table should be updated while the join is in progress with a new batch of data._