Which statement describes the results of querying recent_orders?
A.
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.
B.
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.
C.
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.
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.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
benni_ale
2 weeks, 5 days agoIsio05
5 months, 2 weeks agoFreyr
5 months, 3 weeks agoMDWPartners
5 months, 4 weeks ago