Performing DML operations, such as:
Updating rows in tables (DELETE , INSERT , UPDATE).
Loading data into tables (COPY INTO <table>).
Unloading data from tables (COPY INTO <location>)
https://docs.snowflake.com/en/user-guide/warehouses
Performing DML operations, such as:
Updating rows in tables (DELETE , INSERT , UPDATE). (Answer D)
Loading data into tables (COPY INTO <table>).
Unloading data from tables (COPY INTO <location>). (Answer A)
a warehouse must be running and in use for the session.
Cannot be D. Altering table does not require a compute. Alter table is not altering data. its altering the definition. like changing Column type, removing a column or adding a new column. basically CREATE, ALTER. not the DML.
A also cannot be correct. They said downloading data. it did not say clearly that Loading/Unloading data. downloading could be a downloading a file from internal stage to local machine.
Not sure if materialized view will require a running cluster as data is already computed and may reside in cache. But alter table will definitely require a running cluster.
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.
SnowProCertDec22
Highly Voted 2 years, 2 months agoMultiCloudIronMan
Most Recent 1 week, 6 days agoMultiCloudIronMan
1 week, 6 days agoMallikharjuna452
7 months ago_yyukta
12 months agoAfzy
1 year, 3 months agoMarge23
1 year, 5 months agoMultiCloudIronMan
1 year, 7 months agoc0d3g
1 year, 7 months agotarekff
1 year, 9 months agoRajivnb
1 year, 4 months agovini15
1 year, 10 months agoOmkarshingare
1 year, 10 months agoN89
2 years agoSnowProCertDec22
2 years, 2 months agoKate0204
2 years, 2 months ago