Which of the following operations require the use of a running virtual warehouse? (Choose two.)
Which of the following operations require the use of a running virtual warehouse? (Choose two.)
Executing a stored procedure generally requires the use of a running virtual warehouse because it involves procedural logic that might access or manipulate data, actions which typically necessitate compute resources. Querying data from a materialized view also requires computation as it involves fetching pre-computed results, for which a virtual warehouse must be operational to retrieve and process the data. Downloading data from an internal stage, listing files in a stage, and altering a table usually do not require computation resources from a running virtual warehouse, as these actions typically involve metadata operations or non-compute-intensive tasks.
C & E https://docs.snowflake.com/en/user-guide/warehouses.html
C & E https://docs.snowflake.com/en/user-guide/warehouses.html
Answer is correct C&D Materialised views are pre computed it does require warehouse.
These 3 do not require active Warehouse: Downloading data from an internal stage Listing files in a stage Creating and Altering table.
Hmmm not sure about this, maybe E
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.
C & D IS CORRECT
Correct
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
C and E is the answer
CE are correct
C and E are correct
Material view does not require a warehouse
Sorry I think virtual warehouse is needed for material view but it fetches the data quicker than running a full table scan.