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?
Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam
Certified Data Engineer Professional Exam - Question 131
Show AnswerHide Answer
Correct Answer: CD
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
3 commentsMDWPartnersOption: B
May 30, 2024It should be B
FreyrOption: D
Jun 1, 2024Correct 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.
Isio05Option: D
Jun 8, 2024Also voting for D, such view results are recalculated each time when called