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 https://docs.snowflake.com/en/sql-reference/sql/alter-external-table
D is correct
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
Alter external table operates on the external table's metadata, not on the data in the external table itself. but queries and joins on the external table is allowed. B
Alter external table operates on the external table's metadata, not on the data in the external table itself. but queries and joins on the external table is allowed. B
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. JOIN External tables in Snowflake can participate in JOIN operations with other tables, whether they are external or internal.
D is correct
Answer "B" is correct. External tables are read-only. You cannot perform data manipulation language (DML) operations on them. However, you can use external tables for query and join operations. You can also create views against external tables.
ALTER is not a DML statement but a DDL. And yes, DDL statements like DROP is allowed. So ALTER is the answer.
You cannot alter extrenal tables in any way
External tables can be dropped. So ALTER.
Answer is asking operations, Alter is not an operation, its modification so answer is JOIN operation in a query
Agree with B although it's a trick question