Explanation:
In a stream-static join, each batch of data is joined with the current state of the static table. Therefore, no error will occur if updates are made to the conversion_rate table, and these updates will only affect the next batch of data. To ensure correct results, updates to the conversion_rate table should be made in the 30-minute window between triggers. Changing the data during processing can lead to ambiguous results. The default join type is an inner join, and a stream-static outer join is not supported and would result in an error.
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.
No comments yet.