Which statement describes the results of querying recent_orders?
A.
The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.
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.
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.
Here the view is getting created not the table. view is only saver select query which will get data from the valid version of the underlying table at the begining of the select statement made on view.
but the option B is materialized stored the data on dbfs....
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
arekm
1 month agobenni_ale
1 month, 4 weeks agodivyapsingh
2 months agotemple1305
2 months agocarlosmps
1 month, 4 weeks ago