問題文
A warehouse has been running for two hours and a repeated report has become noticeably faster over that period, even though the underlying table is loaded continuously. What explains the improvement?
選択肢
- The warehouse has accumulated the frequently read files in its local storage, so later runs read less from remote storage.
- The table has been reclustered automatically because the report kept filtering on the same column.
- The result of the report is being reused for every later run, because the text of the statement has not changed at any point during the two hours.
- The metadata layer has learned the shape of the query and now answers it from metadata without reading data.