フリー問題

問題文

An interactive notebook derives one intermediate DataFrame and then uses it in five separate reports. Each report recomputes the intermediate result from the base tables. Which call materializes the intermediate result so the later work reads it instead?

選択肢

1. A sample of the intermediate result of the base tables, which stands in for the full set in the later reports.
2. A collect followed by create_dataframe over the returned rows, which is the documented way to reuse an intermediate result inside Snowflake.
3. The call that returns the list of queries the DataFrame of the job would run, because reading that list pins the plan for reuse.
4. The call that caches the content of the DataFrame, and returns a table object over a temporary table, holding the result.