External tables support views, query and join operations?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

External tables support views, query and join operations?

Explanation:
External tables let you treat data stored outside Snowflake as if it were a table inside Snowflake. You can run standard SQL against them, including selecting, joining with other tables, and using them inside views. This means you can create a view that references an external table, or join an external table with internal tables in a single query. The data remains read-only in Snowflake, but for querying and combining data from external sources, external tables behave like regular tables. So the statement is true.

External tables let you treat data stored outside Snowflake as if it were a table inside Snowflake. You can run standard SQL against them, including selecting, joining with other tables, and using them inside views. This means you can create a view that references an external table, or join an external table with internal tables in a single query. The data remains read-only in Snowflake, but for querying and combining data from external sources, external tables behave like regular tables. So the statement is true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy