問題文
An analyst has a folder of compressed CSV files in object storage and wants to join them with a table in the database, without loading them first. What has to be in place?
選択肢
- A connection object for the bucket and a database link to the bucket, so the files can be read as a remote table and joined with the local data.
- A staging schema for the bucket and a materialized view over the files, so the files can be refreshed into a table and joined with the local data.
- A credential object for the bucket and an external table defined over the files, so the files can be read as a table and joined with the local data.
- A network file system mount for the bucket and a synonym over the files, so the files can be read as a table and joined with the local data.