Which statement describes the results of querying recent_orders?

A table is registered with the following code:

Both users and orders are Delta Lake tables.

Which statement describes the results of querying recent_orders?
A . All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.
B . All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried.
C . Results will be computed and cached when the table is defined; these cached results will incrementally update as new records are inserted into source tables.
D . All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.
E . The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.

View Answer

Answer: B