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 1 year, 11 months agoMallikharjuna452
Most Recent 3 months, 4 weeks ago_yyukta
8 months, 3 weeks agoAfzy
1 year agoMarge23
1 year, 2 months agoMultiCloudIronMan
1 year, 4 months agoc0d3g
1 year, 4 months agotarekff
1 year, 6 months agoRajivnb
1 year, 1 month agovini15
1 year, 7 months agoOmkarshingare
1 year, 7 months agoN89
1 year, 9 months agoSnowProCertDec22
1 year, 11 months agoKate0204
1 year, 11 months ago