SOL-C01 · Question #18
SOL-C01 Question #18: Real Exam Question with Answer & Explanation
The correct answer is C: External tables provide read-only access to data stored in external cloud storage locations.. Options C and D are correct. External tables provide read-only access to data residing in external cloud storage (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage), and they require a virtual warehouse to be online for querying the data. A is incorrect because external t
Question
Which of the following statements about External Tables in Snowflake are true?
Options
- AExternal tables store data within Snowflake's internal storage.
- BExternal tables can be directly updated using standard SQL DML statements (INSERT, UPDATE,
- CExternal tables provide read-only access to data stored in external cloud storage locations.
- DExternal tables require a virtual warehouse to be online for data access.
- EChanges to the underlying files in the external stage are automatically reflected in the external
Explanation
Options C and D are correct. External tables provide read-only access to data residing in external cloud storage (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage), and they require a virtual warehouse to be online for querying the data. A is incorrect because external tables do not store data in Snowflake's internal storage. B is incorrect because external tables are read-only and cannot be directly updated with DML. E is incorrect because manual refreshing/metadata caching is required after changes to the source data.
Topics
Community Discussion
No community discussion yet for this question.