SOL-C01 · Question #179
SOL-C01 Question #179: Real Exam Question with Answer & Explanation
The correct answer is D: Create an external stage pointing to the S3 bucket with 'ENABLE DIRECTORY = TRUE specified. To enable directory tables, you must set 'ENABLE DIRECTORY = TRUE' when creating the stage or using ALTER STAGE. Then, 'ALTER STAGE REFRESH;' populates the directory table with the file metadata. The directory table is not automatically updated and needs to be refreshed
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
Explanation
To enable directory tables, you must set 'ENABLE DIRECTORY = TRUE' when creating the stage or using ALTER STAGE. Then, 'ALTER STAGE REFRESH;' populates the directory table with the file metadata. The directory table is not automatically updated and needs to be refreshed
Topics
Community Discussion
No community discussion yet for this question.