Which operation can be performed on Snowflake external tables?
Which operation can be performed on Snowflake external tables?
External tables in Snowflake can participate in JOIN operations with other tables, whether they are external or internal. Other operations typically involve data manipulation or structural changes that are not permitted on read-only external tables.
D is correct
D https://docs.snowflake.com/en/sql-reference/sql/alter-external-table
Option B is the answer. Kindly read the question "Which Operation can be performed" Join is an operation in database but not alter.
If ALTER is not an operation, then what is it?
B External tables are read only. https://docs.snowflake.com/en/user-guide/tables-external-intro#:~:text=External%20tables%20are%20read%2Donly,create%20views%20against%20external%20tables.
Correct, so DML operations cannot be performed (INSERT, UPDATE, DELETE). ALTER is DDL. If you read the link you pasted carefully, you will find ALTER EXTERNAL TABLE statement. Answer is D
B. JOIN External tables in Snowflake can participate in JOIN operations with other tables, whether they are external or internal.
D is correct