Question 400
For this Snowflake situation — An unstructured document workflow wants to discover files present on an external stage without loading their contents into a relational table. — the team adopts: Enable and query supported directory-table metadata for the configured stage. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Monitor directory refresh configuration and underlying storage permission changes. It controls the recurring exposure associated with this mechanism: Directory tables expose file inventory information from staged object storage for supported workflows. The original action, enable and query supported directory-table metadata for the configured stage., still needs operational checks when the environment or workload changes.
Incorrect Answers
This routine guards against another mechanism: Snowflake stage syntax selects distinct storage namespaces with different ownership and usage patterns. The recurring exposure in the current case is: Directory tables expose file inventory information from staged object storage for supported workflows. The matching preventive check is “Monitor directory refresh configuration and underlying storage permission changes”.
The suggested review tracks a different technical risk: Connectivity can fail at network-source authorization even when credentials and object grants are valid. Here the sustained control must address: Directory tables expose file inventory information from staged object storage for supported workflows. Choose “Monitor directory refresh configuration and underlying storage permission changes”.
This routine guards against another mechanism: Snowflake's Kafka connector integrates compatible Kafka topics with supported Snowflake ingestion modes. The recurring exposure in the current case is: Directory tables expose file inventory information from staged object storage for supported workflows. The matching preventive check is “Monitor directory refresh configuration and underlying storage permission changes”.