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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MatthieuDN
2 months, 3 weeks agoMultiCloudIronMan
3 months agoMitchdu
3 months, 2 weeks agoaral
4 months, 3 weeks agoMSIDDIQUI18
6 months agoMitchdu
3 months, 2 weeks agocharatepallavi07
11 months, 2 weeks agoede3703
1 year agoVenkataPhaniPavanKumar
1 year agoyaho5
1 year agonexerSnow
1 year, 1 month agoVenkataPhaniPavanKumar
1 year, 1 month agoyaho5
1 year ago56d43d6
3 months, 3 weeks agoNachoPrendes
1 year, 1 month ago