Certified Data Engineer Professional Exam

Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam

Question 131

A view is registered with the following code:

Both users and orders are Delta Lake tables.

Which statement describes the results of querying recent_orders?

All logic will execute when the view is defined and store the result of joining tables to the DBFS; this stored data will be returned when the view is queried.

Results will be computed and cached when the view is defined; these cached results will incrementally update as new records are inserted into source tables.

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.

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.

Correct Answer: C

A SQL view is a virtual table that provides a way to represent the results of a query as a table. When you query an SQL view, the underlying query is executed against the current state of the data in the source tables at the time the query finishes. This ensures that the most recent data is always retrieved, reflecting any changes that might have occurred in the source tables. Therefore, the correct answer is that 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.

Discussion

Isio05Option: D

Also voting for D, such view results are recalculated each time when called

FreyrOption: D

Correct Answer: D Correct because this option correctly describes the behavior of SQL views in Databricks. The view's query is executed against the current state of the data in the source tables at the moment the query begins. This means that any changes to the data that are committed while the query is running will not be reflected in the results of the query currently executing.

MDWPartnersOption: B

It should be B