Practice Questions · Part 2
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
SnowPro Core COF-C03 Study GuidePart 2: Warehouses and performancePractice Questions: Part 2
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
A resource monitor on BI_WH has ON 100 PERCENT DO SUSPEND. When the quota is reached, a 20-minute aggregation is halfway through on BI_WH. What happens to it?
An Enterprise edition account runs dashboards on REPORTING_WH, a Medium warehouse. Every weekday from 09:00 to 10:00, hundreds of short queries queue, although each one runs fast once it starts. Which change fixes this at the lowest cost?
Which two queries are typical candidates for the Query Acceleration Service? (Choose two.)
INSERT … SELECT that scans a large table and writes millions of rowsRANDOM()A data engineer runs ALTER TABLE shipments ADD SEARCH OPTIMIZATION ON EQUALITY(tracking_no, status) on a 3 TB SHIPMENTS table. About 80% of shipments have the status 'DELIVERED'. Which query does this speed up most directly?
SELECT * FROM shipments WHERE tracking_no = '1Z9X42';SELECT carrier, COUNT(*) FROM shipments GROUP BY carrier;SELECT * FROM shipments WHERE ship_date BETWEEN '2026-01-01' AND '2026-03-31';SELECT * FROM shipments WHERE status = 'DELIVERED';Which table is the best candidate for a clustering key?
A Query Profile shows a Join operator receiving 2,000 rows on one side and 2 million on the other, and producing 4 billion rows. What is the most likely cause?
The Query Profile of a slow aggregation shows 40 GB spilled to local storage and 12 GB spilled to remote storage. Which change most directly addresses this?
Which three can't be used in the definition of a materialized view? (Choose three.)
A Medium multi-cluster warehouse (4 credits per hour per cluster) runs 3 clusters from 09:00 to 10:00, then 1 cluster from 10:00 to 12:00. How many credits does it consume over those three hours?
A team wants extra clusters to start only when Snowflake estimates enough queued work to keep a new cluster busy for at least six minutes, accepting some queuing to save credits. Which configuration matches?
Which two statements about multi-cluster warehouses are correct? (Choose two.)
An administrator tries to set the maximum cluster count of an X-Small multi-cluster warehouse to 40 in Snowsight, and the form won't accept more than 10. What is true?
A Snowpark Python stored procedure that trains a model on a Medium standard warehouse fails with out-of-memory errors, while CPU use never goes above 30%. Which fix targets the bottleneck at the lowest cost?
A FinOps lead must be alerted when the combined monthly spend of a Snowpipe pipe, Automatic Clustering on one table and two warehouses is projected to exceed 500 credits. Which feature fits?
A suspended warehouse with AUTO_SUSPEND = 300 is resumed and runs a 25-second query. Ten seconds after it finishes, a 70-second query runs, and an administrator suspends the warehouse as soon as that query ends. How much compute time is billed for this start?
In an Enterprise edition account, a custom role must run ALTER TABLE events ADD SEARCH OPTIMIZATION ON EQUALITY(user_id). Which two privileges does the role need for this statement? (Choose two.)
A team wants BI_WH suspended automatically when the custom budget that covers it projects an overspend. What should they do?
A data engineer needs credit consumption per warehouse for the last 11 months for a chargeback report. Which source should be queried?
SHOW WAREHOUSESSNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY viewINFORMATION_SCHEMA.WAREHOUSE_METERING_HISTORY table functionETL_WH is resized from Medium to X-Large while three statements are running on it. What happens to those three statements?
Which statement about Gen2 standard warehouses is correct?
Which two costs come from Snowflake-managed background services rather than from a warehouse you run? (Choose two.)
WAREHOUSE = etl_whA FinOps team wants to know which warehouses in the account would benefit most from the Query Acceleration Service, based on past workload. Where should it look first?
SNOWFLAKE.ACCOUNT_USAGE.QUERY_ACCELERATION_ELIGIBLESYSTEM$CLUSTERING_INFORMATION on the largest tablesSNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORYA data engineer is writing the CREATE WAREHOUSE statement for a warehouse that will run a few short queries a day. Which two settings reduce the credits it consumes while no queries are running? (Choose two.)
SCALING_POLICY = 'ECONOMY'MAX_CONCURRENCY_LEVEL = 4STATEMENT_TIMEOUT_IN_SECONDS = 600AUTO_SUSPEND = 120INITIALLY_SUSPENDED = TRUEIn the Query Profile, the statistic "Percentage scanned from cache" refers to data served from which cache?
SYSTEM$CLUSTERING_DEPTH on a SHIPMENTS table clustered by SHIP_DATE returned 1.4 in March and 31 in September. What does this mean?
A data engineer needs to stop Automatic Clustering on SHIPMENTS temporarily without dropping its clustering key. Which statement does this?
ALTER TABLE shipments SET DATA_RETENTION_TIME_IN_DAYS = 0;ALTER WAREHOUSE load_wh SUSPEND;ALTER TABLE shipments DROP CLUSTERING KEY;ALTER TABLE shipments SUSPEND RECLUSTER;A role named FINOPS must query SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY without using ACCOUNTADMIN. Which two grants give it access? (Choose two.)
GRANT DATABASE ROLE snowflake.governance_viewer TO ROLE finops;GRANT SELECT ON VIEW snowflake.account_usage.warehouse_metering_history TO ROLE finops;GRANT DATABASE ROLE snowflake.usage_viewer TO ROLE finops;GRANT IMPORTED PRIVILEGES ON DATABASE snowflake TO ROLE finops;GRANT MONITOR ON WAREHOUSE etl_wh TO ROLE finops;SHOW MATERIALIZED VIEWS shows that MV_STORE_TOTALS is behind its base table. What should a data engineer do so that queries on the view return current results?
CREATE OR REPLACEALTER MATERIALIZED VIEW mv_store_totals REFRESHA warehouse has ENABLE_QUERY_ACCELERATION = TRUE and QUERY_ACCELERATION_MAX_SCALE_FACTOR = 0. What does the 0 mean?
Which two choices follow Snowflake's guidance for defining a clustering key? (Choose two.)
TO_DATE()Finish this set to count it as done.