SOL-C01 · Question #179
You have a Snowflake external stage configured to access Parquet files in an AWS S3 bucket. You want to query these Parquet files directly using Snowflake without explicitly loading them into a table.
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #179. The question stem and answer options stay visible for context.
Question
You have a Snowflake external stage configured to access Parquet files in an AWS S3 bucket. You want to query these Parquet files directly using Snowflake without explicitly loading them into a table. You also want to enable directory tables for this external stage. Which of the following steps are necessary to enable directory tables for the external stage and query the data?
Options
- ACreate an external stage pointing to the S3 bucket, then execute 'ALTER STAGE SET
- BCreate an external stage pointing to the S3 bucket, then execute 'ALTER STAGE REFRESH;' ,
- CCreate an external stage pointing to the S3 bucket, execute 'ALTER STAGE SET
- DCreate an external stage pointing to the S3 bucket with 'ENABLE DIRECTORY = TRUE specified
- ECreate an external stage pointing to the S3 bucket with 'ENABLE DIRECTORY = TRUE specified
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.