Exam SnowPro Core topic 1 question 1016 discussion

The below command creates a directory table for an internal stage with auto refresh https://docs.snowflake.com/en/user-guide/data-load-dirtables-auto CREATE STAGE my_int_stage DIRECTORY = ( ENABLE = TRUE AUTO_REFRESH = TRUE );

Confused between A and B

https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage After you create a stage with a directory table, you must execute ALTER STAGE … REFRESH to manually refresh the directory table metadata.

B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage "Directory tables on internal stages require manual metadata refreshes." https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-auto-refreshes "You can automatically refresh the metadata for a directory table by using the event messaging service for your cloud storage service."

Answer is B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-refreshes Directory tables on internal stages require manual metadata refreshes. This command creates an internal Snowflake stage since it doesn't specify an external cloud storage location. I ran this command in Snowflake and it was valid and using SHOW STAGES; I validated that it was an internal stage, so the answer is B

Answer is A, test it in your snow account.

Checked on Snowflake