Câu 2: Databricks Certified Data Engineer Professional

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?

1. 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.
2. 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. — đáp án hiện tại
3. 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.
4. 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.
5. 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.