SnowPro Core Certification — Question 324
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
Answer options
- A. A directory table is a separate database object.
- B. Directory tables store data file metadata.
- C. A directory table will be automatically added to a stage.
- D. Directory tables do not have their own grantable privileges.
- E. Directory table data can not be refreshed manually.
Correct answer: B, D
Explanation
Option B is correct because directory tables do indeed store metadata about data files, which is essential for managing unstructured data. Option D is also correct as directory tables do not possess their own grantable privileges. The other options are incorrect; A is misleading since a directory table is not an independent entity, C is false because it is not automatically included, and E is inaccurate as data can be refreshed manually under certain conditions.